Slow I/O in SQL Server

12 Sep

Most of the users does not know the Slow I/O could cause the SharePoint performances. The poor disk performance can cause the major impact on the SharePoint performance. One of the troubleshooting method would be use a Performance Monitor with counter measures to get a good picture of health of the disk I/O subsystem and any latency SQL Server is experiencing from its poor performance.

Microsoft had released a tool called “SQLIO Disk Subsystem Benchmark Tool” which can also be used to determine the I/O capacity of a given configuration. Also, you can use a tool such as IOMeter or sqlio.exe–both of which are freely downloadable–to benchmark the I/O performance of a disk.

You can download it from here:

For more information:

Microsoft Engineer had posted a blog entry on Troubleshooting the Slow I/O in SQL Server. You can check his blog entry here:

Leave a comment

Posted by on September 12, 2012 in Sharepoint


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: