SQL Server

SQL Server Performance Monitor – Does Performance Monitor frustrate you?

- by Amit Bansal - 5 Comments.

Hi Friends,

I received a mail today from a DBA who was facing some issues with SQL Server Performance Monitor tool on Windows Server. And he was frustrated.

Why?

When he starts PerfMon, he gets the default window with %Processor Time counter already added, as shown below:

1_SQL_Server_Does_Performance_Monitor_frustrate_you

And he can select the counter to see the metrics on the panel above, values for Last, Average, Min, Max, etc.

Now he adds some more counters and gets a horizontal and vertical scroll bar, as shown below:

   

2_SQL_Server_Does_Performance_Monitor_frustrate_you

Things become very irritating for him to scroll up & down just to select & monitor values for a small set of counters. He would like to see these small set of counters in a single pane.

Well, you can get rid of both the scroll bars. Just double click on any separator and reduce the length of the column (or click on the separator and drag towards left until the scroll bar vanishes)

3_SQL_Server_Does_Performance_Monitor_frustrate_you

No scroll bars now and you can see all the counters in a single pane.

 

 

   

Related Posts

SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Clerk

SQL Server Memory Troubleshooting

Performance Monitor Counters

About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: http://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

View all posts by Amit Bansal →

5 Comments on “SQL Server Performance Monitor – Does Performance Monitor frustrate you?”

  2. The graphs are not the best view. Change your view to report and you get a better, streamlined view with actual counters to monitor. Ditch the graphs! 🙂

    Reply

  3. To avoid another frustration:

    If you want to open perfmon with some default counters from your own, just start it with the option sys (Perfmon /sys), populate the counters that you want, and the next time you open it with the sys option, your prefered counters will be there.

    Reply

Leave a Reply

Your email address will not be published.