Software
Microsoft SQL Server Plug-in for
Oracle Enterprise Manager
Monitor availability, performance, queries, storage, and Always On availability groups for every SQL Server instance from the Oracle Enterprise Manager console, and act on what you find with Oracle EM jobs.
75
Metric Groups
13
Console Pages
14
Compliance Rules
2016–2025
SQL Server Versions
Headline Features
Five features that answer specific operational questions about your SQL Server estate.
AG Failover Readiness
One row per database per secondary replica: a Ready or Not ready verdict, synchronization state, recovery point and recovery time in seconds, redo and send queue sizes, and redo and send rates. Two more regions cover a range you choose: replication per database and secondary, and instance-wide HADR wait types. Default thresholds alert on a broken replica link and on redo queue, send queue, and recovery point. A reading the plug-in cannot determine shows as blank, not as zero.
Query History and Range Analysis
Choose a start and end time and Query History ranks the top 100 queries in that range by CPU or by memory granted, or lists the queries that ran under more than one plan, worst regression first. Blocking, Waits, and File I/O read the same stored history for a range you choose. Ranges older than raw metric retention are served from Oracle EM's hourly rollup, and the page says when that happens.
Security Update Status
Compares each instance's build with a reference table of Microsoft's SQL Server security updates that ships with the plug-in, on the instance's own servicing path (GDR or cumulative update). It reports the latest security update, the build that carries it, and how many days behind the instance is, counted from the oldest security update it is missing. Thresholds ship at 30 days (warning) and 90 days (critical).
Deadlock and Contention Alerting
Deadlock rate over time and a Recent Deadlocks list with the victim session, victim database, participants, and resources. Default thresholds cover deadlocks in the last hour, blocked sessions, connection saturation against the configured maximum, and tempdb PAGELATCH_EX contention.
Native T-SQL Jobs
Full, differential, and transaction log backups, run now or scheduled once or daily; restore, either left ready for further log restores or brought online; deletion of msdb backup history; Create Index; kill session; and a planned availability group failover (forced failover with data loss is not offered). Backup and restore use native T-SQL, without xp_cmdshell.
13 Purpose-Built Pages
Every SQL Server Database target gets thirteen console pages, grouped under Storage and Workload in a navigation tree that stays in place as you scroll. Five of them take a start and end time you choose.
Overview
Server configuration, 24-hour availability history, instance status (SQL Server Agent state, deadlocks in the last hour, tempdb page waiters, oldest backup), database space, the availability group table, processor utilization, top sessions, the SQL Server services on the host, and open incidents.
Databases
A database selector that drives every region at once: summary, data, log, and free-space composition, space usage, physical I/O, files, filegroups, and Always On database replicas. Backup Management launches the Back Up, Schedule Backup, Restore, and Delete Backup History dialogs, each of which submits an Oracle EM job.
Analysis
Capacity planning: used and free space per database, volume free space, and file autogrowth settings.
Performance
Processor load, process memory, database I/O in operations and bytes, cache hit ratios and average wait times per interval, server network, error, and read/write rates, top processes, and server statistics.
Counters
General Statistics, SQL Statistics, Buffer Manager, Memory Manager, and Plan Cache counters from SQL Server's performance counter views.
Current Queries
The plan cache as of the latest collection: top queries by CPU, executions, and memory grant, query plan statistics, and a chart of worst-query CPU against another instance metric. Query text copies with one click.
Query History
The top queries by CPU or by memory granted between a start and end time you choose, or the queries whose plan changed in that range.
Blocking
Sessions blocked right now, and the 50 longest blocks in a range you choose, with both sessions and their SQL text, the wait type and resource, and the head blocker.
Waits
What the instance waited on in a range you choose: the top five wait types, wait time by category, a trend, and the full ranking with signal wait.
File I/O
Reads, writes, and average latency per file and per database in a range you choose, with a latency trend and files ranked by total stall.
Deadlocks
Deadlock rate, a current summary, and recent deadlocks with the victim, participants, and resources.
Indexes
Fragmentation for indexes of 1,000 pages or more, index usage, and missing-index suggestions. The Create Index dialog prefills from a selected suggestion and submits an Oracle EM job.
AG Failover Readiness
Per database and secondary replica: readiness, synchronization state, recovery point and recovery time, redo and send queues and rates, plus replication and HADR waits over a range you choose.
Enterprise Capabilities
Alerting, compliance, high availability, and security for SQL Server, managed in the same Oracle EM console as the rest of your estate.
One Target Type for Every Topology
A single SQL Server Database target type works out at run time whether it is monitoring a standalone instance, an availability group replica, or a failover cluster instance. Point it at the availability group listener or the cluster's virtual network name and it follows the instance across a failover.
Default Thresholds from Day One
Nineteen thresholds apply when a target is created, covering availability, database free space, host CPU, availability group lag, backup age, transaction log use, file read and write latency, deadlocks, blocking, connection saturation, tempdb contention, security update age, failing collections, and license expiry. Each one is editable per target.
14 Compliance Rules
Rules for versions nearing or past end of support, AUTO_SHRINK, unbounded max server memory, default MAXDOP, overridden max worker threads, CLR, xp_cmdshell, percentage autogrowth, multiple log files, stale backups, missing log backups, index fragmentation, and SQL Server Agent start mode. They evaluate data already collected, with no extra load on the instance.
Per-Interval Figures
SQL Server's query, wait, and file I/O statistics are cumulative since the plan was cached or the service started. The plug-in computes the change between collections, so charts and range totals show what happened in each interval rather than a lifetime total.
Least-Privilege Monitoring
Monitoring uses a read-only login with no access to user-table data. Jobs that change the instance use their own credentials, applied only where you need them.
Encrypted Connections by Default
Connections are encrypted unless you turn encryption off. Choose per target whether the server certificate is also validated against a truststore you supply.
Collection You Can Diagnose
A Collector Status metric distinguishes a feature that is not configured on the instance from a collection that is failing, and alerts only on the failure.
Readable by AI Clients
From Oracle EM 24ai RU12, Oracle EM's own MCP server gives AI clients read access to the plug-in's data. Column labels state what their values mean, and time, size, and percentage columns carry units, so a client can interpret the data without the documentation.
Linux and Windows
Monitor SQL Server on Windows or Linux from a Linux or Windows agent, locally or remotely. The Microsoft JDBC driver ships inside the plug-in, so there is nothing to install on the agent.
Compatibility
Certified SQL Server versions, Oracle EM releases, and platforms.
SQL Server
2016, 2017, 2019, 2022, 2025, hosted on Windows or Linux. On 2016 and 2017, tempdb contention and cluster node detail return less detail than on 2019 and later.
Oracle Enterprise Manager
24ai (24.1), certified across every supported SQL Server version. Cloud Control 13.5, verified for import, deployment, collection, and console pages.
Operating Systems
Linux x86-64 and Windows x86-64 agents, local or remote.
How It Works
Deploy the Plug-in
Import the OPAR that matches your Oracle EM release with emcli, then deploy it to the management server and to each agent that will monitor SQL Server.
Create the Monitoring Login
On each instance, create a read-only monitoring login. A setup script is available from support.
Add Targets
Add each instance as a SQL Server Database target with its host, port, instance name, TLS mode, and license key, from the console or in bulk with emcli. Then apply the monitoring credentials to the target.
Monitor and Act
Pages and thresholds work from the first collection; daily groups such as per-database space fill in within 24 hours. Set a host credential on the target to run backups, restores, and other jobs from the console.
Get a Custom Quote
Ready to add SQL Server monitoring to your Oracle Enterprise Manager? Build a quote in minutes and receive detailed pricing by email.
Ready to Unify Your Database Monitoring?
See how the Microsoft SQL Server Plug-in for Oracle Enterprise Manager can simplify your operations.