Saturday, February 25, 2012

Operating system and SQL server application on same disk set?

Dear all,
Can anyone please tell me what the advantages are when placing the operating
system and SQL server application on different disk sets? Or are the
differences minimal when doing this?
Thanks in advance,
--
Best Regards,
DennisI don't think there are any advantages in doing this. If the box is only
running SQL Server there should not be much I/O going taking place on the OS
volume.
There are advantages in separating tempdb, the data files, and the log files
onto different volumes.
--
Keith Kratochvil
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:BE15F7F7-A507-4C86-9352-B7B6FE7BE956@.microsoft.com...
> Dear all,
> Can anyone please tell me what the advantages are when placing the
> operating
> system and SQL server application on different disk sets? Or are the
> differences minimal when doing this?
> Thanks in advance,
> --
> Best Regards,
> Dennis|||Dennis wrote:
> Dear all,
> Can anyone please tell me what the advantages are when placing the operating
> system and SQL server application on different disk sets? Or are the
> differences minimal when doing this?
> Thanks in advance,
There really is no benefit to placing the executables on different
volumes. Database files and transaction log files are a different
matter entirely.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

No comments:

Post a Comment