Return
-
Title
Setting Options for Displaying Data in the SQL Server Locks Panel -
Description
The Locks view allows setting parameters for displaying data in the SQL Server's Locks panel, under the SQL Activity drilldown, as well as configuring the minimal duration, in seconds, which a block should reach or exceed in order to be collected and displayed in the Blocking (History) panel.
-
Resolution
- Navigate to the Databases Dashboard
- Select one or more SQL Server database agents
- Click Settings | Administration
- Click the Locks item
- Make changes as per the parameters below.
- Save changes
The parameters that can when clicking Edit on this view are as follows:Parameter Description Filter Database Name Defines whether to display only objects that reside on certain databases. When setting this parameter, the character % can be used as a wild card. For example, to display objects from all of the databases that begin with Quest (Questdatabase, QuestWorkDatabase, and so on), enter Quest%.Filter Object Name Defines whether to display only certain objects. When setting this parameter, the character % can be used as a wild card.Show System Objects Defines whether to display SQL Server system objects. Show Database Shared Locks Defines whether to display shared locks. Show Intent Locks Defines whether to display Intent locks. Show TempDB Locks Defines whether to display locks on temp DB objects. Blocking History section The minimal duration (seconds) for collecting a block in the Blocking (History) panel is:Defines the minimal duration, in seconds, which a block should reach or exceed in order to be collected. All blocks that meet this criterion are displayed in the lower section of the SQL Activity > Blocking (History) panel.After carrying out all of the requested changes, save the changes before switching to another view.