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 > DPA’s Blocked Sessions in SQL Server and Azure

DPA’s Blocked Sessions in SQL Server and Azure

Table of contents

Updated August 31, 2018

Overview

DPA has a Blocked Sessions metric in the Resources > Sessions tab for SQL Server and Azure. Because of the differences described below, there are sometimes differences between the data shown by the Blocked Sessions metric and the data reported by DPA's wait time monitoring. 

Environment

  • DPA all versions.
  • Monitoring a SQL Server database instance

Detail

The Blocked Sessions metric shows the number of blocked sessions, including sessions that are normally excluded from DPA’s wait time monitoring (for example, sessions doing backups and restores).

 

Also, the Blocked Sessions metric runs every 60 seconds by default, so it reports the sessions that are blocked at each 60-second mark. In contrast, DPA’s wait time monitoring runs more frequently.

 

BlockedSessionsMetric.png

 

Blockers tab.png

 

 

Last modified

Tags

Classifications

Public