Server Overview

Server operations cockpit

Pick a server and read the current story: what happened, what is happening, what happens next, and exactly what to do first.

Critical 2026-09-02 11:03
Critical5
Action0
Watch0
Stable0
Open actions53
Runtime events10060
Telemetry gaps0
Growth0.0 GB
Operational impact 6 / 100 High exposure ยท evidence coverage 100%
Recovery readiness Backup chains, restore confidence and failed maintenance are folded into each server's actions.
0
Capacity protection Low disk, database growth and projected pressure are visible before they become write failures.
0
Service reliability Failed jobs, runtime events, deadlocks, blocking and long-running queries are treated as connected reliability evidence.
10113
Data confidence Telemetry gaps are counted as risk so empty panels are not mistaken for healthy systems.
0
Action Center Backup Readiness Data Quality
Critical

SERVER 3

TESTSRV_3.DBNEXIA.COM / Test / SQL Server / Last seen 2026-09-02 11:00
Health0
Pressure100
TrendDeteriorating
DirectionRising risk
Best advice

P1 Workload: Trace blockers/deadlocks to statement, index, and transaction order. This is first because concurrency incidents usually repeat under the same application path until the blocking pattern is removed. Pattern: Repeated blocking or deadlocks indicate a transaction, query, or indexing pattern.

Dashboard Report
What happened

In the selected window, 3185 log/runtime events were recorded, latest at 2026-09-02 10:14; 10 deadlocks and 0 blocking events appeared; databases grew by 0.0 GB in the selected window.

What is happening

Right now, the error/log stream is active; sessions are waiting on blockers or deadlock-prone paths.

What happens next

Blocking and deadlock pressure is likely to repeat under the same workload until the blocking pattern is removed. Pressure indicators: 3,185 projected runtime events in 24 hours, 10 action signals, 1 watch signals. The likely outcome is operational impact or missed recovery objectives unless the first action is handled immediately.

Actions to break the trend 2
P1
Workload

Trace blockers/deadlocks to statement, index, and transaction order.

Concurrency incidents usually repeat under the same application path until the blocking pattern is removed.
P1
Logs

Group latest log errors by message and correlate with jobs, releases, and login sources.

The page sees a repeated symptom; grouping tells whether this is one noisy source or a wider server problem.
Trend and signal mix Rising risk
0 Backups
0 Disk
0 Jobs
3185 Logs
10 Locks
0 Queries
0 Gaps
3185 log/runtime 10 blocking
Concrete findings 11
Logs 2,779 Errors

2026-09-02 10:14 - (@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...

Logs 206 Timeouts

2026-09-02 10:14 - (@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...

Logs 100 Login failures

2026-09-02 10:14 - (@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...

Logs 100 Memory grants

2026-09-02 10:14 - (@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...

Deadlocks database unknown

2026-09-02 11:00 - <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-09-02T11:00:11.896Z"><data name="xml_report"><type name="xml" package="package0"...

Deadlocks database unknown

2026-09-02 11:00 - <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-09-02T11:00:11.896Z"><data name="xml_report"><value><deadlock><victim-list><vict...

Growth dbNexia_db

0.0 GB growth (Log ).

Largest DB dbNexia_db

1.0 GB current size.

Largest DB DOM_CrystalStone_911A

0.1 GB current size.

Resources CPU and memory

CPU 1.0%, memory free 54.8%, users 3, transactions 9.

TempDB Data and log

Data 1.5%, log 19.7%, version store 0 MB.

Metrics and evidence Signals

Last OK 2026-09-02 11:00, last failed -. 3185 runtime events. 10 deadlocks / 0 blocking. 0.0 GB growth. CPU 1.0%, memory free 54.8%.

Recommended action Identify blockers, statements, and transaction order; prioritize indexing or code changes.
Pattern Repeated blocking or deadlocks indicate a transaction, query, or indexing pattern.
Forecast Blocking and deadlock pressure is likely to repeat under the same workload until the blocking pattern is removed.
Break the trend remove blocker/deadlock source; triage latest log errors.
CPU / memory free 1.0% / 54.8%
TempDB data / log 1.5% / 19.7%
Growth now / 7d forecast 0.0 GB / 0.0 GB
Runtime / 24h forecast 3185 / 3185
Backups / disks / jobs 0 / 0 / 0
Blocking / long queries 10 / 0
Telemetry gaps 0
Largest database 1.0 GB
Operating profile Test
Type SQL Server
Environment Test
Repository size 1.45 GB
Last OK 2026-09-02 11:00
Last failed -
Data quality 100%
Source confidence 0 gaps
AuditLog Available

dbNexia_db.dbo.AuditLog

DbSizes Available

dbNexia_db.dbo.dbsizes

EventLog Available

dbNexia_db.dbo.EventLog

LiveRequests Available

VIEW SERVER STATE permission

MsdbAgent Available

msdb SQL Agent history

MsdbBackup Available

msdb.dbo.backupset

ServerMetrics Available

dbNexia_db.dbo.ServerMetrics

TempDb Available

VIEW SERVER STATE permission

VolumeStats Available

VIEW SERVER STATE permission

Runtime 3185 events

Errors 2,779, timeouts 206, login failures 100, CPU warnings 0, memory grants 100.

(@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...

Meaning

database 'Errors 2,779, timeouts 206, login failures 100, CPU warnings 0, memory grants 100.' needs a newer log backup in the SQL backup chain.

Recommended fix

Run or repair the log-backup job for database 'Errors 2,779, timeouts 206, login failures 100, CPU warnings 0, memory grants 100.'. If the log still cannot truncate, fix the specific blocker: open transaction, replication/AG send queue, backup target failure, or full-backup chain reset.

Verify

Open Backup History for the database and confirm a newer successful backup row of the missing type appears after the fix.

Backup risks0
BackupsNo risks

No backup risks detected for this server.

Storage0 low volumes
StorageNo low volumes

No low free-space volumes detected for this server.

Growth0.0 GB
dbNexia_db5.0 MB

Log growth inside the selected 24h window.

Meaning and fix

Meaning: This signal is abnormal, but the row text is not specific enough to name a single root cause with confidence.

Fix: Use the row values already shown here to filter the related report by the same server, database/job/login and the same time window.

Verify: The signal should stop repeating in the next collection window after the underlying job, permission, backup, or workload issue is fixed.

Queries and concurrency10 signals
Deadlock2026-09-02 11:00

database unknown; <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-09-02T11:00:11.896Z"><data name="xml_report"><type name="xml" package="package0"...

Meaning and fix

Meaning: SQL Server detected two sessions holding resources in conflicting order and chose one session as the deadlock victim.

Fix: Use the deadlock event details to identify the two statements and objects. Add the missing supporting index or change the transaction order so both code paths touch objects in the same order.

Verify: After the change, the same database/object pair should stop producing deadlock events in the selected lookback window.

Deadlock2026-09-02 11:00

database unknown; <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-09-02T11:00:11.896Z"><data name="xml_report"><value><deadlock><victim-list><vict...

Meaning and fix

Meaning: SQL Server detected two sessions holding resources in conflicting order and chose one session as the deadlock victim.

Fix: Use the deadlock event details to identify the two statements and objects. Add the missing supporting index or change the transaction order so both code paths touch objects in the same order.

Verify: After the change, the same database/object pair should stop producing deadlock events in the selected lookback window.

Deadlock2026-09-02 08:00

database unknown; <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-09-02T08:00:10.207Z"><data name="xml_report"><type name="xml" package="package0"...

Meaning and fix

Meaning: SQL Server detected two sessions holding resources in conflicting order and chose one session as the deadlock victim.

Fix: Use the deadlock event details to identify the two statements and objects. Add the missing supporting index or change the transaction order so both code paths touch objects in the same order.

Verify: After the change, the same database/object pair should stop producing deadlock events in the selected lookback window.

Deadlock2026-09-02 08:00

database unknown; <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-09-02T08:00:10.207Z"><data name="xml_report"><value><deadlock><victim-list><vict...

Meaning and fix

Meaning: SQL Server detected two sessions holding resources in conflicting order and chose one session as the deadlock victim.

Fix: Use the deadlock event details to identify the two statements and objects. Add the missing supporting index or change the transaction order so both code paths touch objects in the same order.

Verify: After the change, the same database/object pair should stop producing deadlock events in the selected lookback window.

Deadlock2026-09-02 08:00

master; <event name="xml_deadlock_report" package="sqlserver" timestamp="2026-09-02T08:00:10.207Z"><data name="xml_report"><value><deadlock><victim-list><vict...

Meaning and fix

Meaning: SQL Server detected two sessions holding resources in conflicting order and chose one session as the deadlock victim.

Fix: Use the deadlock event details to identify the two statements and objects. Add the missing supporting index or change the transaction order so both code paths touch objects in the same order.

Verify: After the change, the same database/object pair should stop producing deadlock events in the selected lookback window.

Largest databases and job failures0 job failures
dbNexia_db1.0 GB

Current largest database inventory sample.

DOM_CrystalStone_911A0.1 GB

Current largest database inventory sample.

DOM_ShadowMoon_946A0.1 GB

Current largest database inventory sample.

MAL_MAINT_DB_old0.1 GB

Current largest database inventory sample.

DOM_ShadowOcean_44860.1 GB

Current largest database inventory sample.

DOM_FlameCrystal_07F40.0 GB

Current largest database inventory sample.

DOM_MoonCrystal_16FD0.0 GB

Current largest database inventory sample.

DBAChaos0.0 GB

Current largest database inventory sample.

tempdb0.0 GB

Current largest database inventory sample.

JobsNo failures

No SQL Agent job failures detected in this window.