Performance – Processes View
Legend 1 Main process grid display + aggregation function selection (Average, Max, Min). The default is Max. Pay attention to the timeframe. Column Description Service Name OS service name Display Name OS service display name Status This is the last status according to the timeframe. Status can be Running or Stopped. Running Chart A chart […]
Performance – Services View
Legend 1 Services grid. This grid is directly affected by the selection of the timeframe. Column Description Service Name OS service name Display Name OS service display name Status his is the last status according to the timeframe. Status can be Running or Stopped. Running Chart A chart that shows when the service was running […]
Performance – Waits View
Main waits chart Main wait event Enhanced Chart distributed by the main wait categories: IO waits, Network waits, Backup waits, CPU waits, Non-Page Latch waits, Lock waits, Transaction Log waits, Tempdb waits. Wait Category Grid Legend 1 Wait event filters: Filter by category name Filter by category type Filter by description 2 Wait event category […]
Performance – Temp DB View
Temp DB – Part 1 Legend 1 Enhanced Chart of Total read activity over the selected time range of all TempDB files. 2 Enhanced Chart of Total write activity over the selected time range of all TempDB files. Temp DB – Part 2 Legend 1 TempDB table count distributions. There are five types: Global […]
Performance – Queries View
The chart will portray the top 5 batch/queries according to the selected performance metric. Legend 1 Select a performance metric to receive the top 5 “worse” queries. Default is by “Duration”. Other options: 2 Chart type selection. Default selection is Bars. Other options: 3 Results of charts displaying top 5 query activity sorted by #1 […]
Performance – Deadlocks View
A deadlock occurs when two or more tasks permanently block each other because each task has a lock on a resource that the other tasks are trying to lock. For example: Transaction A acquires a shared lock on row 1. Transaction B acquires a shared lock on row 2. Transaction A now requests an exclusive […]
Performance – Blocking View
In SQL Server, blocfiing occurs when one session holds a locfi on a specific resource and a second SPID attempts to acquire a conflicting lock type on the same resource. Typically, the time frame for when the first SPID locks the resource is small. Long transactions occur when a single session opens a transaction and […]
Performance – Network View
Legend 1 Enhanced Chart of network activity over time. Received, Send, Total network activity in bytes. 2 Wait Control – wait events that are associated with the network for the selected time frame: ASYNC_NETWORK_IO – Caused when network writes are blocked behind the network. Ensure the client is processing server data.
Performance – Disk/Partitions View
Use this view to recognize disk issues in IO-intense systems. Disks/Partitions – Part 1 Legend 1 Main partition distribution for the server showing total used vs. total size. 2 Partition selection: by default, all partitions are selected. This allows a focus on a specific partition. 3 Enhanced Chart of Disk latency of timeframe. Disk latency […]
Performance – Memory View
The memory performance view allows the breakdown of memory (RAM) related events, multiple instances of the same machine events, processes affecting the memory and more. Use this view to monitor and identify performance issues that are directly related to memory-intensive systems. Memory – Part 1 Legend 1 Allocated memory usage of the instance. This will […]