SERVER 1
TESTSRV_1.DBNEXIA.COM / Test / SQL Server / Last seen 2026-09-21 19:30P2 Storage: Rank files by measured growth, validate retention and business demand, then plan relocation, cleanup or capacity extension before reserve policy is breached. This is first because the condition is not yet critical, but delay reduces the time available for a controlled, tested change. Pattern: Errors, timeouts, login failures, CPU warnings, or memory grants are concentrated on this server.
In the selected window, 1 volumes dropped below free-space policy; 2684 log/runtime events were recorded, latest at 2026-09-21 14:40; databases grew by 0.0 GB in the selected window.
Right now, the error/log stream is active; storage headroom is below policy.
The current log pace projects to about 2,684 runtime events over the next 24 hours. Pressure indicators: 2,684 projected runtime events in 24 hours, 1 action signals, 1 watch signals. The likely outcome is repeated noise and growing maintenance debt unless an owner closes the action.
Rank files by measured growth, validate retention and business demand, then plan relocation, cleanup or capacity extension before reserve policy is breached.
The condition is not yet critical, but delay reduces the time available for a controlled, tested change.Group events by first error, number/state, database, host and application, then correlate with jobs, deployments and workload at the same timestamp.
Repeated final messages may be downstream symptoms; the earliest specific error identifies the investigation path.17.7 GB free (44.3%) of 40.0 GB.
2026-09-21 14:40 - (@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...
2026-09-21 14:40 - (@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...
2026-09-21 14:40 - (@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...
2026-09-21 14:40 - (@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...
0.0 GB growth (Log ).
1.0 GB current size.
0.1 GB current size.
CPU 4.0%, memory free 35.7%, users 2, transactions 8.
Data 3.4%, log 20.6%, version store 0 MB.
Last OK 2026-09-21 19:29, last failed -. Worst disk ANNAT 1 17.7 GB (44.3%). 2684 runtime events. 0.0 GB growth. CPU 4.0%, memory free 35.7%.
dbNexia_DB.dbo.AuditLog
8 tables / 314,009 rows synchronized at 2026-09-21 19:30:12; source SERVER 1 (TESTSRV_1.DBNEXIA.COM).
dbNexia_DB.dbo.dbsizes
dbNexia_DB.dbo.EventLog
VIEW SERVER STATE permission
msdb SQL Agent history
msdb.dbo.backupset
dbNexia_DB.dbo.ServerMetrics
VIEW SERVER STATE permission
VIEW SERVER STATE permission
Errors 2,660, timeouts 22, login failures 1, CPU warnings 0, memory grants 1.
(@MinEvidenceTime datetime) CREATE TABLE #SqlBackupLog ( LogDate datetime NULL, ProcessInfo nvarchar(64) NULL, [Text] nvarchar(max) NULL ); DECLAR...
database 'Errors 2,660, timeouts 22, login failures 1, CPU warnings 0, memory grants 1.' needs a newer log backup in the SQL backup chain.
Inspect the latest log-backup job failure for database 'Errors 2,660, timeouts 22, login failures 1, CPU warnings 0, memory grants 1.', then correct the specific cause: unavailable target, service-account access, broken chain, open transaction, replication/availability-group backlog or disk pressure. Run a log backup only after a valid full-backup baseline exists.
Confirm a new successful backup of the required type, run RESTORE VERIFYONLY where appropriate, and perform a scheduled test restore to an isolated instance to prove the recovery path and expected RPO/RTO.
No backup risks detected for this server.
44.3% free of 40.0 GB on T:\.
Meaning and fix
Meaning: The observation is outside the expected state, but the available evidence is not specific enough to assign a root cause safely.
Fix: Preserve the timestamp and identifiers shown in the row, then correlate the same server, database, job/login and time window across the relevant detail report, SQL/Oracle logs and application telemetry. Do not make a production change until one mechanism is supported by evidence.
Verify: Document the confirmed cause and baseline, apply the smallest justified correction, then verify that the signal does not recur during an equivalent collection window and that no adjacent metric regresses.
Log growth inside the selected 24h window.
Meaning and fix
Meaning: The observation is outside the expected state, but the available evidence is not specific enough to assign a root cause safely.
Fix: Preserve the timestamp and identifiers shown in the row, then correlate the same server, database, job/login and time window across the relevant detail report, SQL/Oracle logs and application telemetry. Do not make a production change until one mechanism is supported by evidence.
Verify: Document the confirmed cause and baseline, apply the smallest justified correction, then verify that the signal does not recur during an equivalent collection window and that no adjacent metric regresses.
No long running, blocking, or deadlock signals detected in this window.
Current largest database inventory sample.
Current largest database inventory sample.
Current largest database inventory sample.
Current largest database inventory sample.
Current largest database inventory sample.
Current largest database inventory sample.
Current largest database inventory sample.
Current largest database inventory sample.
Current largest database inventory sample.
No SQL Agent job failures detected in this window.