dbNexia DEMO operations cockpit

Largest Databases

• TESTSRV_3.DBNEXIA.COM – dbNexia_db : 1,014.0 MB
• TESTSRV_1.DBNEXIA.COM – dbNexia_db : 941.0 MB
• TESTSRV_2.DBNEXIA.COM – dbNexia_db : 921.0 MB
• TESTSRV_4.DBNEXIA.COM – dbNexia_db : 427.0 MB
• TESTSRV_5.DBNEXIA.COM – dbNexia_db : 392.0 MB
• TESTSRV_1.DBNEXIA.COM – MAL_MAINT_DB_old : 111.0 MB
• TESTSRV_3.DBNEXIA.COM – DOM_CrystalStone_911A : 107.0 MB
• TESTSRV_2.DBNEXIA.COM – DOM_ShadowRiver_9AF6 : 101.0 MB
• TESTSRV_1.DBNEXIA.COM – DOM_DreamBlossom_D66E : 99.0 MB
• TESTSRV_1.DBNEXIA.COM – DOM_ThunderMoon_622B : 95.0 MB

Low Free Space

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

Backup Risks

No backup risks detected.

Blocking

• TESTSRV_4.DBNEXIA.COM - 2026-09-02 09:01:13 | 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_4.DBNEXIA.COM - 2026-09-02 08:01:05 | 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_2.DBNEXIA.COM - 2026-09-01 23:01:10 | 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_2.DBNEXIA.COM - 2026-09-01 11:01:11 | 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_3.DBNEXIA.COM
  DATA: 9.2 / 64.0 MB (14.4%)
  LOG  : 2.2 / 8.0 MB (26.9%)
• TESTSRV_5.DBNEXIA.COM
  DATA: 7.4 / 64.0 MB (11.5%)
  LOG  : 1.8 / 8.0 MB (22.0%)
• TESTSRV_4.DBNEXIA.COM
  DATA: 8.9 / 64.0 MB (13.9%)
  LOG  : 1.4 / 8.0 MB (17.3%)
• TESTSRV_1.DBNEXIA.COM
  DATA: 7.1 / 64.0 MB (11.0%)
  LOG  : 1.1 / 8.0 MB (14.1%)
• TESTSRV_2.DBNEXIA.COM
  DATA: 7.9 / 64.0 MB (12.3%)
  LOG  : 0.8 / 8.0 MB (9.5%)

Long Running Queries

• TESTSRV_1.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.

• TESTSRV_4.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.

• 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.