Tuesday, May 31, 2011

Best Layout for SQL Server Disks

Recently, a client asked me how they could save money on their current hardware infrastructure. I said "sure! You have TOO MANY DISKS!"

The best way to cut down on expenses is to put ALL your database files on ONE LUN (if SAN storage) or the C:\ drive of a desktop-class machine running Windows Advanced Server 2000.

MDF, NDF, LDF, fuck it, put'em all on the same drive. This will conserve space and money! And performance will NEVER be better!

You can thank me later !

No comments:

Post a Comment