SQL server Installation
I have received a new server. The server has the following specification.
It has 500 gig 7.2K RPM disk,
SSD
NVME
1.2 TB 10K RPM disk.
All are in RAID 1.
I am planning to install Windows Sever on the 7.2K RPM disks. I want to install SQL Server on the OS drive( i.e. 7.2K RPM drive). I am planning to keep log and data files on SSD and NVME. The 10k RPM drive will be used for backups.
NVME drive is faster than SSD.
My Windows team recommend that I should install Windows Server on the SSD or 10K drives for performance. But all I care is about SQL Server performance. I don't think that Windows Server will perform badly on the 7.2k drive.
Does anyone see a reason to install Windows Server on any drive other than the 7.2K RPM drives?
sql-server performance ssd
edited Jan 10 '17 at 8:37
James Anderson
5,03021839
asked Jan 10 '17 at 7:50
G.T.G.T.
162
bumped to the homepage by Community♦ 24 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have received a new server. The server has the following specification.
It has 500 gig 7.2K RPM disk,
SSD
NVME
1.2 TB 10K RPM disk.
All are in RAID 1.
I am planning to install Windows Sever on the 7.2K RPM disks. I want to install SQL Server on the OS drive( i.e. 7.2K RPM drive). I am planning to keep log and data files on SSD and NVME. The 10k RPM drive will be used for backups.
NVME drive is faster than SSD.
My Windows team recommend that I should install Windows Server on the SSD or 10K drives for performance. But all I care is about SQL Server performance. I don't think that Windows Server will perform badly on the 7.2k drive.
Does anyone see a reason to install Windows Server on any drive other than the 7.2K RPM drives?
sql-server performance ssd
edited Jan 10 '17 at 8:37
James Anderson
5,03021839
asked Jan 10 '17 at 7:50
G.T.G.T.
162
bumped to the homepage by Community♦ 24 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
How much RAM does the server have and will you rely upon swap files?
– Sir Swears-a-lot
Jan 10 '17 at 8:35
128 GB RAM, I am planning to move SWAP file to other drive.
– G.T.
Jan 10 '17 at 9:08
add a comment |
I have received a new server. The server has the following specification.
It has 500 gig 7.2K RPM disk,
SSD
NVME
1.2 TB 10K RPM disk.
All are in RAID 1.
I am planning to install Windows Sever on the 7.2K RPM disks. I want to install SQL Server on the OS drive( i.e. 7.2K RPM drive). I am planning to keep log and data files on SSD and NVME. The 10k RPM drive will be used for backups.
NVME drive is faster than SSD.
My Windows team recommend that I should install Windows Server on the SSD or 10K drives for performance. But all I care is about SQL Server performance. I don't think that Windows Server will perform badly on the 7.2k drive.
Does anyone see a reason to install Windows Server on any drive other than the 7.2K RPM drives?
sql-server performance ssd
edited Jan 10 '17 at 8:37
James Anderson
5,03021839
asked Jan 10 '17 at 7:50
G.T.G.T.
162
I have received a new server. The server has the following specification.
It has 500 gig 7.2K RPM disk,
SSD
NVME
1.2 TB 10K RPM disk.
All are in RAID 1.
I am planning to install Windows Sever on the 7.2K RPM disks. I want to install SQL Server on the OS drive( i.e. 7.2K RPM drive). I am planning to keep log and data files on SSD and NVME. The 10k RPM drive will be used for backups.
NVME drive is faster than SSD.
My Windows team recommend that I should install Windows Server on the SSD or 10K drives for performance. But all I care is about SQL Server performance. I don't think that Windows Server will perform badly on the 7.2k drive.
Does anyone see a reason to install Windows Server on any drive other than the 7.2K RPM drives?
sql-server performance ssd
sql-server performance ssd
edited Jan 10 '17 at 8:37
James Anderson
5,03021839
asked Jan 10 '17 at 7:50
G.T.G.T.
162
edited Jan 10 '17 at 8:37
James Anderson
5,03021839
asked Jan 10 '17 at 7:50
G.T.G.T.
162
edited Jan 10 '17 at 8:37
James Anderson
5,03021839
edited Jan 10 '17 at 8:37
James Anderson
5,03021839
edited Jan 10 '17 at 8:37
James Anderson
5,03021839
5,03021839
asked Jan 10 '17 at 7:50
G.T.G.T.
162
asked Jan 10 '17 at 7:50
G.T.G.T.
162
asked Jan 10 '17 at 7:50
G.T.G.T.
162
162
bumped to the homepage by Community♦ 24 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 24 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
How much RAM does the server have and will you rely upon swap files?
– Sir Swears-a-lot
Jan 10 '17 at 8:35
128 GB RAM, I am planning to move SWAP file to other drive.
– G.T.
Jan 10 '17 at 9:08
add a comment |
1
How much RAM does the server have and will you rely upon swap files?
– Sir Swears-a-lot
Jan 10 '17 at 8:35
128 GB RAM, I am planning to move SWAP file to other drive.
– G.T.
Jan 10 '17 at 9:08
1
1
How much RAM does the server have and will you rely upon swap files?
– Sir Swears-a-lot
Jan 10 '17 at 8:35
How much RAM does the server have and will you rely upon swap files?
– Sir Swears-a-lot
Jan 10 '17 at 8:35
128 GB RAM, I am planning to move SWAP file to other drive.
– G.T.
Jan 10 '17 at 9:08
128 GB RAM, I am planning to move SWAP file to other drive.
– G.T.
Jan 10 '17 at 9:08
add a comment |
1 Answer
1
active
oldest
votes
In short, put the OSes on slow storage and all the data/log & backup files on fast storage.
I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.
We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.
We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.
answered Jan 12 '17 at 16:40
Sean PerkinsSean Perkins
70821532
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f160513%2fsql-server-installation%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In short, put the OSes on slow storage and all the data/log & backup files on fast storage.
I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.
We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.
We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.
answered Jan 12 '17 at 16:40
Sean PerkinsSean Perkins
70821532
add a comment |
In short, put the OSes on slow storage and all the data/log & backup files on fast storage.
I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.
We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.
We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.
answered Jan 12 '17 at 16:40
Sean PerkinsSean Perkins
70821532
add a comment |
In short, put the OSes on slow storage and all the data/log & backup files on fast storage.
I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.
We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.
We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.
answered Jan 12 '17 at 16:40
Sean PerkinsSean Perkins
70821532
In short, put the OSes on slow storage and all the data/log & backup files on fast storage.
I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.
We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.
We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.
answered Jan 12 '17 at 16:40
Sean PerkinsSean Perkins
70821532
answered Jan 12 '17 at 16:40
Sean PerkinsSean Perkins
70821532
answered Jan 12 '17 at 16:40
Sean PerkinsSean Perkins
70821532
answered Jan 12 '17 at 16:40
Sean PerkinsSean Perkins
70821532
70821532
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f160513%2fsql-server-installation%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
How much RAM does the server have and will you rely upon swap files?
– Sir Swears-a-lot
Jan 10 '17 at 8:35
128 GB RAM, I am planning to move SWAP file to other drive.
– G.T.
Jan 10 '17 at 9:08