Hello,

I have a question regarding IOPS requirements and I'm getting more and more confused.

Microsoft recommends to estimate 2000IOPS for PropertyDB and 3500 - 7000 IOPS for SearchDB. On other sites I have read that we need to calculate 2GB per GB?

What does it really mean?

If I have total 2TB of Content (sum of ContentDBs) and my Search DB is approx. 90GB in size for what I need to plan the 3500IOPS. For the Log or the DB partition or both if LOGs and DB are located on different Disks?

If I would calculate 2IOPS per GB does it mean for Search DB I need to calculate 2 x 90GB = 180IOPS??

Sorry, but I'm getting confused here?

Thank you

Take a look at this:-

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

Reference: http://sp-vinod.blogspot.in/2012/09/disk-iops-requirement-for-sharepoint.html

Also check http://technet.microsoft.com/en-us/library/gg750251(v=office.14).aspx

Hello Mohammad,

Thank you very much for your quick response. But I still don't get it.

Let's say I have

100 GB Search Crawl Database (Drive E:)

50 GB Search Crawl DB TransLogs (Drive F:)

How many IOPS should I calculate now? For each Drive (LUN) 3500 IOPS as a minimum?

Thank you again!

To estimate the storage requirements for the service applications in the system, you must first be aware of the service applications and how you'll use them.The storage and IOPs data you have to calculate with quantity items.

Search service application storage and IOPS requirements

Database	Scaling	Disk IOPS	Disk size	10M items	100M items
Crawl	One DB per 20M items SQL IOPS: 10 per 1 DPS	Medium/High	Medium	15GB 2GB log	110GB 50GB log
Link	One DB per 60M items SQL IOPS: 10 per 1M items	Medium	Medium	10GB 0.1GB log	80GB 5GB log
Analytics Reporting	Split when reaching 100-300GB	Medium	Medium	Usage dependent	Usage dependent
Search Administration	One DB	Low	Low	0.4GB 1GB log	1GB data 2GB log

The key thing to remember is that the IOPS are about performance, if you are low then your system will be slow, if you're high then you'll reduce the delay caused by waiting for disks a bit. As such there's plenty of wiggle room for small to medium designs.

Go with 2 IOPS/GB and you won't be far wrong. If you've got control of your spindles then separate out the logs onto RAID 10 or 01 arrays to avoid the RAID 5 write penalty. Put most/all of your content DBs on RAID5 arrays and the same for most of your service application databases. Crawl should also go on RAID10 (ideally everything would go on RAID 10 as RAID5 is evil but that's another story).

If you're on a SAN then just get the storage minion to give you as much IOPS as you can stand, prioritising the config DB and the transaction log DB.

Hello Alex,

Thank you! But what does it really mean if I go to 2 IOPS/GB based on my example?

If all my ContentDBs are 2TB in total and my Search Crawl DB is let's say 100GB?

If I would calculate 2IOPS per GB does it mean for Search DB I need to calculate 2 x 100GB = 200IOPS??

And for the Translog with 50GB = 100IOPS ?

Is this correct?

I know this can be different in a real world scenario but I need a guideline how to calculate this?

Thank you again

• Edited by SPTONEUBT Thursday, February 27, 2014 10:33 AM

Hi,

Can someone comment on this based on my example?

100GB CrawlDB LUN1

50GB CrawlDB LUN2

What are the estimated IOPS? Please provide some numbers if possible.

Thanks

Sorry,

Can someone comment on this based on my example?

100GB CrawlDB LUN1

50GB CrawlDB Transaction Logs LUN2

What are the estimated IOPS? Please provide some numbers if possible.

Thanks

there is no iops number but i found this blog.

its really helps :

http://www.cleverworkarounds.com/2012/07/10/demystifying-sharepoint-performance-management-part-6-the-unholy-trinity-of-latency-iops-and-mbps-4/

• Edited by MohammadReza Dastouri 12 minutes ago