The Sessions Details view provides an in-depth analysis of sessions running on your monitored SQL Server instance. You can view a wide range of information from performance details to open transactions and configured options or track process activity at the statement level. Individual sessions appear in the top portion of the window.
Right-click any session in the list to view locks, show your query history, trace the session, kill the session, print View Locks, Show Query History, Trace Session, Kill Session, Print the associated statistics, or export Export statistics to Microsoft Excel.
Image Added
When you select a session, SQL Diagnostic Manager displays the statistics for that session in the Details section at the bottom of the window. This section includes in-depth information regarding the session connectionConnection, usageUsage, lockLock, and tempdb usage. If you want to copy the Last Command information to the Windows clipboard, right-click in that area, and then click CopyTempdb usage.
Access the Details view
To open the Details view of the SQL Diagnostic Manager Sessions select the the appropriate SQL Server SQL Server instance, and then click Sessions > Details.
Image Added
| Tip |
|---|
| Select the Filter button to select items shown on the view. |