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