Page History

...

The Listing view helps you to monitor your SQL Server instances with the following information. To do so, you can choose one or more of the diagnostic statistics metrics:

• Status
• Session ID
• Type
• Host
• Blocked By
• Blocking
• CPU (ms)
• Memory Usage
• Physical I/O
• Wait Time (ms)
• User
• Host
• Database
• Open Transaction
• Command
• Application
• Execution Context
• Wait Type
• Wait Resource
• CPU Delta (ms)
• Loging Time
• Physical I/O Delta
• Last Batch
• Blocking Count
• Net Address
• Net Library
• Version Elapsed Seconds
• Transaction
• Current Session
• Session User Space Allocated (kb)
• Session User Space Deallocated (kb)
• Current Task User Space (kb)
• Task User Space Allocated (kb)
• Task User Space Deallocated (kb)
• Current Session Internal Space (kb)
• Session Internal Space Allocated (kb)
• Session Internal Space Deallocated (kb)
• Current Task Internal Space (kb)
• Task Internal Space Allocated (kb)
• Task Internal Space Deallocated (kb)
• Last Command

...

The Sessions view presents two ways of filtering your session instance information using the following options:

Time Range Filter

To monitor the sessions server status in a frame time use the time range filter. Modify the start and end time and date according your needings.

...

The first one, consists

...

Image Added

Session Filter

To monitor your sessions by type, you can click on one of the next options to display data:

Image Added

• • Sessions - Filters all the sessions across your SQL Server instances
  • Blocked - Filters the blocked SQL Server instances
  • Blocking - Filter the blocking SQL Server instances

Comlumn Filter

To filter specific criteria by column, select a column, click on the Image Added icon next to the icon's name, select the Filter option, and select or type the searching criteria.

Image Added

Check Session Details

The Session tab allows you to get a detailed summary for each session. To check the sessions details, double click in a specific session and the following window will pop up.

Image Added

In the Session Details window you will find sessions data regarding to

• Connection information
• Usage metrics
• Last Command used
• Lock Information  metrics
• Temp DB Usage metrics
• Space used in kb (alloc/deadloc) metrics

Anchor
Chart Chart

Charts

The Sessions > Sessions Graphs tab contains the following charts (Click image to view full size):

...