Re: SQL Server 2005 disk layout - opinions?

On 2008-03-27, aj <ronald@xxxxxxxxxxxxx> wrote:
I'm planning the disk layout for my soon-to-be-live SQL Server 2005 SP2
OLTP database. I've read all of the "best practices" doc I can find,
and have an idea of what I will do. I am looking for any comments and
generally having the experts shoot holes in it. Any help is
appreciated.

I'm no expert in this field, but recently I had a server with roughly
the same specs and I did some tests with filesystem options and
also with tempdb. This is interesting stuff for someone who mainly
does T-SQL, so I wrote about my experiments.

http://seepia.dyndns.org/~pojanisu/diskalignment/diskalignment.html
http://seepia.dyndns.org/~pojanisu/tempdb/tempdb.html

If you have a possibility to test for example how the separating
tempdb in multiple files works in your case, it would be interesting
to know the results.

Pasi
.