Azure SQL Managed Instance
Welcome
- Welcome
Connect
- Connection Details
- Grant Account Permissions
Alarms (A-K)
- Alarms
- CPU Time Percentage Used
- Databases - Data File Group About to Grow
- Databases - Data File Group Space Used
- Databases - Dynamic Data File Group Growths Remaining
- Databases - Dynamic Log File Growths Remaining
- Databases - Log File Space Used
- Databases - Log Flush Wait Time
- Databases - SQL I/O Errors
- Databases - Unavailable
- Error Log - Error Count
- Error Log - Fatal Current Process Error (severity level 20)
- Error Log - Fatal Database Integrity Suspect Error (severity level 23)
- Error Log - Fatal Database (dbid) Processes Error (severity level 21)
- Error Log - Fatal Hardware Error (severity level 24)
- Error Log - Fatal Hardware Error (severity level 25)
- Error Log - Fatal Table Integrity Suspect Error (severity level 22)
- Error Log - High Severity Message
- Error Log - Information Severity Message
- Error Log - Low Severity Message
- Error Log - Medium Severity Message
- I/O Stall Time
- Index Fragmentation
- Index Fragmentation Status
Alarms (L-M)
- Latch - Total Wait Time Rate
- Locks - Blocked Processes
- Locks - Deadlocks
- Memory - Page Life Expectancy
- Missing SQL Performance Counters
- Monitored Server - Azure SQL Managed Instance Alarm Action Failure
- Monitored Server - Azure SQL Managed Instance Alarm Evaluation Failure
- Monitored Server - Azure SQL Managed Instance Collection Execution Failure
- Monitored Server - Azure SQL Managed Instance Connection Failure
- Monitored Server - Azure SQL Managed Instance Host Not Defined
- Monitored Server - Azure SQL Managed Instance Planned Outage
- Monitored Server - Azure SQL Managed Instance Secondary Connection Failure
Alarms (N-Z)
- Network - Azure SQL Managed Instance Packets Error Rate
- Performance Investigator
- Poor Performance Health
- SQL - Long Running SQL
- SQL - Running out of Threads
- SQL Agent - Jobs Failed
- SQL Agent - Long Running Jobs (Percent)
- SQL Agent - Long Running Jobs (Time)
- SQL Custom Counters
- SQL Virtual Log Files Count
- Storage Free Space
- Storage Percentage Used
- Tempdb Auto Growth
- Tempdb Contention
- Tempdb Version Store Generation Rate
- Tempdb Version Store Size
- User - Connection Count
- User - Logins Per Second
- User - Response Time
Spotlight Overview page
- Spotlight Overview page
- Sessions panel
- Flows
- Processes Panel
  - Total
  - System
  - User
  - Blocked Processes
  - CPU Usage
- Flows
  - Logical Reads
  - Compiles
- Memory panel
- Flows
- Disk Storage panel
- Performance Health panel
  - Performance Health
- System panel
  - Version
  - Host
  - Custom
  - Status
- Background Processes panel
  - Error Log
  - Jobs
Memory drilldown
- Memory drilldown
- Memory Areas
- Server Memory
- Hit Rates
- Cache
- Buffer Cache Page Life Expectancy
SQL Activity drilldown
- SQL Activity drilldown
- Sessions page
- Summary page
- Locks page
  - Locks
  - Lock Types
  - Latches
- Blocking page
  - Blocking
  - Number of Blocked Processes
- Deadlocks page
  - Deadlock List
- I/O by File page
  - I/O by File grid
  - I/O by File chart
- Custom Counters page
  - Custom Counters chart
  - Custom Counters grid
- Query Execution Statistics page
Performance Health drilldown
- Performance Health drilldown
Wait Statistics drilldown
- Wait Statistics drilldown
- Wait Time Trend
- Waits Detail
Wait Events drilldown
- Wait Events drilldown
- SQL
- Plan
Databases drilldown
- Databases drilldown
- Databases page
  - Databases grid
- Summary page
  - Database Space
  - Database History
- File Groups page
- Data Files page
- Transaction Logs page
- Log Files page
- Tables page
- Indexes page
- Disk Space page
  - Disk Space chart
- Fragmented Indexes page
  - Fragmented Indexes grid
Support Services drilldown
- Support Services drilldown
- SQL Agent Jobs page
- Full Text Search page
  - Full Text Search Service
Configuration drilldown
- Configuration drilldown
- Configuration page
  - SQL Server Configuration grid
Error log drilldown
- Error log drilldown
- SQL Server Error Logs
- SQL Agent Error Logs
Workload Analysis drilldown
- Workload Analysis drilldown
- SQL
- Plan
Tempdb drilldown
- Tempdb drilldown
- Usage page
- Contention page
  - Wait Time
  - Sessions involved in this contention
Collections
- Collections
- Collect additional diagnostic information
Troubleshooting
- Troubleshooting

SQL Agent - Jobs Failed alarm

The SQL Agent - Jobs Failed alarm is raised when Spotlight Enterprise detects that at least one SQL Agent job has failed in the last few minutes.

When the alarm is raised, open the SQL Server | Support Services drilldown | SQL Agent Jobs page for information on SQL Agent jobs. You can double click any job to view the messages that it logged during its last run. This page shows the last run time and completion status of each job, as well as a graph showing which jobs ran recently, and the completion status for each run.

Spotlight collects data on failed jobs from the Azure SQL Managed instance periodically (every 5 minutes by default). This alarm will report on all failed jobs since the last data collection. You can configure data collection schedules from the Spotlight Client, Configure | Scheduling.

Tip: You can configure this alarm to ignore certain values. You can configure different alarm severities for specific agent jobs. Configure this alarm with the Spotlight Client, Configure | Alarms.

Tags: