Using Resource Monitor In Windows Server 2008 to Look at I/O Performance for SQL Server 2008

One quick and dirty tool that I like to use to monitor I/O performance at the file level is Resource Monitor (in Windows Server 2008 or 2008 R2). As you see below, the Disk portion of the display lets you quickly look at reads, writes, total B/sec, and response time for individual files. The columns are sortable, so it is very easy to get a better understanding of your I/O patterns and possible bottlenecks.

In the example below, you can see that the R: drive is a little less happy than the other drives on this server. This can be useful information to know when you are trying to determine where to locate data and log files on a server. One thing to be aware of is that Resource Monitor can be fairly expensive to run (I often see it using 5-7% CPU on a 16-core server), so you should not just leave it running all of the time.

This entry was posted in SQL Server 2008. Bookmark the permalink.

3 Responses to Using Resource Monitor In Windows Server 2008 to Look at I/O Performance for SQL Server 2008

  1. Unknown says:

    http://www.salesid.com and http://www.saletoo.com Are Top Wholesale: Belts Caps Clothing Glasses Handbags Shoes Wallets Watches.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s