SCOM DB RAID configuration recommendations?
We just inherited (2) 14 bay Fiber Channel hard drive enclosures and a Drive Controller. Each enclsoure has the full 14 FC drives (146GB each) and equals about 2 TB of space so I can have a RAID 10 with 2TB. Here is my question, is it better
to do 1 RAID 10 and just partition for each of the SQL Databases (OpsMGR and OPSDW), SQL Logs (OPSMGR and OPSDW) and Tempdb.
Or should I do multiple RAID 10 for each database. For instance Since I have 28 drives in all I would take 4 and RAID 10 for the tempdb, 6 drives and RAID 10 for the OpsMGR DB, 4 drives and RAID 10 for OPSMGRDW DB, etc.
February 17th, 2011 4:26pm
Hi,
I would like to share the following with you for your reference:
Performance IOPS for the DB and DW in OpsMgr 2007
http://blogs.technet.com/b/momteam/archive/2008/06/24/performance-iops-for-the-db-and-dw-in-opsmgr-2007.aspx
How to measure Operations Manager database performance
http://blogs.technet.com/b/jonathanalmquist/archive/2009/04/06/how-can-i-gauge-operations-manager-database-performance.aspx
Best practice hard disk setup RMS, MS, DB
http://social.technet.microsoft.com/Forums/en-US/operationsmanagerdeployment/thread/3f3e92a8-13ac-423a-9119-cc661cbea6c4
Hope this helps.
Thanks.
Nicholas Li - MSFT
Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
February 21st, 2011 1:16am
Thanks!
March 3rd, 2011 9:31am
What about SCOM 2012??? I am looking through the sizer spreadsheet, but is not very helpful with where to put what db where.
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2012 4:03pm