March 6, 2012 at 3:01 pm
If you had the hardware available, what would the best way to set up SQL Server 2008 R2 on a fresh install? Is it recommended to separate the database files from the log files?
Server = SQL Server 2008 R2 & system databasse (master, msdb, model)
disk b = database files for application databases
disk c = log files for application databases
disk d = temdb database file & log
- or -
Server = SQL Server 2008 R2 & system databasse (master, msdb, model)
disk b = database files & log files for application databases
disk c = temdb database file & log
Thank you.
March 6, 2012 at 3:07 pm
Yes, it makes a lot of sense to separate the data and log files on different logical drives.
March 6, 2012 at 3:08 pm
Unless your databases are almost exclusively read only it is definitely a good idea to separate data from log.
---------------------------------------------------------------------
March 7, 2012 at 8:38 am
Your first option looks great.
If you have the ability, I would also recommend:
1) Use RAID 10 on the log file drive
2) Use RAID 5 or 6 on the data files drive. (RAID 10 works too, but very expensive due to size)
3) We format our data file drives in 64kb clusters rather than 4kb due to extent size.
4) We also partition our tempdb files to the number of processor cores.
Jake
March 7, 2012 at 9:02 am
jake.mayher (3/7/2012)
Your first option looks great.If you have the ability, I would also recommend:
1) Use RAID 10 on the log file drive
2) Use RAID 5 or 6 on the data files drive. (RAID 10 works too, but very expensive due to size)
3) We format our data file drives in 64kb clusters rather than 4kb due to extent size.
4) We also partition our tempdb files to the number of processor cores.
Jake
no of tempdb files = half the number of cores is the accepted rule of thumb and don't go above 8
---------------------------------------------------------------------
March 7, 2012 at 9:20 am
george sibbald (3/7/2012)
no of tempdb files = half the number of cores is the accepted rule of thumb and don't go above 8
I believe I read something on this that said essentially don't play with this wihtout some analysis, that getting it wrong is worse than doing nothing at all.. I'd stay with a single file to start.
CEWII
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply