Submit a ticketCall us

AnnouncementsTHWACKcamp 2018 is here

2018 is the seventh year for THWACKcamp™, and once again we’ll be live October 17 – 18 with packed session tracks covering everything from network monitoring and management, to change control, application management, storage, cloud and DevOps, security, automation, virtualization, mapping, logging, and more.

Register for online sessions.

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