Data Quality

Collector health and telemetry coverage

This page shows whether dashboards, AI, reports and action queues are working with complete evidence or silent gaps.

100.0% coverage
Sources checked45
Telemetry gaps0
Affected servers0
Trusted servers5
Partial evidence0
Blind spots0
Coverage gauge100.0%
100%
Evidence split45 checks
45 available 0 gaps
Gap driversby source
All checked sources are available.
Blind spots by serverhighest gap count
No server blind spots.
Consumers impactedwhy data matters
All consumers have their required evidence.
Fix routingoperational next step
Keep source checks monitored and review collector changes after deployments.
TrustedAll expected evidence is present for the server, so green operational pages are meaningful.
PartialSome pages are usable, but findings must be read with the missing source in mind.
Blind spotThe system may be quiet because data is missing, not because the server is healthy.
1
Fix P1 gaps first

Backup, SQL Agent, EventLog and live DMV gaps can hide the most important operational incidents.

2
Use server confidence

Do not treat a green server as healthy when it is marked Partial or Blind spot.

3
Refresh evidence pages

After a permission or collector fix, revisit Backup Readiness, Action Center, Forecast and Reports.

Fix first0 prioritized gaps
No collector or permission gap needs immediate work.
Source reliability9 source groups
Source Used by Checks Gaps Missing impact Professional fix
AuditLog Dashboard activity feed and operational audit context 5 0 Recent maintenance or configuration activity can be missing from review. Confirm audit table deployment, collector writes and read permission.
DbSizes Forecast, database growth, largest database and capacity planning 5 0 Growth forecasts and capacity planning become incomplete or manual. Run the size collector, verify retention and confirm dbsizes rows are current.
EventLog AI Incidents, Action Center, runtime pulse, deadlocks and blocking 5 0 Errors, timeouts, login failures, deadlocks and blocking can be hidden. Fix event ingestion, validate EventLog schema and confirm recent rows are written.
LiveRequests Long running queries, blocking context and active workload triage 5 0 Active workload incidents can disappear from incident triage. Grant VIEW SERVER STATE and validate live request collection.
MsdbAgent SQL Agent failures, Action Center and daily operations 5 0 Failed maintenance, ETL or collection jobs may be missed. Validate SQL Agent history retention, msdb permissions and collector access.
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 Server Overview, resource pressure and impact scoring 5 0 CPU, memory and workload pressure lose context. Confirm health collector cadence, repository writes and read permission.
TempDb TempDB pressure, Server Overview and incident context 5 0 TempDB pressure can be missed when diagnosing blocking, spills or long transactions. Grant VIEW SERVER STATE and validate TempDB usage collection.
VolumeStats Storage, Forecast and low-space rules 5 0 Disk risk can be missed until SQL or backup activity fails. Grant required metadata visibility and confirm volume collection works.
Server confidence5 server profiles
Server Status Coverage Missing sources Next action
TESTSRV_1.DBNEXIA.COM Trusted
100%
- Keep collectors monitored after deployments and permission changes.
TESTSRV_2.DBNEXIA.COM Trusted
100%
- Keep collectors monitored after deployments and permission changes.
TESTSRV_3.DBNEXIA.COM Trusted
100%
- Keep collectors monitored after deployments and permission changes.
TESTSRV_4.DBNEXIA.COM Trusted
100%
- Keep collectors monitored after deployments and permission changes.
TESTSRV_5.DBNEXIA.COM Trusted
100%
- Keep collectors monitored after deployments and permission changes.
Coverage matrix 2026-07-04 07:36
Server AuditLog DbSizes EventLog LiveRequests MsdbAgent MsdbBackup ServerMetrics TempDb VolumeStats Gaps
TESTSRV_1.DBNEXIA.COM ok ok ok ok ok ok ok ok ok 0
TESTSRV_2.DBNEXIA.COM ok ok ok ok ok ok ok ok ok 0
TESTSRV_3.DBNEXIA.COM ok ok ok ok ok ok ok ok ok 0
TESTSRV_4.DBNEXIA.COM ok ok ok ok ok ok ok ok ok 0
TESTSRV_5.DBNEXIA.COM ok ok ok ok ok ok ok ok ok 0
Gap details0 open
All configured telemetry sources are available.
Source catalogue9 professional definitions
EventLog AI Incidents, Action Center, runtime pulse, deadlocks and blocking

Access: dbNexia_db.dbo.EventLog with a recognized time column

Impact: Errors, timeouts, login failures, deadlocks and blocking can be hidden.

Fix: Fix event ingestion, validate EventLog schema and confirm recent rows are written.

AuditLog Dashboard activity feed and operational audit context

Access: dbNexia_db.dbo.AuditLog

Impact: Recent maintenance or configuration activity can be missing from review.

Fix: Confirm audit table deployment, collector writes and read permission.

DbSizes Forecast, database growth, largest database and capacity planning

Access: dbNexia_db.dbo.dbsizes

Impact: Growth forecasts and capacity planning become incomplete or manual.

Fix: Run the size collector, verify retention and confirm dbsizes rows are current.

ServerMetrics Server Overview, resource pressure and impact scoring

Access: dbNexia_db.dbo.ServerMetrics

Impact: CPU, memory and workload pressure lose context.

Fix: Confirm health collector cadence, repository writes and read permission.

MsdbBackup Backup Readiness, Action Center and Dashboard

Access: Read access to msdb.dbo.backupset

Impact: Backup freshness and restore-chain risk cannot be verified.

Fix: Grant required msdb history access and confirm backup jobs write expected history.

MsdbAgent SQL Agent failures, Action Center and daily operations

Access: Read access to msdb SQL Agent history

Impact: Failed maintenance, ETL or collection jobs may be missed.

Fix: Validate SQL Agent history retention, msdb permissions and collector access.

LiveRequests Long running queries, blocking context and active workload triage

Access: VIEW SERVER STATE permission

Impact: Active workload incidents can disappear from incident triage.

Fix: Grant VIEW SERVER STATE and validate live request collection.

VolumeStats Storage, Forecast and low-space rules

Access: VIEW SERVER STATE permission for volume metadata

Impact: Disk risk can be missed until SQL or backup activity fails.

Fix: Grant required metadata visibility and confirm volume collection works.

TempDb TempDB pressure, Server Overview and incident context

Access: VIEW SERVER STATE permission

Impact: TempDB pressure can be missed when diagnosing blocking, spills or long transactions.

Fix: Grant VIEW SERVER STATE and validate TempDB usage collection.