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 SQLMag.com

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

http://tiny.cc/9lNTY .

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

Comments

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.