Hi Friends,

Sometime back I blogged about a frustrating experience of a SQL Server DBA with Performance Monitor. Though, it was such a simple thing but still not known to many. You can read that blog here;

Today, I want to talk about another technique in Windows Performance Monitor that can alleviate some of your frustration.

Would you not like to open Performance Monitor with your set of default counters? Or wouldn’t it be nice that you have four or five different shortcuts to Performance Monitor and each shortcut opens up with a different set of default counters. For example, you could create one shortcut that opens up PerfMon with all counters related to IO, another shortcut that opens up PerfMon related to Memory, etc. If you don’t know this technique, you are not being productive, for sure.

So here is how you do it.

Start -> Run -> PerfMon

Performance Monitor opens up. Click on Performance Monitor on the left pane. Select/Add your counters. For my example here, I add some disks related counters.

1_SQL_Server_Open_Windows_Performance_Monitor_with_your_default_set_of_counters

Click on OK.

Now you can see the counters that you selected and the real-time graph. Well this is something that you all know. The trick starts now.

From the toolbar, click on Copy Properties.

2_SQL_Server_Open_Windows_Performance_Monitor_with_your_default_set_of_counters

Start another instance of Performance Monitor, but this time use /sys switch. See below:

3_SQL_Server_Open_Windows_Performance_Monitor_with_your_default_set_of_counters

This will open up only the PerfMon console. Click on Paste on the toolbar, this will paste the counters list copied from the previous instance to this instance.

4_SQL_Server_Open_Windows_Performance_Monitor_with_your_default_set_of_counters

Is it working? Should be :) – see below.

5_SQL_Server_Open_Windows_Performance_Monitor_with_your_default_set_of_counters

You can now save these settings as a shortcut. Click on File -> Save Settings As… provide an appropriate name to the file and save this on the desktop. I simply named it Disk – and it makes sense to put it on desktop. Remember, you are doing this on your production box and the purpose is that if there is a troubleshooting scenario, you simply log on to the box and double click the shortcut and perfmon opens up with the counters.

6_SQL_Server_Open_Windows_Performance_Monitor_with_your_default_set_of_counters

Once saved, close all perfmon windows including the one that you just saved. Navigate to dektop (Windows key + D), double click the shortcut to test. The perfmon console should open up with your counters.

Working? Should be !

This way, you can have multiple shortcuts, well categorized as per you need. Mind it, do not create too many shortcuts – the purpose gets defeated !

 

 

Like us on FaceBook | Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Amit Bansal
SQL MCM, SQL MVP
Director – eDominer Systems, Peopleware India, SQLMaestros

Follow me on Twitter | Follow me on FaceBook | Browse my blog posts on SQLMaestros
Like my FB page | Connect on LinkedIn | Know more about me

SQL Server Free Disk Space Monitor Alerts - SQL Script
How to Handle Null Values in XML