This is how you can easily get the counter suited for you. At any point in time when you want to see them, just go ahead and ‘double click’. I shall show you how to create the perfmon templates.
INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- Powershell Interview Questions and Answers
1. The team is heading towards a big release. We have 130 servers out of which 56 servers are critical. I want my junior DBA to monitor them and report me if any kind of problem is seen.
2. A great launch is being prepared. I got some alerts and want to monitor some critical counters. Am I going to create perfmon templates afresh?
Well there can be a many situations like this. Please enjoy the resolution as follows:
Step 3: Add counters of your choice and do as follows:
Step 4: Save the file.
Step5: Open the file at any time of urgency.
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com