Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

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