June 12, 2008 at 9:58 am
Hi,
Newbie here... I have a new server with two arrays: RAID1 (C: for Windows 2008 x64 40GB, D: empty 25GB) and a RAID 10 (E: empty 150GB).
I'm not a DBA, and I'd like to hear your suggestions as to how to split the data, log, and tempdb locations between these three volumes.
The databases on SQL will be relatively small (< 2 GB each, ~ 4 DBs), and historically, the tempdb has not grown over 100 MB. Only one SQL instance will be used.
TIA
George
June 13, 2008 at 2:18 pm
It's all about what you expect and need from your database - you wouldn't want any part of sql server to share with the o/s so you can only put your database/backups/logs on the second drive. If it gets busy you will probably get contention - watch ntfs fragmentation and make sure you have adequate memory. I normally allow a minimum of 6gb for a 64 bit o/s
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 17, 2008 at 8:43 am
What you might want to do is split the RAID 10 into two RAID 1s, and put data/index files on one and log files on the other. Then run backups to D. That might be a good way to utilize it, if the backups will fit on D (sounds like they should).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply