Blog Post

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!  

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating