Page History
...
Anchor SignatureMode SignatureMode
Signature Mode
| SignatureMode | |
| SignatureMode |
The Signature Mode tab helps you to monitor your SQL Server instances. To do so, you can choose one or more of the diagnostic statistics metrics:
- Status
- Session ID
You can configure the columns displayed in the Listing view by clicking the option icon, hovering the mouse over the column option, and choosing the metrics of your interest.
Besides displaying diagnostic statistics of the monitored SQL Server instance, the Lisinting view allows you to perform the following actions:
Filter Information
The Sessions view presents ways of filtering your session instance information using the following options:
Time Range Filter
To monitor the session's server status in a frame of time use the time range filter. Modify the start and end time and date according to your needs.
Session Filter
To monitor your sessions by type, you can click on one of the next options to display data:
- Sessions - Filters all the sessions across your SQL Server instances
- Blocked - Filters the blocked SQL Server instances
- Blocking - Filter the blocking SQL Server instances
Column Filter
To filter specific criteria by column, select a column, click on the icon next to the icon's name, select the Filter option, and select or type the searching criteria.
| Info |
|---|
When using the Column filter, consider that each column has its own selection criteria. |
Check Session Details
The Session tab allows you to get a detailed summary of each session. To check the session details, double-click on a specific session and the following window will pop up.
In the Session Details window, you will find session data regarding:
- Connection information
- Usage metrics
- Last Command used
- Lock Information metrics
- Temp DB Usage metrics
- Space used in kb (alloc/deadlock) metrics
includes all active query information, automatically reduced to the signatures and grouped accordingly. For more information about using this view and fields, see the help topic for the desktop version at: View the query monitor signature mode.
Anchor StatementMode StatementMode
Statement Mode
| StatementMode | |
| StatementMode |
The Statement Mode tab gives you a graphic status session report containing the following charts :
Response Time (ms)
The Response Time chart displays the response time (in milliseconds) it takes a Select SQL statement to go to the SQL Server instance and back. This chart indicates the current speed and congestion of the network as well as the speed with which the SQL Server processes small queries.
Blocked Sessions
The Blocked Sessions chart lists all the Blocked Sessions, Lead Blockers, and Total Deadlocks for the selected SQL Server instance. This allows you to easily view blocks as they occur.
Lock Statistics
The Lock Statistics chart displays all the lock object statistics, helping you to pinpoint, correct, or reschedule automated applications that cause extensive row, table, or database locking. The chart includes the following objects.
...
includes queries that are presented exactly as they are collected by the Query Monitor Trace. For more information about using this view and fields, see the help topic for the desktop version at: View the query monitor statement mode.
Anchor QueryHistory QueryHistory
Query History
| QueryHistory | |
| QueryHistory |
The Query History tab gives gives you a graphic status session report containing the following charts :
Response Time (ms)
The Response Time chart displays the response time (in milliseconds) it takes a Select SQL statement to go to the SQL Server instance and back. This chart indicates the current speed and congestion of the network as well as the speed with which the SQL Server processes small queries.
view of the performance of a query over time. For more information about using this view and fields, see the help topic for the desktop version at: View the query history.
Anchor QueryWaits QueryWaits
Query Waits
| QueryWaits | |
| QueryWaits |
The Query Waits tab gives you a graphic status session report containing the following charts :
Response Time (ms)
...
tab
The Query Waits view displays the queries on your SQL Server instance with the longest wait times. For more information about this view and fields, see the help topic for the desktop version at: View query waits.