Data Quality

Data Quality

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

100.0% coverage
Sources checked50
Telemetry gaps0
Affected servers0
Trusted servers5
Partial evidence0
Blind spots0
Coverage gauge100.0%
100%
Evidence split50 checks
50 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, job history, event/alert and live workload 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 reliability10 source groups
Source Used by Checks Gaps Missing impact Professional fix
AuditLog Dashboard activity feed and operational audit context 5 0 Recent maintenance, security or configuration activity can be missing from review. Confirm audit collection and central synchronization for this source.
CentralSnapshot All historical reports, audit/event analysis and growth trends 5 0 The application can show stale or missing history for the affected source server. Open Admin > dbNexia_DB Sync, inspect the source error and run central synchronization after fixing connectivity or permissions.
DbSizes Forecast, database/tablespace growth, largest database and capacity planning 5 0 Growth forecasts and capacity planning become incomplete or manual. Run the source size collector, then confirm central history is 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 or grant Oracle diagnostic alert visibility, then confirm recent rows are present centrally.
LiveRequests Long running queries, blocking context and active workload triage 5 0 Active workload incidents can disappear from incident triage. Grant live workload visibility and validate request/session collection.
MsdbAgent Job failures, Action Center and daily operations 5 0 Failed maintenance, ETL or collection jobs may be missed. Validate job history retention and grant SQL Agent or Oracle Scheduler history access.
MsdbBackup Backup Readiness, Action Center and Dashboard 5 0 Backup freshness and restore-chain risk cannot be verified. Grant required backup-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 the source collector cadence and central synchronization status.
TempDb TempDB/Oracle TEMP pressure, Server Overview and incident context 5 0 Temporary-space pressure can be missed when diagnosing blocking, spills or long transactions. Grant temporary-space visibility and validate usage collection.
VolumeStats Storage, Forecast and low-space rules 5 0 Storage risk can be missed until SQL, Oracle or backup activity fails. Grant required metadata visibility and confirm storage 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-09-21 19:02
Server AuditLog CentralSnapshot DbSizes EventLog LiveRequests MsdbAgent MsdbBackup ServerMetrics TempDb VolumeStats Gaps
TESTSRV_1.DBNEXIA.COM ok ok ok ok ok ok ok ok ok ok 0
TESTSRV_2.DBNEXIA.COM ok ok ok ok ok ok ok ok ok ok 0
TESTSRV_3.DBNEXIA.COM ok ok ok ok ok ok ok ok ok ok 0
TESTSRV_4.DBNEXIA.COM ok ok ok ok ok ok ok ok ok ok 0
TESTSRV_5.DBNEXIA.COM ok ok ok ok ok ok ok ok ok ok 0
Gap details0 open
All configured telemetry sources are available.
Source catalogue10 professional definitions
CentralSnapshot All historical reports, audit/event analysis and growth trends

Access: Recent incremental per-server history in central dbNexia_ADMIN_DB

Impact: The application can show stale or missing history for the affected source server.

Fix: Open Admin > dbNexia_DB Sync, inspect the source error and run central synchronization after fixing connectivity or permissions.

EventLog AI Incidents, Action Center, runtime pulse, deadlocks and blocking

Access: SQL EventLog collector plus incremental central history, or Oracle V$DIAG_ALERT_EXT

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

Fix: Fix event ingestion or grant Oracle diagnostic alert visibility, then confirm recent rows are present centrally.

AuditLog Dashboard activity feed and operational audit context

Access: Central SQL AuditLog history or Oracle audit collector

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

Fix: Confirm audit collection and central synchronization for this source.

DbSizes Forecast, database/tablespace growth, largest database and capacity planning

Access: Central SQL dbsizes history or central Oracle tablespace history

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

Fix: Run the source size collector, then confirm central history is current.

ServerMetrics Server Overview, resource pressure and impact scoring

Access: A synchronized SQL ServerMetrics snapshot or Oracle central collector

Impact: CPU, memory and workload pressure lose context.

Fix: Confirm the source collector cadence and central synchronization status.

MsdbBackup Backup Readiness, Action Center and Dashboard

Access: SQL msdb.dbo.backupset or Oracle V$RMAN_BACKUP_JOB_DETAILS

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

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

MsdbAgent Job failures, Action Center and daily operations

Access: SQL Agent history or Oracle DBA_SCHEDULER_JOB_RUN_DETAILS

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

Fix: Validate job history retention and grant SQL Agent or Oracle Scheduler history access.

LiveRequests Long running queries, blocking context and active workload triage

Access: SQL VIEW SERVER STATE or Oracle V$SESSION/V$SQL

Impact: Active workload incidents can disappear from incident triage.

Fix: Grant live workload visibility and validate request/session collection.

VolumeStats Storage, Forecast and low-space rules

Access: SQL volume metadata or Oracle DBA_FREE_SPACE

Impact: Storage risk can be missed until SQL, Oracle or backup activity fails.

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

TempDb TempDB/Oracle TEMP pressure, Server Overview and incident context

Access: SQL VIEW SERVER STATE or Oracle DBA_TEMP_FILES/V$TEMP_SPACE_HEADER

Impact: Temporary-space pressure can be missed when diagnosing blocking, spills or long transactions.

Fix: Grant temporary-space visibility and validate usage collection.