Archive for the ‘Hardware Recomendations’ Category


November 1, 2010 Leave a comment

A collection of a few blogs that look at hardware requirements and SQL IOPS:


Hardware Recomendations

July 20, 2009 Leave a comment

Michael Pearson from MSFT made some good comments on another thread:

As far as the SAN goes, SAN’s are not always faster. They can be slower than direct attached storage in some cases. The performance is going to come down to how many physical disks are dedicated to OpsMgr, what the RAID configuration is, and how how SAN Cache is allocated to those sets of disks. I’ve worked with several customers that had a “big SAN with lots of disks” that turned out to be poorly configured for the type of IO that OpsMgr does.

Two pieces of advice for SAN’s
1. It’s OK to waste space – Many people like to have one large RAID 5 Array in their SAN and carve out LUN’s from that to allocate to the different servers in their environment. That’s a great solution to use every bit of disk space you have, but terrible for performance since every disk is basically shared. Shared disks for SQL IO is generally a very bad idea. Every time I’ve worked with a customer that did this, they had performance problems (too many DB’s on one disk, a single DB on one disk that was shared with dozens of other servers, etc).

2. RAID 5 is not the solution to every problem – While RAID 5 has it’s benefits, our document recommends RAID 0/1 (aka RAID 10). If you must go RAID 5, keep in mind that you may need more disks / larger write caches to come up to the performance that we tested with.