October 19, 2011 at 9:01 am
Hi,
I'm very new to the servers and never done the sql server installation before.
we are trying to install SQL Server 2008 Standard R2 edition on the HP server.
we have HP DL380G7 server with RAID 1 configuration with 6 disks of 600 GB each.
could someone suggest me, the best practice of partitioning the hardware?
and General practice of SQL SERVER 2008 data directories for better performance?
Thanks!
October 19, 2011 at 9:28 am
As a general guideline:
•1 disk (logical / physical) for OS + SQL Server Instance Root
•1 disk (--do --) for Data Files (and many more if planning for table partitions)
•1 disk (--do --) for Log Files
•1 disk (--do --) for TempDB database
•1 disk (--do --) for Backups
The size of disk you can decide based on your application requirements.
October 19, 2011 at 10:00 am
Having everything going through the same IO controller is not the best way to go into it. If you could, you should try to give different IO path for Data, Log and TempDB. Keeping the size of the disk smaller to get more spindles will also help. I would also go for RAID 10 over Raid 1
Just my 2 cents
-Roy
October 19, 2011 at 10:07 am
ok, got it! Thanks Dev and Roy!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply