SQL server InstallationStop SQL Server service(s) before defragmenting drive?Optimal drive configuration for...
Have any astronauts or cosmonauts died in space?
Can a Hydra make multiple opportunity attacks at once?
Do these large-scale, human power-plant-tending robots from the Matrix movies have a name, in-universe or out?
How to know if I am a 'Real Developer'
What is formjacking?
Is it common to refer to someone as "Prof. Dr. [LastName]"?
How do I split ammo?
In the Lost in Space intro why was Dr. Smith actor listed as a special guest star?
Why do we interpret the accelerated expansion of the universe as the proof for the existence of dark energy?
Why is quixotic not Quixotic (a proper adjective)?
Why don't you get burned by the wood benches in a sauna?
How do I add a strong "onion flavor" to the biryani (in restaurant style)?
Why do single electrical receptacles exist?
How to play songs that contain one guitar when we have two or more guitarists?
Sets which are both Sum-free and Product-free.
When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?
Why would you use 2 alternate layout buttons instead of 1, when only one can be selected at once
Is there any danger of my neighbor having my wife's signature?
Buying a "Used" Router
What's the function of the word "ли" in the following contexts?
Can a planet be tidally unlocked?
Is it Safe to Plug an Extension Cord Into a Power Strip?
How do I write a maintainable, fast, compile-time bit-mask in C++?
If I have Haste cast on me, does it reduce the casting time for my spells that normally take more than a turn to cast?
SQL server Installation
Stop SQL Server service(s) before defragmenting drive?Optimal drive configuration for SQL Server 2008R2Optimum configuration for 4 SSD drivesSQL Server 2008R2 minimum RAID/Disk configPoor SQL performance with raid10What to choose for SQL Server storage - RAID 5 with 15K drives or RAID 10 with 10K drivesConfiguring Dynamics GP's (SQL Server) DisksNVMe+bcache as huge storage cache for vertica databaseConfiguring physical storage for a Microsoft SQL Server installationRAID 5 configuration with two drives
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♦ 5 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♦ 5 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♦ 5 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♦ 5 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