Submit a ticketCall us

WebinarVisual Monitoring Tactics: Getting More Log Search Value from SolarWinds Log & Event Manager with nDepth Webcast

Do things seem to make more sense when they are visualized? Are you an IT professional or security expert with a wish for more cybersecurity tools that provide an intuitive visual experience? Join Alexis Horn and Jamie Hynds from SolarWinds as they demonstrate how the nDepth feature in LEM can help make visualizing log search results a reality.

Register now.

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

Overview

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

Environment

  • DPA, all versions
  • SQL Server monitored instance

Cause 

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. 

Resolution

  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 https://docs.microsoft.com, obtained on September 21, 2017.)
 

 

Last modified

Tags

Classifications

Public