Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > 100% CPU usage on MS SQL Server monitored by DPA

100% CPU usage on MS SQL Server monitored by DPA

Updated January 24, 2018

Overview

The CPU usage goes to 100% on a Microsoft SQL Server that uses SSD storage to host one or more instances you are monitoring. This causes the server and its instances to have high signal waits.

Cause

There is a known issue regarding high CPU usage and the Microsoft SQL Server I/O handling mechanism that creates high I/O wait times. For more information about the issue, see this article (© 2018 Microsoft, available at https://connect.microsoft.com, obtained on January 24, 2018).

Environment

  • DPA, all versions
  • SQL Server 2012 and earlier

Resolution

As a workaround, disable I/O statistics in SolarWinds DPA for the instances hosted on that MS SQL Server. The easiest way is to disable the IO_STATS_POLL_ENABLED option. You can do this for individual instances or for all instances.

To disable I/O statistics for individual instances 

  1. Click the DB Instance Options tab.
  2. Click the Support Options checkbox.
  3. Select the database instance from the dropdown.
  4. Click the IO_STATS_POLL_ENABLED option.
  5. In Edit Option, select New Value: False.
  6. Click Update.
  7. Restart monitoring on the database instance .

To disable I/O statistics for all instances

  1. Click the System Options tab.
  2. Click the Support Options checkbox.
  3. Click the IO_STATS_POLL_ENABLED option.
  4. In Edit Option, select New Value: False.
  5. Click Update.
  6. Restart all monitors. 
Last modified

Tags

Classifications

Public