10/04/2013

Getting Familiar with Performance Monitor

Today I decided to learn more about Performance Monitor.

In Windows 8, I typed in "Performance Monitor" and the application opened.



I poked around to see what options are available, then clicked on Data Collector Sets - - > User Defined - - > New - - > Data Collector Set - - >

 
Typed a name for the Set...

 
Selected "System Diagnostics"...

 
Saved the Data Collection Set...
 

Right Click JB Test 1, click "Start"...


And we're off and running... go start a process in SQL Server, I ran an SSIS package for Fuzzy Grouping... then Right Click... "Stop"... Right Click "Latest Reports"...


It captures a slew of data...

 
 
 

So what we've done is "Benchmark" our Statistics at a point in time.  The next logical step would be to make adjustments to the server, in an organized step by step approach, making as few changes as possible, re-recording the Statistics, make comparisons, and continue forward with the Diagnostic Troubleshooting.

I then created a new User Defined Data Collection Set and re-ran the process...


I used the default template for ease of use and speed, except you can customize what metrics you'd like to capture.

This is a very powerful technique to assist in your efforts to troubleshoot slow performing servers.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder