Storage disk performance is a critical factor for SharePoint to deliver a healthy service. Storage disk performance is measured by Input/output operations per second (IOPS). Following are some recommendation for various databases
DB | Recommended IOPS |
SharePoint content database | 200-4000 |
SharePoint configuration database | 100 min |
Central Administration database | 100 min |
Search Crawl database | 3500-7000 |
Let’s see how to check the performance of our storage disk. Following resources can be found in this article
1. Download and extract this package
2. Execute the PowerShell script
.\DiskPerformance.ps1 -TestFileName test.dat –TestFileSizeInGB 1 -TestFilepath C:\Test -TestMode Get-LargeIO -FastMode True -RemoveTestFile True -OutputFormat Out-GridView
(You can perform some IO operation on the drive while doing the operation)