Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

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