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

Azure SQL Managed Instance alarms

Respond to Azure SQL Managed instance alarms raised by Spotlight.

Alarms that can be raised against an Azure SQL Managed instance connection

How to acknowledge an alarm

If an alarm is configured to require acknowledgment then each raised instance of the alarm remains present in Spotlight until it is acknowledged. For detailed information, see Acknowledge alarms in Spotlight Enterprise.

How to snooze an alarm

To snooze an alarm is to temporarily remove the visual alert associated with an alarm. For detailed information, see Snooze alarms in Spotlight Enterprise.

How to configure an alarm

See Configure Alarms to set the thresholds and severities that determine when an alarm is raised. Disable an alarm. Set an alarm to require acknowledgment. Configure keyed alarms. Collect additional diagnostic information on an alarm.

See Configure Alarm Actions to setup actions for Spotlight to take when an alarm is raised. The actions Spotlight can take include running a program and sending an email. Conditions on taking the action can be defined, such as the day of the week, the time of day, the severity of the alarm, the alarm type and the connection type.

Tags: