dbNexia Demo operations cockpit

Largest Databases

• TESTSRV_3.DBNEXIA.COM – dbNexia_db : 1,007.0 MB
• TESTSRV_2.DBNEXIA.COM – dbNexia_db : 921.0 MB
• TESTSRV_1.DBNEXIA.COM – dbNexia_db : 879.0 MB
• TESTSRV_4.DBNEXIA.COM – dbNexia_db : 536.0 MB
• TESTSRV_5.DBNEXIA.COM – dbNexia_db : 508.0 MB
• TESTSRV_1.DBNEXIA.COM – MAL_MAINT_DB_old : 111.0 MB
• TESTSRV_1.DBNEXIA.COM – DOM_DreamBlossom_D66E : 95.0 MB
• TESTSRV_2.DBNEXIA.COM – DOM_ShadowRiver_9AF6 : 90.0 MB
• TESTSRV_1.DBNEXIA.COM – DOM_ShadowWhisper_67B1 : 88.0 MB
• TESTSRV_1.DBNEXIA.COM – DOM_ThunderMoon_622B : 82.0 MB

Low Free Space

All drives healthy (>10% and >20 GB).

Backup Risks

• TESTSRV_1.DBNEXIA.COM - DOM_BlossomWhisper_FDD3 (FULL)
  FULL: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  Meaning

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

  Recommended fix

  Run or repair the log-backup job for database 'DOM_BlossomWhisper_FDD3'. 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_1.DBNEXIA.COM - DOM_DreamBlossom_D66E (FULL)
  FULL: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  Meaning

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

  Recommended fix

  Run or repair the log-backup job for database 'DOM_DreamBlossom_D66E'. 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_1.DBNEXIA.COM - DOM_ForestDream_BD6D (FULL)
  FULL: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  Meaning

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

  Recommended fix

  Run or repair the log-backup job for database 'DOM_ForestDream_BD6D'. 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_1.DBNEXIA.COM - DOM_ShadowWhisper_67B1 (FULL)
  FULL: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  Meaning

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

  Recommended fix

  Run or repair the log-backup job for database 'DOM_ShadowWhisper_67B1'. 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_1.DBNEXIA.COM - DOM_ThunderMoon_622B (FULL)
  FULL: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  Meaning

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

  Recommended fix

  Run or repair the log-backup job for database 'DOM_ThunderMoon_622B'. 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_DreamStone_5722 (FULL)
  FULL: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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: - | DIFF: - | LOG: -
  FULL missing, LOG missing
  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_1.DBNEXIA.COM - DBAChaos (SIMPLE)
  FULL: - | DIFF: - | LOG: -
  FULL missing
  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_1.DBNEXIA.COM - dbNexia_db (SIMPLE)
  FULL: - | DIFF: - | LOG: -
  FULL missing
  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_2.DBNEXIA.COM - DBAChaos (SIMPLE)
  FULL: - | DIFF: - | LOG: -
  FULL missing
  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: - | DIFF: - | LOG: -
  FULL missing
  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: - | DIFF: - | LOG: -
  FULL missing
  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: - | DIFF: - | LOG: -
  FULL missing
  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_4.DBNEXIA.COM - DBAChaos (SIMPLE)
  FULL: - | DIFF: - | LOG: -
  FULL missing
  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_4.DBNEXIA.COM - dbNexia_db (SIMPLE)
  FULL: - | DIFF: - | LOG: -
  FULL missing
  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: - | DIFF: - | LOG: -
  FULL missing
  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: - | DIFF: - | LOG: -
  FULL missing
  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

• TESTSRV_3.DBNEXIA.COM - 2026-08-12 23:01:12 | DBAChaos | WIN-PN3T1M2LOOO | SPID 20
  EXEC dbo.usp_Chaos_BlockedSession;
  Meaning

  session 20 was involved in blocking on database 'DBAChaos'.

  Recommended fix

  Resolve the blocking transaction first. If the same statement repeats, add the index that lets it find rows faster or reduce the transaction scope around it.

• TESTSRV_2.DBNEXIA.COM - 2026-08-12 16:01:07 | DBAChaos | WIN-PN3T1M2LOOO | SPID 19
  EXEC dbo.usp_Chaos_BlockedSession;
  Meaning

  session 19 was involved in blocking on database 'DBAChaos'.

  Recommended fix

  Resolve the blocking transaction first. If the same statement repeats, add the index that lets it find rows faster or reduce the transaction scope around it.

• TESTSRV_5.DBNEXIA.COM - 2026-08-12 14:01:14 | DBAChaos | WIN-PN3T1M2LOOO | SPID 19
  EXEC dbo.usp_Chaos_BlockedSession;
  Meaning

  session 19 was involved in blocking on database 'DBAChaos'.

  Recommended fix

  Resolve the blocking transaction first. If the same statement repeats, add the index that lets it find rows faster or reduce the transaction scope around it.

TempDB Pressure

• TESTSRV_2.DBNEXIA.COM
  DATA: 9.8 / 64.0 MB (15.2%)
  LOG  : 2.2 / 8.0 MB (27.2%)
• TESTSRV_1.DBNEXIA.COM
  DATA: 9.8 / 64.0 MB (15.3%)
  LOG  : 1.0 / 8.0 MB (12.9%)
• TESTSRV_4.DBNEXIA.COM
  DATA: 8.6 / 64.0 MB (13.5%)
  LOG  : 0.8 / 8.0 MB (9.5%)
• TESTSRV_5.DBNEXIA.COM
  DATA: 8.2 / 64.0 MB (12.9%)
  LOG  : 0.8 / 8.0 MB (9.6%)
• TESTSRV_3.DBNEXIA.COM
  DATA: 6.8 / 64.0 MB (10.5%)
  LOG  : 0.5 / 8.0 MB (6.9%)

Long Running Queries

• TESTSRV_1.DBNEXIA.COM – DBAChaos | 1m 12s | completed cached query
  UPDATE dbo.ChaosLock SET Payload = Payload + 1, ModifiedUtc = SYSUTCDATETIME() WHERE LockId = 3
  Meaning

  This request in database 'DBAChaos' has run for 72 seconds.

  Recommended fix

  Use the SQL text shown in this row as the target. Add or adjust the index that supports its WHERE/JOIN/ORDER BY columns, update stale statistics, or break the operation into smaller batches.

• TESTSRV_2.DBNEXIA.COM – DBAChaos | 1m 12s | completed cached query
  UPDATE dbo.ChaosLock SET Payload = Payload + 1, ModifiedUtc = SYSUTCDATETIME() WHERE LockId = 3
  Meaning

  This request in database 'DBAChaos' has run for 72 seconds.

  Recommended fix

  Use the SQL text shown in this row as the target. Add or adjust the index that supports its WHERE/JOIN/ORDER BY columns, update stale statistics, or break the operation into smaller batches.

• TESTSRV_4.DBNEXIA.COM – DBAChaos | 1m 12s | completed cached query
  UPDATE dbo.ChaosLock SET Payload = Payload + 1, ModifiedUtc = SYSUTCDATETIME() WHERE LockId = 3
  Meaning

  This request in database 'DBAChaos' has run for 72 seconds.

  Recommended fix

  Use the SQL text shown in this row as the target. Add or adjust the index that supports its WHERE/JOIN/ORDER BY columns, update stale statistics, or break the operation into smaller batches.

• TESTSRV_5.DBNEXIA.COM – DBAChaos | 1m 11s | completed cached query
  UPDATE dbo.ChaosLock SET Payload = Payload + 1, ModifiedUtc = SYSUTCDATETIME() WHERE LockId = 3
  Meaning

  This request in database 'DBAChaos' has run for 71 seconds.

  Recommended fix

  Use the SQL text shown in this row as the target. Add or adjust the index that supports its WHERE/JOIN/ORDER BY columns, update stale statistics, or break the operation into smaller batches.