Am sorry i should have mentioned this is a development environment.
Understood, provided your UAT environment matches production. It's the only way to do valid UAT testing.
Also, for the record, when I refer to a LUN, I am referring to a RAID set of physical disks, not some logical grouping. And I agree with one of the previous posters, in that splitting the OS from the sql binaries by physical LUN is a good practice. One needs to leave a fair amount of free space for the OS. Microsoft, in the infinite wisdom, insists on dumping a lot of transient garbage on the the OS drive during OS and/or SQL patch / SP installation.
In addition, the OS swap file should go on its own, separate, physical LUN. Something along the lines of:
E$ OS Swap File
F$ SQL binaries
G$ Program files
H$ SQL mdf files
I$ SQL ndf files
J$ SQL log files
L$ SQLIO files (IO files from ETL processes, scripts, etc.)
M$ SQL Backup (*.bak files, which should then be copied to another server
You need to add three or four more to that for separate tempdb data files. And the tempdb log should really be on its own I/O system, too, of course. And really, each OLTP database should have its own I/O channels, to avoid contention. And ...
... But really, that's almost certainly just going to make administration more difficult. Separate the O/S and binaries from the data files, and separate those from the log files, and tempdb if possible. Anything beyond that is probably premature optimization for most companies. Even the separation of tempdb from the rest is overkill unless you have the traffic to warrant it.
And if the reason to separate the binaries from the O/S is that developers are filling up C-drive with junk, or because Windows patches are filling it up with temp files, then FIRE YOUR SYS ADMINS. Overfull C-drive on any system being used in a business environment is inexcusably incompetent administration. Fire them, and scan for malware on every system they ever touched, because if they're that incompetent, they almost certainly missed things like BonziBuddy on the web server or something equally moronic. If your devs are the problem, fire them too.
- 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