Operations

dbNexia DEMO Operations Cockpit

Prioritized health, capacity, backup, job, and workload signals across registered SQL Server and Oracle targets.

Operations Center Live status Server map
Action required
Lookback 24 h | 2026-11-09 12:42:29
Signals7886
Healthy5/5
Coverage100%
Optimized start view Fast view loads smaller result sets. Every dashboard card remains available in Personalize, including Blocking, health, audit, and TempDB.
Full analysis
Servers 5
Healthy 5
Unhealthy 0
Action signals 7886
Evidence coverage 100%
Estate postureAction required
5 healthy 0 unhealthy
Signal mix7886 active
Backup
10
Storage
0
Jobs
0
Runtime
7875
Concurrency
0
Long queries
1
Largest databases/tablespacestop 5
DOM_WhisperEcho_929E
1.3 GB
DOM_ShadowOcean_4486
1.3 GB
DOM_DreamBlossom_D66E
0.5 GB
tempdb
0.1 GB
dbNexia_db
0.1 GB
Growth pressure24h
TESTSRV_4.DBNEXIA.COM
47 MB
TESTSRV_3.DBNEXIA.COM
45 MB
TESTSRV_5.DBNEXIA.COM
36 MB
TESTSRV_2.DBNEXIA.COM
22 MB
TESTSRV_1.DBNEXIA.COM
13 MB
Security posture
Security information
Open Security Center

Add this card and reload to collect the permitted SQL Server security facts.

Data coverage 100% verified, 0 gaps across 0 servers. Empty panels are only marked clean when their source is available.
EventLog ok AuditLog ok DbSizes ok ServerMetrics ok MsdbBackup ok MsdbAgent ok LiveRequests ok VolumeStats ok TempDb ok
Priority queue
What needs attention first
Estate Overview Open Forecast
TESTSRV_2.DBNEXIA.COM | DOM_DreamStone_5722 backup risk FULL 43d ago, LOG 1022h ago | Recovery FULL Backup TESTSRV_2.DBNEXIA.COM | DOM_ForestEcho_B4A4 backup risk FULL 43d ago, LOG 1022h ago | Recovery FULL Backup TESTSRV_2.DBNEXIA.COM | DOM_ForestSky_5A7D backup risk FULL 43d ago, LOG 1022h ago | Recovery FULL Backup TESTSRV_2.DBNEXIA.COM | DOM_ShadowRiver_9AF6 backup risk FULL 43d ago, LOG 1022h ago | Recovery FULL Backup
Signal mix
Current workload posture
10 backup risks 0 storage risks 0 job failures 7875 errors/timeouts/logins 1 long running 0 deadlock/blocking
Top Growth (24h)
Job Failures

No job failures in the current lookback.

Latest Audit Events

No recent audit events found.

Largest Databases/Tablespaces
Low Storage Free Space

All storage targets healthy (>10% and >20 GB).

Backup Risks
  • FULL: 2026-09-27 02:00:00 | DIFF: - | LOG: 2026-09-27 22:00:01
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_DreamStone_5722' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_DreamStone_5722', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

  • FULL: 2026-09-27 02:00:07 | DIFF: - | LOG: 2026-09-27 22:00:02
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_ForestEcho_B4A4' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_ForestEcho_B4A4', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

  • FULL: 2026-09-27 02:00:13 | DIFF: - | LOG: 2026-09-27 22:00:03
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_ForestSky_5A7D' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_ForestSky_5A7D', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

  • FULL: 2026-09-27 02:00:03 | DIFF: - | LOG: 2026-09-27 22:00:01
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_ShadowRiver_9AF6' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_ShadowRiver_9AF6', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

  • FULL: 2026-09-27 02:00:16 | DIFF: - | LOG: 2026-09-27 22:00:03
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_WhisperEcho_929E' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_WhisperEcho_929E', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

  • FULL: 2026-09-27 02:00:11 | DIFF: - | LOG: 2026-09-27 22:00:03
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_CrystalStone_911A' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_CrystalStone_911A', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

  • FULL: 2026-09-27 02:00:06 | DIFF: - | LOG: 2026-09-27 22:00:02
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_FlameCrystal_07F4' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_FlameCrystal_07F4', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

  • FULL: 2026-09-27 02:00:23 | DIFF: - | LOG: 2026-09-27 22:00:04
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_MoonCrystal_16FD' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_MoonCrystal_16FD', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

  • FULL: 2026-09-27 02:00:14 | DIFF: - | LOG: 2026-09-27 22:00:03
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_ShadowMoon_946A' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_ShadowMoon_946A', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

  • FULL: 2026-09-27 02:00:19 | DIFF: - | LOG: 2026-09-27 22:00:03
    FULL 43d ago, LOG 1022h ago
    DBA assessment

    database 'DOM_ShadowOcean_4486' needs a newer log backup in the SQL backup chain.

    Recommended DBA action

    Inspect the latest log-backup job failure for database 'DOM_ShadowOcean_4486', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.

Blocking

No blocking reports in verified sources.

Temporary-Space Pressure

No data available.

Long Running Queries
  • TESTSRV_1.DBNEXIA.COM – dbNexia_db | 1m 40s | SPID 63
    CREATE FUNCTION dbo.NormalizeLogMessage(@msg NVARCHAR(MAX)) RETURNS NVARCHAR(MAX) AS BEGIN IF @msg IS NULL RETURN NULL; DECLARE @s NVARCHAR(MAX) = @msg;...
    DBA assessment

    This request in database 'dbNexia_db' has run for 101 seconds.

    Recommended DBA action

    Capture the actual execution plan, waits, row counts, parameter values and blocking state before changing it. Compare with its normal baseline. Correct the evidence-backed cause—cardinality estimates, access path, parameter sensitivity, batch size or contention—and test the change against representative parameters before deployment.

Server Health

No metrics found.

Error Pulse
  • TESTSRV_1.DBNEXIA.COM - Err 2701 | Timeouts 0 | Logins 0
    2026-11-08 21:31:52
    Cannot insert the value NULL into column 'BatchId', table 'DOM_ForestDream_BD6D.DBAChaos.RandomLoad_02'; column does not allow nulls. INSERT fails.
  • TESTSRV_3.DBNEXIA.COM - Err 2595 | Timeouts 0 | Logins 0
    2026-11-08 21:31:50
    Cannot insert the value NULL into column 'BatchId', table 'DOM_MoonCrystal_16FD.DBAChaos.RandomLoad_02'; column does not allow nulls. INSERT fails.
  • TESTSRV_2.DBNEXIA.COM - Err 2579 | Timeouts 0 | Logins 0
    2026-11-08 21:31:51
    Cannot insert the value NULL into column 'BatchId', table 'DOM_WhisperEcho_929E.DBAChaos.RandomLoad_03'; column does not allow nulls. INSERT fails.
Deadlocks

No deadlocks in verified sources.

Operational shortcuts

Operations Center Prioritized actions grouped by operational risk. Recovery readiness Backup freshness, recovery model and restore readiness. Database Health Run targeted database checks and one-click maintenance. Workload Lab Investigate slow queries, blocking and workload pressure.