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!