PRTGPlugins · Monitoring refined

See what SQL Server is doing.Investigate without guesswork.

SQLMonitor brings availability, waits, workload, blocking and long-running request diagnostics into PRTG — with bounded local logging and a deliberately read-only shadow-analysis workflow.

SQLMonitor 1.5.1.0Included in Setup 1.5.101No active SQL KILL

From broad performance signals. To the query that matters.

Performance

Availability, waits, workload and resource counters for continuous operational visibility.

LONREQ

Bounded diagnostics for long-running requests, with optional local activity detail.

BLOCKED

Detect blocked SQL activity and expose the workload that deserves attention.

SQL Server top reads monitoring view
Surface the statements driving read workload.
SQL Server top waits monitoring view
See which waits shape current performance.

Capture useful diagnostics. Keep the scope controlled.

SQLMonitor 1.5.1.0 can write local diagnostic material on the PRTG probe. Keep access restricted, use safe SQL logging when required and set a suitable maximum file size.

Files

  • SQLMonitor_LONREQ.log
  • SQLMonitor_LONREQ_ACTIVITY.log

Controls

-LOG:ON|OFF
-LOGSQL:SAFE|OFF
-LOGMAXMB:1..100
-ACTIVITYLOG:ON|OFF
SQL Server storage latency monitoring view
Follow storage latency where it affects SQL workloads.
SQL Server pending IO monitoring view
Expose pending I/O before it becomes a wider service issue.

Test a termination policy. Change nothing in SQL Server.

Shadow analysis identifies sessions that would meet a selected policy and writes the result to SQLMonitor_LONREQ_SHADOW.log. It is deliberately read-only.

-KILLSHADOW:OFF|ALL|db1,db2
-KILLTH:60..86400

Channels: ShadowRoot_Count, WouldKill_Count, ShadowRoot_MaxSec and ShadowLog_Error.

No active SQL KILL is performed by SQLMonitor 1.5.1.0.