Loaded 2026-08-07 06:00:14
Back to Overview
Server dashboard

SERVER 3

Focused health, workload, backup, capacity, and reliability signals for this SQL Server instance.

Action required
Lookback 24 h | 2026-08-07 06:00:14
CPU 1.0% latest sample
Memory free 63.3% 2 sessions
Action signals 17 7 backup | 0 disk | 0 jobs
Workload events 3070 3060 errors | 0 long running
Health gaugesAction required
1%
CPU
63%
Memory free
Signal mix3077 signals
Backup
7
Disk
0
Jobs
0
Runtime
3060
Concurrency
10
Long queries
0
Capacity profilegrowth and size
tempdb
8 MB
dbNexia_db
1.0 GB
DOM_CrystalStone_911A
0.1 GB
Data coverage This page separates verified clean states from missing source data.
EventLog ok AuditLog ok DbSizes ok ServerMetrics ok MsdbBackup ok MsdbAgent ok LiveRequests ok VolumeStats ok TempDb ok
Priority queue
What needs attention on this server
DOM_CrystalStone_911A backup risk FULL missing, LOG missing | Recovery FULL Backup DOM_FlameCrystal_07F4 backup risk FULL missing, LOG missing | Recovery FULL Backup DOM_MoonCrystal_16FD backup risk FULL missing, LOG missing | Recovery FULL Backup DOM_ShadowMoon_946A backup risk FULL missing, LOG missing | Recovery FULL Backup
Signal mix
Current workload posture
7 backup risks 0 disk risks 0 job failures 3060 errors/timeouts/logins 0 long running 10 deadlock/blocking
Top Growth (24h)
  • tempdb (Data ):8.0 MB
Health
  • CPU 1.0% Mem free 63.3% 2 sessions 11 trans
Error Pulse
  • Open event - Err 2721 Timeouts 235 Logins 104 Grants 104
    2026-08-07 05:29:38 - (@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ...
    Meaning

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

    Next step

    Run or repair the log-backup job for database 'Login failures'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.

TempDB
  • DATA: 9.2 / 576.0 MB (1.6%)
    LOG  : 0.5 / 8.0 MB (6.6%)
    Version store: 0.2 MB
Largest Databases
  • dbNexia_db : 996.0 MB
  • DOM_CrystalStone_911A : 83.0 MB
  • MAL_MAINT_DB_old : 66.0 MB
  • DOM_ShadowMoon_946A : 52.0 MB
  • DOM_ShadowOcean_4486 : 36.0 MB
  • DOM_MoonCrystal_16FD : 32.0 MB
  • DOM_FlameCrystal_07F4 : 30.0 MB
  • tempdb : 14.0 MB
  • DBAChaos : 9.0 MB
Latest Audit Events
Low Free Space

All drives healthy.

SQL Agent Failures

No job failures.

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

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

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

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

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

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

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

Long Running

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

Deadlocks
  • 2026-08-07 04:00:08 | system_health file
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-07T04:00:08.027Z"><data name="xml_report"><valu...
    Meaning

    A deadlock occurred in the database in the event; SQL Server selected the session shown in the event or a related session as victim.

    Recommended fix

    Use the event text to identify the two statements and objects. Add the missing index or make both code paths update/read objects in a consistent order.

  • 2026-08-07 04:00:08 | master | SPID 68
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-07T04:00:08.027Z"><data name="xml_report"><valu...
    Meaning

    A deadlock occurred in database 'master'; SQL Server selected session 68 or a related session as victim.

    Recommended fix

    Use the event text to identify the two statements and objects. Add the missing index or make both code paths update/read objects in a consistent order.

  • 2026-08-07 03:00:07 | system_health file
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-07T03:00:07.778Z"><data name="xml_report"><valu...
    Meaning

    A deadlock occurred in the database in the event; SQL Server selected the session shown in the event or a related session as victim.

    Recommended fix

    Use the event text to identify the two statements and objects. Add the missing index or make both code paths update/read objects in a consistent order.

  • 2026-08-07 03:00:07 | master | SPID 41
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-07T03:00:07.778Z"><data name="xml_report"><valu...
    Meaning

    A deadlock occurred in database 'master'; SQL Server selected session 41 or a related session as victim.

    Recommended fix

    Use the event text to identify the two statements and objects. Add the missing index or make both code paths update/read objects in a consistent order.

  • 2026-08-06 23:00:08 | system_health file
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-06T23:00:08.590Z"><data name="xml_report"><valu...
    Meaning

    A deadlock occurred in the database in the event; SQL Server selected the session shown in the event or a related session as victim.

    Recommended fix

    Use the event text to identify the two statements and objects. Add the missing index or make both code paths update/read objects in a consistent order.

Blocking
  • 2026-08-07 06:00:14 | DBAChaos | WIN-PN3T1M2LOOO | SPID 66
    SPID 66 blocked by 67. Wait LCK_M_X 10308 ms. CREATE PROCEDURE dbo.usp_Chaos_BlockedSession AS BEGIN SET NOCOUNT ...
    Meaning

    session 66 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.

  • 2026-08-07 05:01:18 | 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.

  • 2026-08-06 22:01:17 | 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.

  • 2026-08-06 14:01:16 | 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.

  • 2026-08-06 13: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.