A newer version of this post is available at This link   I/O Bottleneck SQL Server performance highly relies on the Disk performance.  SQL Server I/O Bottleneck can be identified through   1. PAGEIOLATCH_xx or WRITELOG wait types in Sysprocesses and other DMV’s 2. I/O taking longer than 15 seconds in SQL Server Errorlog. { … Continue reading SQL Server I/O Bottlenecks