SQL Server monitoring

SQL Server monitoring without agents

Scops monitors every SQL Server instance from one place, next to your Oracle and PostgreSQL databases. Nothing is installed on the server, the login is not sysadmin, and 30 Radar detectors report a problem while there is still time to act.

What Scops watches on SQL Server

Radar Engine for SQL Server

Radar Engine catches the problems that are hardest to see before they break an instance. For a problem that already happened, it is the strongest way to reach the root cause.

On SQL Server it runs 30 detectors:

GroupDetectors
LoadBlocking pile-up, wait wave, load surge, throughput collapse, deadlock burst
ResourcesCPU saturation, host CPU, memory pressure, worker thread limit, I/O latency
SQLOne statement taking over, slower on a new plan, compilation storm
SpaceTransaction log fill, data file fill, tempdb fill, identity running out
AvailabilityDatabase state, corruption, AG replica health, AG replica lag, failover, restart, backup age, log backup age
StateError log, Agent job failures, configuration change, recovery model change, record hour

A finding names the instance, the database and the cause. A transaction log on its way to error 9002 is reported with the time left, measured from its real growth, not from a fixed percentage.

Scops AI answers about SQL Server

Scops AI is the most advanced AI assistant for DBAs, equipped with 40+ agentic tools to think and act like a DBA.

Ask why an instance slowed down at 14:03. It reads the waits, the sessions, the statements and the plans, and proves its answer with the instance's own data. It works with OpenAI, Claude or any compatible LLM.

Agentless, and no sysadmin

Scops connects to the instance like any SQL client, with a SQL Server login or a Windows account. The connection is always encrypted. Nothing is installed on the server and nothing is asked of its operating system: no WMI, no local administrator.

The login needs no server role. It needs VIEW SERVER STATE (VIEW SERVER PERFORMANCE STATE from SQL Server 2022), CONNECT ANY DATABASE, VIEW ANY DEFINITION and the right to read the error log. The connection test lists what is missing and writes the script for it.

What it monitors

One platform for Oracle, SQL Server and PostgreSQL

The same installation monitors Oracle and PostgreSQL. Each engine has its own Dashboard, Live Activity, Insights, Metrics, Health Check, Sizing and Radar detectors, in its own terms, and all of them share one Databases page, one alert log and one set of reports. See database monitoring with Scops.

Questions

Does Scops install an agent on the SQL Server host?
No. Scops connects to the instance like any SQL client and installs nothing on the server. It asks nothing of the operating system: no WMI and no local administrator.

Does the monitoring login need sysadmin?
No. It needs no server role. VIEW SERVER STATE (VIEW SERVER PERFORMANCE STATE from SQL Server 2022), CONNECT ANY DATABASE, VIEW ANY DEFINITION and the right to read the error log are enough, and the connection test writes the script.

Which SQL Server versions does Scops monitor?
SQL Server 2017, 2019, 2022 and 2025, on Windows and on Linux, in Enterprise, Standard, Developer and Express editions.

How does Scops find the head blocker?
Live Activity shows every blocking chain with the session at its head and the sessions that wait behind it. Radar Engine reports a chain while it grows, and names a head that sleeps with an open transaction.

How does Scops warn before a transaction log is full?
Radar Engine fits the real growth of each log against what the log may reach, its size limit and the free space of its volume, and reports the time left before error 9002. A log that fills and empties with every log backup stays quiet.

What does SQL Server monitoring cost with Scops?
Community is free for 2 SQL Server instances, with Radar Engine, alerts, reports and Scops AI. Professional is $249 per instance a year, each further one costs 3% less, down to $199. An instance counts once, however many databases it holds.

Can the same installation monitor Oracle and PostgreSQL?
Yes. Oracle, SQL Server and PostgreSQL are monitored from one Scops server, on one Databases page.

Start

Open the live demo, or download Scops. It is free for 2 SQL Server instances. To connect the first one, see Add a database and system requirements.

Related