Solutions Through IT

April 6, 2009

Reading SQL logged performance monitoring

Filed under: Uncategorized — solutionsthroughit @ 10:12

In the previous entry, we went through setting up how to log to a SQL database.  This entry will describe how to display the results that you’ve captured.

Open perfmon, and start a new counter set, and open the properties for it.

Select the Source tab, and configure the Database section, as per the System DSN and Log set that you’ve already created.  In this instance, I’ve got the highly imaginative DSN called PERFLOG and an even more creative log set called K3.

Pressing the Time Range button will allow you to select the capture time that you wish to display.  Its a little fiddly if you want very specific values, however, I’ll leave that to your dexterity! 🙂

Now move to the Data tab, and add the counters that you want to display.  The available counters are only the ones that you have selected to capture.  In this case, the objects that I captured were PhysicalDisk objects and Processor objects.

Voila!  You’ve got your results.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

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

Create a free website or blog at WordPress.com.

%d bloggers like this: