Operations overview

dbNexia DEMO operations cockpit

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

Action required

Lookback 24 h | 2026-10-14 13:17:07

Lookback Auto-refresh Long running >= (s) Backup FULL > (d) Backup LOG > (h) Drive <= % Drive <= GB

Servers 5

Healthy 5

Unhealthy 0

Action signals 8256

Evidence coverage 100%

Estate postureAction required

5 healthy 0 unhealthy

Signal mix8256 active

Backup

Disk

Jobs

Runtime

8228

Concurrency

Long queries

Largest databasestop 5

DOM_WhisperEcho_929E

0.5 GB

DOM_ShadowOcean_4486

0.5 GB

DOM_ShadowMoon_946A

0.4 GB

DOM_ShadowRiver_9AF6

0.4 GB

DOM_ForestSky_5A7D

0.4 GB

Growth pressure24h

TESTSRV_1.DBNEXIA.COM

20 MB

TESTSRV_3.DBNEXIA.COM

18 MB

TESTSRV_2.DBNEXIA.COM

16 MB

TESTSRV_4.DBNEXIA.COM

10 MB

TESTSRV_5.DBNEXIA.COM

10 MB

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

Server Overview Open Forecast

Signal mix

Current workload posture

16 backup risks 8 disk risks 0 job failures 8228 errors/timeouts/logins 0 long running 4 deadlock/blocking

Top Growth (24h)

TESTSRV_1.DBNEXIA.COM - tempdb (Log ) : 20.0 MB
TESTSRV_3.DBNEXIA.COM - dbNexia_db (Log ) : 18.0 MB
TESTSRV_2.DBNEXIA.COM - dbNexia_db (Log ) : 16.0 MB
TESTSRV_4.DBNEXIA.COM - dbNexia_db (Log ) : 10.0 MB
TESTSRV_5.DBNEXIA.COM - dbNexia_db (Log ) : 10.0 MB

SQL Agent Failures

No job failures in the current lookback.

Latest Audit Events

No recent audit events found.

Largest Databases

TESTSRV_2.DBNEXIA.COM – DOM_WhisperEcho_929E : 510.0 MB
TESTSRV_3.DBNEXIA.COM – DOM_ShadowOcean_4486 : 469.0 MB
TESTSRV_3.DBNEXIA.COM – DOM_ShadowMoon_946A : 460.0 MB
TESTSRV_2.DBNEXIA.COM – DOM_ShadowRiver_9AF6 : 451.0 MB
TESTSRV_2.DBNEXIA.COM – DOM_ForestSky_5A7D : 449.0 MB
TESTSRV_2.DBNEXIA.COM – DOM_ForestEcho_B4A4 : 447.0 MB
TESTSRV_2.DBNEXIA.COM – DOM_DreamStone_5722 : 441.0 MB
TESTSRV_3.DBNEXIA.COM – DOM_FlameCrystal_07F4 : 440.0 MB
TESTSRV_3.DBNEXIA.COM – DOM_CrystalStone_911A : 434.0 MB
TESTSRV_3.DBNEXIA.COM – DOM_MoonCrystal_16FD : 423.0 MB

Low Free Space

TESTSRV_4.DBNEXIA.COM – ANNAT 1 | 13.4 GB free (33.5%)
TESTSRV_1.DBNEXIA.COM – ANNAT 1 | 13.4 GB free (33.5%)
TESTSRV_5.DBNEXIA.COM – ANNAT 1 | 13.4 GB free (33.5%)
TESTSRV_3.DBNEXIA.COM – ANNAT 1 | 13.4 GB free (33.5%)
TESTSRV_2.DBNEXIA.COM – ANNAT 1 | 13.4 GB free (33.5%)
TESTSRV_4.DBNEXIA.COM – ANNAT 1 | 13.4 GB free (33.5%)
TESTSRV_1.DBNEXIA.COM – ANNAT 1 | 13.4 GB free (33.5%)
TESTSRV_2.DBNEXIA.COM – ANNAT 1 | 13.4 GB free (33.5%)

Backup Risks

TESTSRV_2.DBNEXIA.COM - DOM_DreamStone_5722 (FULL)

FULL: 2026-09-27 02:00:00 | DIFF: - | LOG: 2026-09-27 22:00:01

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_DreamStone_5722'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_2.DBNEXIA.COM - DOM_ForestEcho_B4A4 (FULL)

FULL: 2026-09-27 02:00:07 | DIFF: - | LOG: 2026-09-27 22:00:02

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_ForestEcho_B4A4'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_2.DBNEXIA.COM - DOM_ForestSky_5A7D (FULL)

FULL: 2026-09-27 02:00:13 | DIFF: - | LOG: 2026-09-27 22:00:03

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_ForestSky_5A7D'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_2.DBNEXIA.COM - DOM_ShadowRiver_9AF6 (FULL)

FULL: 2026-09-27 02:00:03 | DIFF: - | LOG: 2026-09-27 22:00:01

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_ShadowRiver_9AF6'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_2.DBNEXIA.COM - DOM_WhisperEcho_929E (FULL)

FULL: 2026-09-27 02:00:16 | DIFF: - | LOG: 2026-09-27 22:00:03

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_WhisperEcho_929E'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_3.DBNEXIA.COM - DOM_CrystalStone_911A (FULL)

FULL: 2026-09-27 02:00:11 | DIFF: - | LOG: 2026-09-27 22:00:03

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_CrystalStone_911A'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_3.DBNEXIA.COM - DOM_FlameCrystal_07F4 (FULL)

FULL: 2026-09-27 02:00:06 | DIFF: - | LOG: 2026-09-27 22:00:02

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_FlameCrystal_07F4'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_3.DBNEXIA.COM - DOM_MoonCrystal_16FD (FULL)

FULL: 2026-09-27 02:00:23 | DIFF: - | LOG: 2026-09-27 22:00:04

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_MoonCrystal_16FD'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_3.DBNEXIA.COM - DOM_ShadowMoon_946A (FULL)

FULL: 2026-09-27 02:00:14 | DIFF: - | LOG: 2026-09-27 22:00:03

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_ShadowMoon_946A'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_3.DBNEXIA.COM - DOM_ShadowOcean_4486 (FULL)

FULL: 2026-09-27 02:00:19 | DIFF: - | LOG: 2026-09-27 22:00:03

FULL 17d ago, LOG 399h ago

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

Recommended fix
Run or repair the log-backup job for database 'DOM_ShadowOcean_4486'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.
TESTSRV_2.DBNEXIA.COM - DBAChaos (SIMPLE)

FULL: 2026-09-27 02:00:00 | DIFF: - | LOG: -

FULL 17d ago

Meaning
database 'DBAChaos' is outside backup freshness policy.

Recommended fix
Run or repair the full-backup job for database 'DBAChaos'. Verify target path, SQL Server service-account permissions, retention cleanup and free space before rerun.
TESTSRV_2.DBNEXIA.COM - dbNexia_db (SIMPLE)

FULL: 2026-09-27 02:00:22 | DIFF: - | LOG: -

FULL 17d ago

Meaning
database 'dbNexia_db' is outside backup freshness policy.

Recommended fix
Run or repair the full-backup job for database 'dbNexia_db'. Verify target path, SQL Server service-account permissions, retention cleanup and free space before rerun.
TESTSRV_3.DBNEXIA.COM - DBAChaos (SIMPLE)

FULL: 2026-09-27 02:00:03 | DIFF: - | LOG: -

FULL 17d ago

Meaning
database 'DBAChaos' is outside backup freshness policy.

Recommended fix
Run or repair the full-backup job for database 'DBAChaos'. Verify target path, SQL Server service-account permissions, retention cleanup and free space before rerun.
TESTSRV_3.DBNEXIA.COM - dbNexia_db (SIMPLE)

FULL: 2026-09-27 02:00:28 | DIFF: - | LOG: -

FULL 17d ago

Meaning
database 'dbNexia_db' is outside backup freshness policy.

Recommended fix
Run or repair the full-backup job for database 'dbNexia_db'. Verify target path, SQL Server service-account permissions, retention cleanup and free space before rerun.
TESTSRV_5.DBNEXIA.COM - DBAChaos (SIMPLE)

FULL: 2026-09-27 02:00:04 | DIFF: - | LOG: -

FULL 17d ago

Meaning
database 'DBAChaos' is outside backup freshness policy.

Recommended fix
Run or repair the full-backup job for database 'DBAChaos'. Verify target path, SQL Server service-account permissions, retention cleanup and free space before rerun.
TESTSRV_5.DBNEXIA.COM - dbNexia_db (SIMPLE)

FULL: 2026-09-27 02:00:01 | DIFF: - | LOG: -

FULL 17d ago

Meaning
database 'dbNexia_db' is outside backup freshness policy.

Recommended fix
Run or repair the full-backup job for database 'dbNexia_db'. Verify target path, SQL Server service-account permissions, retention cleanup and free space before rerun.

Blocking

No blocking reports.

TempDB Pressure

TESTSRV_4.DBNEXIA.COM
DATA: 14.3 / 64.0 MB (22.4%)

LOG : 2.0 / 8.0 MB (25.4%)
TESTSRV_5.DBNEXIA.COM
DATA: 11.2 / 64.0 MB (17.6%)

LOG : 1.2 / 8.0 MB (15.2%)
TESTSRV_2.DBNEXIA.COM
DATA: 7.6 / 576.0 MB (1.3%)

LOG : 6.8 / 136.0 MB (5.0%)
TESTSRV_3.DBNEXIA.COM
DATA: 8.7 / 576.0 MB (1.5%)

LOG : 1.2 / 136.0 MB (0.9%)
TESTSRV_1.DBNEXIA.COM
DATA: 6.5 / 576.0 MB (1.1%)

LOG : 0.9 / 136.0 MB (0.7%)

Long Running Queries

No active or recently completed slow queries longer than 60 seconds.

Server Health

TESTSRV_4.DBNEXIA.COM - 17.0% CPU | 33.4% mem free | 1 sessions / 7 trans
TESTSRV_5.DBNEXIA.COM - 17.0% CPU | 33.4% mem free | 2 sessions / 11 trans
TESTSRV_3.DBNEXIA.COM - 17.0% CPU | 33.4% mem free | 1 sessions / 7 trans
TESTSRV_1.DBNEXIA.COM - 16.0% CPU | 33.4% mem free | 1 sessions / 7 trans
TESTSRV_2.DBNEXIA.COM - 16.0% CPU | 33.4% mem free | 2 sessions / 8 trans

Error Pulse

TESTSRV_1.DBNEXIA.COM - Err 2705 | Timeouts 41 | Logins 1 | CPU 0 | Grants 1
2026-10-14 12:58:36
(@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLARE @LogNumb...
TESTSRV_2.DBNEXIA.COM - Err 2624 | Timeouts 44 | Logins 0
2026-10-14 12:58:36
(@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLARE @LogNumb...
TESTSRV_3.DBNEXIA.COM - Err 2613 | Timeouts 37 | Logins 0
2026-10-14 12:58:37
(@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLARE @LogNumb...
TESTSRV_4.DBNEXIA.COM - Err 42 | Timeouts 41 | Logins 0
2026-10-14 12:58:36
(@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLARE @LogNumb...
TESTSRV_5.DBNEXIA.COM - Err 40 | Timeouts 40 | Logins 0
2026-10-14 12:58:37
(@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLARE @LogNumb...

Deadlocks

WIN-PN3T1M2LOOO - 2026-10-14 11:55:23 | master | SPID 48
<event name="xml_deadlock_report" package="sqlserver" timestamp="2026-10-14T11:55:23.505Z"><data name="xml_report"><valu...
WIN-PN3T1M2LOOO - 2026-10-13 17:40:19 | master | SPID 4
<event name="xml_deadlock_report" package="sqlserver" timestamp="2026-10-13T17:40:19.837Z"><data name="xml_report"><valu...
WIN-PN3T1M2LOOO - 2026-10-13 15:55:04 | master | SPID 46
<event name="xml_deadlock_report" package="sqlserver" timestamp="2026-10-13T15:55:04.049Z"><data name="xml_report"><valu...
WIN-PN3T1M2LOOO - 2026-10-13 15:35:17 | master | SPID 41
<event name="xml_deadlock_report" package="sqlserver" timestamp="2026-10-13T15:35:17.311Z"><data name="xml_report"><valu...