Activity Monitor

E277018

Activity Monitor is a performance monitoring tool in SQL Server Management Studio that provides real-time insight into SQL Server processes, resource usage, and system activity.

All labels observed (1)

Label Occurrences
Activity Monitor canonical 1

How this entity was disambiguated

Statements (49)

Predicate Object
instanceOf SQL Server Management Studio feature ⓘ
SQL Server performance monitoring tool ⓘ
accessedFrom Object Explorer context menu in SQL Server Management Studio ⓘ
Tools menu in SQL Server Management Studio ⓘ
allows filtering of process list ⓘ
right-click actions on sessions ⓘ
sorting of grid columns ⓘ
canKill SQL Server sessions ⓘ
canLaunch query window for selected query ⓘ
category database performance monitoring ⓘ
developedBy Microsoft ⓘ
displaysMetric Active user processes ⓘ
Batch requests per second ⓘ
Blocked processes ⓘ
CPU usage ⓘ
Disk I/O statistics ⓘ
I/O usage ⓘ
Memory usage ⓘ
Top resource-consuming queries ⓘ
Wait statistics ⓘ
hasView Data File I/O pane ⓘ
Overview pane ⓘ
Processes pane ⓘ
Recent Expensive Queries pane ⓘ
Resource Waits pane ⓘ
introducedIn SQL Server Management Studio 2008 ⓘ
limitedBy overhead on monitored SQL Server instance ⓘ
monitors SQL Server instance ⓘ
partOf SQL Server Management Studio ⓘ
platform Microsoft SQL Server ⓘ
linked to: SQL Server
provides real-time insight into SQL Server processes ⓘ
real-time insight into resource usage ⓘ
real-time insight into system activity ⓘ
readsFrom dynamic management views ⓘ
system catalog views ⓘ
refreshes data at configurable intervals ⓘ
requires VIEW SERVER STATE permission in SQL Server ⓘ
connection to a SQL Server instance ⓘ
permissions to view server state ⓘ
runsOn SQL Server Management Studio ⓘ
supports SQL Server instances in Azure Virtual Machines ⓘ
SQL Server on Linux ⓘ
SQL Server on Windows ⓘ
usedFor identifying blocking sessions ⓘ
identifying expensive queries ⓘ
monitoring resource bottlenecks ⓘ
performance troubleshooting ⓘ
visualizes performance data using graphs ⓘ
performance data using grids ⓘ

How these facts were elicited

Referenced by (1)

Full triples — surface form annotated when it differs from this entity's canonical label.

SQL Server Management Studio → hasComponent → Activity Monitor ⓘ