返回
-
标题
Where is Historical Lock Analysis in the SQL PI cartridge? -
说明
How is Historical Lock Analysis done in the SQL PI cartridge? -
原因
Lock analysis can now be done from the SQL Statement and as a branch in the Performance Tree. -
解决办法
"Historical Lock Analysis" has been split with locked object added to the performance tree as a dimension, and blocking history added as a tab in the 'Instance Level'Lock
The Lock panel displays the database’s lock related wait events.Default metrics displayed:- Lock Update
- Lock Shared
- Average Lock Duration
- Lock Wait
- Lock Intent
- Lock Timeouts
- Lock Exclusive
- Deadlocks
- Lock Schema
- Lock Bulk Update
Blocking History
The Lock Analysis displays all locks that took place within the selected time range.This pane comprises the following sections:- Locks Activity — a chart that displays all of the lock wait events, plotted over time. This chart can be viewed in either of the following views:
- Baseline — displaying only lock wait events
- Breakdown — displaying both lock and non-lock wait events
- Blocks exceeding a predefined threshold — displays blocks that reached or exceeded the minimal duration, in seconds, which a block should reach or exceed in order to be collected. By selecting a row from the table a pop-up with a lock map of this specific time will be presented.
* NOTE: The minimal duration's length is defined using the Locks view in the Databases Administration dashboard. To access this view, click the In-context actions button at the upper right side of the screen and then select Agent settings.
Event Start
Event Start indicates when the Blocking Event begins.
There are circumstances where the Event Start can be displayed before the SPID times, such as in the following example.
The login time of the session is taken directly from sql server with no time zone manipulations. The event time is the time PI detected the event. It is stored in the repository at UTC time and is converted at UI time.