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!