http://www.sqlservercentral.com/blogs/pearlknows/2010/02/26/article-in-sql-server-magazine-on-sql-io-stastics/

Printed 2014/09/22 10:35AM

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

By Robert Pearl, 2010/02/26

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!  


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.