SQL SERVER – Fixing Freezing Activity Monitor

The other day I had a very interesting experience while working with my client on Comprehensive Database Performance Health Check. While doing performance tuning, I personally prefer to use DMVs and DMFs but for the visualization easiness client preferred Activity Monitor which due to some reason was Freezing suddenly for him. After a while, we figured out a solution for the same and it was a simple permission issue.

SQL SERVER - Fixing Freezing Activity Monitor freezing-800x202

Freezing Activity Monitor

While working together DBA from my clients’ side noticed that the Activity Monitor was freezing for a few servers. It was indeed a very interesting problem. After a while, we figured out that it was just a permissions issue and very easy to fix it. Let us see how we were able to fix it with the help of images.

SQL SERVER - Fixing Freezing Activity Monitor wmi1

Type Wmimgmt.msc to the command prompt or in windows search.

SQL SERVER - Fixing Freezing Activity Monitor wmi2

Go to Properties of the WMI Control.

SQL SERVER - Fixing Freezing Activity Monitor wmi3

Open WMI Control Properties.

SQL SERVER - Fixing Freezing Activity Monitor wmi4

Go to CIMV2 in namespace under ROOT.

SQL SERVER - Fixing Freezing Activity Monitor wmi5

Click Add to add your username to the security group.

SQL SERVER - Fixing Freezing Activity Monitor wmi6

Add your username to the security group.

SQL SERVER - Fixing Freezing Activity Monitor wmi7

Give all the necessary permission to your user and click on OK.

Well, once we added our account for which Activity Monitor was freezing to WMI the issue went away and Activity Monitor started to work perfectly fine. Well, such a simple solution to the complex looking problem.

Here are six-part blog post series I have written based on my last 10 years of experience helping with the Comprehensive Database Performance Health Check.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQL Activity Monitor, SQL Error Messages, SQL Server
Previous Post
SQL SERVER – SQL_NO_CACHE and OPTION (RECOMPILE)
Next Post
SQL SERVER – Multiple Log Files to Your Databases – Not Needed

Related Posts

1 Comment. Leave new

  • Albert Van Biljon
    April 9, 2020 5:51 pm

    What does CIMV2 stand for or what does it mean?

    Reply

Leave a Reply