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.

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.

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

Go to Properties of the WMI Control.

Open WMI Control Properties.

Go to CIMV2 in namespace under ROOT.

Click Add to add your username to the security group.

Add your username to the security group.

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.

• Consulting 101 – Why Do I Never Take Control of Computers Remotely?
• Consulting 102 – Why Do I Give 100% Guarantee of My Services?
• Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours?
• Consulting 104 – Why Do I Give All of the Performance-Tuning Scripts to My Customers?
• Consulting 105 – Why Don’t I Want My Customers to Return Because of the Same Problem?
• Consulting Wrap Up – What Next and How to Get Started

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