Applications Systems

DPA query is consuming very high resources on a monitored server

DPA query is consuming very high resources on a monitored server for long time. The execution of a command in an alert SQL Server Error Log Alert that calls the exec xp_readerrorlog procedure procedure stops responding and the usage of the CPU that is running the command increases to 100 percent.

First published date

11/9/2018 7:12 PM

Last published date

11/9/2018 7:12 PM

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

Product section

Database Performance Analyzer

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.

Resolution

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)

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.