Collector health and telemetry coverage
This page shows whether dashboards, AI, reports and action queues are working with complete evidence or silent gaps.
| Source | Used by | Checks | Gaps | Missing impact | Professional fix |
|---|---|---|---|---|---|
| AuditLog | Operational pages | 5 | 0 | The related signal can be incomplete or misleading. | Check collector job, permissions and repository data for this source. |
| DbSizes | Operational pages | 5 | 0 | The related signal can be incomplete or misleading. | Check collector job, permissions and repository data for this source. |
| EventLog | AI Incidents, runtime pulse and security signals | 5 | 0 | Errors, timeouts and login-failure bursts can be hidden. | Fix collector account permissions and confirm recent event ingestion. |
| LiveRequests | Operational pages | 5 | 0 | The related signal can be incomplete or misleading. | Check collector job, permissions and repository data for this source. |
| MsdbAgent | Operational pages | 5 | 0 | The related signal can be incomplete or misleading. | Check collector job, permissions and repository data for this source. |
| MsdbBackup | Backup Readiness, Action Center and Dashboard | 5 | 0 | Backup freshness and restore-chain risk cannot be verified. | Grant required msdb history access and confirm backup jobs write expected history. |
| ServerMetrics | Operational pages | 5 | 0 | The related signal can be incomplete or misleading. | Check collector job, permissions and repository data for this source. |
| TempDb | Operational pages | 5 | 0 | The related signal can be incomplete or misleading. | Check collector job, permissions and repository data for this source. |
| VolumeStats | Operational pages | 5 | 0 | The related signal can be incomplete or misleading. | Check collector job, permissions and repository data for this source. |
Access: Network path plus valid SQL credentials
Impact: Server can look healthy in inventory while live checks are blind.
Fix: Refresh Status, verify listener/port/firewall and update connection metadata.
Access: Read access to msdb backup history
Impact: Backup freshness and restore-chain risk cannot be verified.
Fix: Grant required msdb history access and confirm backup jobs write expected history.
Access: Read access to msdb job history
Impact: Failed maintenance, ETL or collection jobs may be missed.
Fix: Validate SQL Agent is running, job history retention and msdb read permissions.
Access: Windows/EventLog collector access
Impact: Errors, timeouts and login-failure bursts can be hidden.
Fix: Fix collector account permissions and confirm recent event ingestion.
Access: VIEW SERVER STATE and collector schedule
Impact: CPU, memory and pressure signals lose context.
Fix: Grant metadata visibility and confirm health collector cadence.
Access: Repository table/file growth collection
Impact: Forecast confidence drops and capacity planning becomes manual.
Fix: Run growth collector, verify retention and check repository writes.
Access: Volume/mount point visibility
Impact: Disk risk can be missed until SQL or backup activity fails.
Fix: Enable volume collector and confirm service account can read mount points.
Access: VIEW SERVER STATE
Impact: Active workload incidents can disappear from incident triage.
Fix: Grant VIEW SERVER STATE and validate live request collection.