Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > 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 Melanie Boyd on Apr 17, 2017

Views: 3,865 Votes: 2 Revisions: 5


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


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


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