Page History
...
The following views display information on sessions holding locks:
- Overview
- Locks
- Text
About getting an overview of current sessions holding locks
Displays information on the session identifier, including connection details, session-related statistics and a breakdown of session resource consumption, during the last minute.
...
Table 5-12 Sessions Holding Locks overview
View area Description
...
View Area | Description |
---|---|
Session identifies | Displays the following information on the session's identifiers: |
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
See SQL Server Books Online for more information.
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
Connection |
...
A connection includes session identifiers, such as, database, login, machine, user and work type, as reported by sysprocesses. In ERP systems (if the appropriate ERP extension is installed), Precise for SQL Server replaces some identifiers as follows: In SAP: |
...
|
...
|
...
In PeopleSoft: |
...
|
...
In Siebel: |
...
|
...
|
...
|
...
In COM+: |
...
|
...
Statistics | Displays information on the following statistical parameters: |
...
|
...
|
...
|
...
|
In MS-SQL ( |
...
Last minute) |
...
Displays the resource consumption breakdown of the session during the last minute (that is, 60 samples of the Collector). In addition to the resource distribution, the view displays the number of sessions in each state during the last sample. It is important to remember that since this view only displays the last minute's activities, you will always be viewing the activities that occurred during the last minute and not the activities that occurred since the last refresh action. The following information is displayed: |
...
|
...
|
...
|
...
|
...
See “About session states” on page 36. |
About viewing information on the lock breakdown of a session that is holding locks
The Locks view displays lock wait duration broken down into lock levels such as Table, Page and Key, for the selected Session, during the last minute.
...
Table 5-13 Locks view for the Session Holding Locks entity
View area Description
...
View Area | Description |
---|---|
Lock tree | The Lock tree provides the necessary information to determine the following information for each blocking chain: |
...
|
...
|
Lock breakdown (Last |
...
minute) |
...
The Lock breakdown (Last minute) displays the Lock Wait duration broken down into lock levels such as Table, Page and Key, for the selected session, during the last minute: |
...
|
...
|
...
|
...
|
...
|
...
|
About viewing the text of a session that is holding locks
Displays the text of the current statement. If the session is not active and executing a statement, a message notifying you that the session is not active and that no text is available is displayed.
About Statement and Batch entities
The Statement and Batch entities display information on a SQL statement that was executed by the selected session during the last time slice.
About getting an overview of current Statement and Batch entities
Displays general information on the statement or batch, including overall properties, its breakdown In MS-SQL during the last time slice, and the breakdown of the locks during the last time slice.
...
Table 5-14 Statement or Batch Overview view
...
View Area | Description |
---|---|
Statement/Batch |
...
ID | Displays the internal statement hash value (SHV) calculated by the Collector, or, in the case of a stored procedure, displays the name of the stored procedure. |
Database |
...
Identifies the database on which the statement or batch is run. This information is used by Precise for SQL Server to display the statement's execution plan. |
User |
...
Displays the parsing user who runs the statement or batch. This information is used by |
...
Precise for SQL Server to display the statement's execution plan. |
Executions |
...
Number of times the Collector identifies that the statement or batch was executed. |
Duration |
...
Total time required to execute the selected statement or batch during the last time slice. |
Duration (Avg) |
...
Average duration of each statement or batch execution during the last time slice. | |
CPU |
...
Time | Cumulative CPU time for the statement or batch during the last time slice. |
Physical I/O |
...
Operations | Total number of physical I/O requests during the execution of the statement or batch during the last time slice. |
Parallel Sessions (Min) |
...
Minimum number of threads used to execute the statement or batch in parallel. This counter is calculated from the ECID column in sysprocesses. This enables you to verify that SQL Server is using the best execution plan for the current statement. | |
Parallel Sessions (Max) |
...
Maximum number of threads used to execute the statement or batch in parallel. This counter is calculated from the ECID column in sysprocesses. This enables you to verify that SQL Server is using the best execution plan for the current statement. | |
In MS-SQL (Last minute) |
...
Displays the resource consumption breakdown of the statement or batch during the last minute (that is, 60 samples of the Collector). In addition to the resource distribution, the view displays the number of sessions in each state during the last sample. It is important to remember that since this view only displays the last minute's activities, you will always be viewing the activities that occurred during the last minute and not the activities that occurred since the last refresh action. The following information is displayed: |
...
|
...
|
...
|
...
|
...
|
About viewing current Statement and Batch text
Displays text of the selected statement or batch.
...