SQL Server
Welcome
- Welcome
Connect
- Connection Details
- Connection Requirements
- Grant account permissions
Alarms (A-K)
- Alarms
- Backup - Days Since Last Full Backup
- Backup - Hours Since Last Differential Backup
- Backup - Minutes Since Last Log Backup
- Clusters - Failed Over
- Clusters - File Share Witness Inaccessible
- Clusters - Node Unavailable
- Clusters - Non-Preferred Node
- Compiles - Percentage Recompilations
- 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 - Critical Error (severity level lower than 20)
- 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
- LiteSpeed Backup Failed
- LiteSpeed Backup Warning
- Locks - Blocked Processes
- Locks - Deadlocks
- Log Shipping - Primary Backup Job
- Log Shipping - Secondary Job
- Log Shipping - Secondary Latency
- Memory - Page Life Expectancy
- Mirroring - State
- Mirroring - Unrestored Log
- Mirroring - Unsent Log
- Mirroring - Failedover
- Missing SQL Performance Counters
- Monitored Server - SQL Server Alarm Action Failure
- Monitored Server - SQL Server Alarm Evaluation Failure
- Monitored Server - SQL Server Collection Execution Failure
- Monitored Server - SQL Server Connection Failure
- Monitored Server - SQL Server Host Not Defined
- Monitored Server - SQL Server Planned Outage
- Monitored Server - SQL Server Secondary Connection Failure
- Monitored Server - SQL Server Unsupported Version
Alarms (N-Z)
- Network - SQL Server Packets Error Rate
- Performance Investigator
- Poor Performance Health
- Services - DTC Service Status
- Services - Full Text Search
- Services - Integration Service Status
- Services - Reporting Service Status
- Services - SQL Agent Mail Status
- SQL - Long Running SQL
- SQL - Running out of Threads
- SQL Agent - Alerts
- SQL Agent - Jobs Failed
- SQL Agent - Long Running Jobs (Percent)
- SQL Agent - Long Running Jobs (Time)
- SQL Agent - Status
- SQL Custom Counters
- SQL Virtual Log Files Count
- Tempdb Auto Growth
- Tempdb Contention
- Tempdb File Location
- Tempdb File Size
- Tempdb Growth Settings
- Tempdb Number of Files
- 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
- 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
  - Services
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
High Availability drilldown
- High Availability drilldown
- Transaction Log Shipping page
- Database Mirroring page
  - Database Mirroring grid
  - Database Mirroring details
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
- LiteSpeed Backups page
  - LiteSpeed Backup History
- Fragmented Indexes page
  - Fragmented Indexes grid
Support Services drilldown
- Support Services drilldown
- SQL Agent Jobs page
- Service Status page
  - Service Status grid
  - Service Status History
- SQL Agent Alerts page
  - SQL Agent Alerts grid
  - Alert Occurrences
- Cluster Services page
  - Cluster Services grid
- DTC page
  - DTC Details
- 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 Server 2017 and above hosted on Linux
- SQL Server 2017 and above hosted on Linux

SQL Agent - Long Running Jobs (Time) alarm

The SQL Agent - Long Running Jobs (Time) alarm is raised when a SQL Agent job has been running for a long time.

The default threshold for this alarm is 600 seconds.

When this alarm is raised, open the SQL Server | Support Services drilldown | SQL Agent Jobs page to investigate the long running SQL Agent Job.

Tags: