Tuesday, 25 September 2012

Disk IOPS requirement for SharePoint 2010 databases

After going through the SharePoint 2010 planning guide thought it would be good to capture the Disk IOPS requirement for various databases.
Databases
IOPS Recommended
Search Crawl DB
3500-7000
Search Property DB
2000
Search Admin DB
Minimum 100
Content DB
200-4000
First Estimate  Database size = ((D × V) × S) + (10 KB × (L + (V × D)))
Configuration DB
Minimum 100
Note: Recommendation is to allocate 2 GB as a minimum for Config DB, it will consume 40 MB for each 50,000 site collection , recovery model should be set to simple as config DB can grow large but if you're using DB mirroing then recovery model should be full
Central Admin DB
Minimum 100
Usage and Health DB
Minimum 100
Business Connectivity Services DB
Minimum 100
User Profile Service App:  Profile DB
Minimum 100
User Profile Service App:  Synchronization DB
Minimum 100
User Profile Service App:  Social DB
Minimum 100
User Profile Service App:  Tagging DB
Minimum 100
Web Analytics - Staging DB
Minimum 100
Web Analytics - Reporting DB
Minimum 100
State Service DB
Minimum 100
Managed Metadata DB
Minimum 100
Reporting Services Configuration DB
Minimum 100

This is just a starting point there is no hard and fast rule that these are the final numbers it all depends on your capacity planning you will come up with the numbers. Reference for this is the SharePoint 2010 Planning Guide

No comments:

Post a Comment