1/11/2013 8:52:41 AM
Amit Bansal -
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: http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/715/sql-server-does-performance-monitor-frustrate-you
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.
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.
Start another instance of Performance Monitor, but this time use /sys switch. See below:
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.
Is it working? Should be :) – see below.
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.
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 !
If you liked this post, do like us on FaceBook at http://www.FaceBook.com/SQLServerGeeks
Have a SQL Server question? Join the fastest growing SQL Server group on FaceBook - http://www.facebook.com/groups/458103987564477/Regards,
Connect with me on LinkedIN: http://www.linkedin.com/in/amitbansal2010Connect with me or Follow me (subscribe) on FaceBook: www.FaceBook.com/amit.r.bansal
Visit my FaceBook page at http://www.facebook.com/AmitRSBansalContribute on SQLServerGeeks.com: visit http://www.sqlservergeeks.com/default-category/write-for-us
Amit Bansal (Member since: 3/12/2011 4:59:54 PM)
Follow Amit at Twitter @A_Bansal : Amit Bansal is the CTO of eDominer Systems & Peopleware India. He is a consultant, trainer, writer, speaker & evangelist on SQL Server & Business Intelligence. A seasoned speaker; he speaks at major summits and conferences of Microsoft worldwide including TechED, MCT Summits, MSDN & TechNet conferences. Over the last 8 years, he has consulted, trained & mentored more than 6000 IT professionals on SQL Server & Business Intelligence and worked with top notch blue chip companies worldwide including Microsoft, Infosys, Wipro, RBS, HCL, HP, Siemens, IBM, Accenture, etc. He has delivered more than 400 workshops on SQL Server & Business Intelligence. Apart from holding many Microsoft credentials, he is also a Microsoft Most Valuable Professional (MVP) awardee on SQL Server. He is also one of the first Microsoft Certified Trainer in India. Amit has worked with Microsoft in India and US as a Subject Matter Expert in various capacities participating in OD sessions, technical reviewing, etc. He is also a very active community lead in Asia Pacific. Visit www.amitbansal.net to know more. Subscribe to Amit’s blog and be a member of his technical forum at www.SQLServerGeeks.com - an exclusive SQL Server portal. Visit www.peoplewareindia.com for Corporate Training solutions.
FaceBook – http://www.facebook.com/people/Amit-Bansal/525339346
LinkedIn – http://www.linkedin.com/pub/amit-bansal/7/121/755
View Amit Bansal 's profile
Nice & Helpful in daily DBA life.
Leave a comment