Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

Home > Success Center > Database Performance Analyzer (DPA) > Signal wait time percentage is high when there is no CPU pressure

Signal wait time percentage is high when there is no CPU pressure

Table of contents
Created by Mandeville, last modified by MindTouch on Jun 23, 2016

Views: 1,888 Votes: 1 Revisions: 4

Overview

This article provides brief information when the Signal wait time percentage is in warning or critical state and there is no CPU pressure (via CPU utilization).

Environment

  • All DPA versions
  • All SQL Server versions
  • All Windows OS

Detail

Signal waits are an indication of possible internal CPU pressure. The CPU Signal Waits percent is a ratio metric comparing signal waits to total waits as a percent. That means you can see a spike in signal waits from one minute to the next without the server itself showing a high CPU utilization for the server. Since this is a percentage, a reduction of overall waits within an instance can cause this ratio to increase if signal waits remain fairly constant. This is more likely to show up as warning or critical in very lightly used systems.

 

With a virtual database server this could also mean that your guest O/S is waiting for an available vCPU to be assigned, so you should check the VM Ready Time (VMware) metric as well to see if that is the case.

Another metric to look at within vSphere would be the co-stop time, this is the amount of time the host is taking to schedule vCPUs to guests. We don't have this metric in DPA yet, so you will need to go to vSphere to see this (VMWare).

 

Recommendation: If your system is not under CPU utilization pressure, you can adjust the default thresholds for this metric to eliminate the false alarms and noise.  Resources > CPU > Signal Waits Percent (settings).

 

 

 

Last modified
19:17, 22 Jun 2016

Tags

Classifications

Public