Loaded 2026-08-12 11:58:53
Back to Overview
Server dashboard

SERVER 4

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

Action required
Lookback 24 h | 2026-08-12 11:58:53
CPU 2.0% latest sample
Memory free 64.0% 1 sessions
Action signals 7 2 backup | 0 disk | 0 jobs
Workload events 129 123 errors | 1 long running
Health gaugesAction required
2%
CPU
64%
Memory free
Signal mix131 signals
Backup
2
Disk
0
Jobs
0
Runtime
123
Concurrency
5
Long queries
1
Capacity profilegrowth and size
dbNexia_db
6 MB
dbNexia_db
0.5 GB
tempdb
0.0 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
DBAChaos backup risk FULL missing | Recovery SIMPLE Backup dbNexia_db backup risk FULL missing | Recovery SIMPLE Backup
Signal mix
Current workload posture
2 backup risks 0 disk risks 0 job failures 123 errors/timeouts/logins 1 long running 5 deadlock/blocking
Top Growth (24h)
  • dbNexia_db (Log ):6.0 MB
Health
  • CPU 2.0% Mem free 64.0% 1 sessions 10 trans
Error Pulse
  • Open event - Err 64 Timeouts 59 Logins 0
    2026-08-12 11:02:21 - The request failed to run because the batch is aborted, this can be caused by abort signal sent from client, or another request is running i...
    Meaning

    Clients or jobs waited longer than their command timeout.

    Next step

    Open the same time window in Long Running and Blocking. If there is no blocker, tune the slow statement or reduce the batch/report size before increasing timeout settings.

TempDB
  • DATA: 5.9 / 64.0 MB (9.3%)
    LOG  : 2.2 / 8.0 MB (27.6%)
Largest Databases
  • dbNexia_db : 527.0 MB
  • tempdb : 12.0 MB
  • DBAChaos : 11.0 MB
Latest Audit Events
Low Free Space

All drives healthy.

SQL Agent Failures

No job failures.

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

Deadlocks
  • 2026-08-12 02:00:08 | master | SPID 42
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-12T02:00:08.702Z"><data name="xml_report"><valu...
    Meaning

    A deadlock occurred in database 'master'; SQL Server selected session 42 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-12 02:00:08 | system_health file
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-12T02:00:08.702Z"><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-11 22:00:09 | master | SPID 44
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-11T22:00:09.599Z"><data name="xml_report"><valu...
    Meaning

    A deadlock occurred in database 'master'; SQL Server selected session 44 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-11 22:00:09 | system_health file
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-11T22:00:09.599Z"><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-11 17:00:07 | master | SPID 4
    <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-08-11T17:00:07.066Z"><data name="xml_report"><valu...
    Meaning

    A deadlock occurred in database 'master'; SQL Server selected session 4 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

No blocking reports.