Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > DPA query is consuming very high resources on a monitored server

DPA query is consuming very high resources on a monitored server

Updated May 9, 2018

Overview

CPU usage on a monitored server is at 100% on a query called from DPA. 

Environment

  • DPA all versions 
  • Monitoring SQL Server prior to Cumulative update package 5 for SQL Server 2005 Service Pack 3 or a version prior to cumulative update package 7 for SQL Server 2008

Cause 

The execution of a command in an alert SQL Server Error Log Alert that calls exec xp_readerrorlog stops responding and the usage of the CPU that is running the command increases to 100 percent. This is a known Microsoft issue.

Work around

Delete this alert in all instances that are not patched for the issue. 

In DPA, go to Alerts > Manage alerts. Then delete the SQL Server Error Log Alert, or deselect the instances from this alert that have the issue. 

Resolution

Apply the Microsoft hotfix located at: http://support.microsoft.com/kb/973524 (© 2018 Microsoft, available at https://support.microsoft.com, obtained on May 9, 2018)

 

 

 

Last modified

Tags

Classifications

Public