Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Article in SQL Server Magazine on SQL IO Stastics.......

Article on I/O tips appearing on

If you've followed my blog, you know I've written on various topics, including I/O stats.  I've expanded and put these tips together, and the editors at SQL Server Magazine were kind enough to carry it.  If you're interested in analyzing and gathering I/O statistics, my article in SQL Server Magazine's March edition has just been published!

I'm always looking for ways to measure SQL Server's performance and present the information in a readable and useful format. Here are some useful tips I've come across for getting and analyzing I/O information:

Use sys.dm_io_virtual_file_stats.
Use SQL Server Performance Monitor to help identify I/O bottlenecks.
Understand the infamous error message.

( All credits are given to those whose tips I've referenced.)

Check out the print edition if you're a subscriber, or log on to .

I hope the information is helpful. Thanks for reading and enjoy!  


Posted by Glenn Berry on 28 February 2010

Congratulations on getting the article published as the cover article no less! I appreciate the mention and link in your article. Thanks!

Posted by Robert Pearl on 19 March 2010

Thank you, Glenn!  I couldn't have done it without your great work! - RP

Leave a Comment

Please register or log in to leave a comment.