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 Management Studio
surface form: 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
surface form: SQL Server Management Studio 2008
limitedBy overhead on monitored SQL Server instance
monitors SQL Server instance
partOf SQL Server Management Studio
platform SQL Server
surface form: Microsoft 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 on Azure Virtual Machines
surface form: 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