Use Performance Objects
Applies to: SQL Server Azure SQL Managed Instance
Important
On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.
SQL Server Agent includes performance objects and counters to monitor how the service is performing. These performance objects allow you to use Performance Monitor, a Windows tool, to identify what the SQL Server Agent service is doing in the background. For example, you can identify how many active jobs the SQL Server Agent service is currently running to identify those jobs that are blocked.
The SQL Server Agent service performance objects and counters exist for each instance of SQL Server that is installed on a computer. Performance objects are named according to the instance of SQL Server that each object represents.
The following table shows how the SQL Server Agent service performance objects are named:
Instance type | Object name |
---|---|
Default | SQLAgent:object:counter |
Named | SQLAgent$ *instance_name* :object:counter |
SQL Server includes the following performance objects for SQL Server Agent.
Object name | Description |
---|---|
SQLAgent:Jobs | Performance information about jobs that have been started, success rates, and current status |
SQLAgent:JobSteps | Status information about job steps |
SQLAgent:Alerts | Information about number of alerts and notifications |
SQLAgent:Statistics | General performance information |
See Also
Monitor and Tune for Performance
How to: Start System Monitor (Windows)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho