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 > SQL server deadlock alert in DPA returns as broken

SQL server deadlock alert in DPA returns as broken

Updated September 21, 2017


When executing the DPA alert for SQL server deadlocks on a SQL server instance, the alert returns broken. 


  • DPA, all versions
  • SQL Server monitored instance


The DPA deadlock alert that is built in runs the following query:

SELECT cntr_value AS NumOfDeadLocks
FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%:Locks%'
AND counter_name = 'Number of Deadlocks/sec'
AND instance_name = '_Total'


In some cases, databases can be created in SQL Server with missing performance counters. When the counters are missing this query returns the following error: 


Incorrect result size: Expected 1, actual 0 


This can also occur if performance counters are disabled in SQL Server. 


  1. Check to see if performance counters are disabled. To do this, run the query in the Cause section and see if anything is returned. 
  2. Run the following query to see if any performance counters are returned:
    SELECT COUNT(*) FROM sys.dm_os_performance_counters
  3. If either of those queries does not return results, you need to repair or enable the performance counters on the SQL server. For more information, see the article sys.dm_os_performance_counters (Transact-SQL) (© 2017 Microsoft, available at, obtained on September 21, 2017.)


Last modified