Software
Microsoft SQL Server Plug-in for
Oracle Enterprise Manager
Monitor, manage, and govern your SQL Server estate with the same enterprise-grade tools you use for Oracle, without ever leaving Oracle EM.
69
Metric Groups
2016–2025
SQL Server Versions
13.5 & 24ai
Oracle EM Supported
14
Compliance Rules
8 Purpose-Built Pages
Full visibility into every SQL Server instance and database you monitor, from inside Oracle Enterprise Manager.
Overview
The page a target opens on: instance status and availability history, server configuration, database space, top sessions by CPU, the Always On availability-group table, and open incidents.
Databases
A per-database table with Back Up and Restore dialogs. Each dialog submits an EM job.
Performance
Top processes, average wait times per interval, and blocked sessions.
Queries
Worst-performing and most expensive queries, including the top blocked queries.
Deadlocks
New in this plug-in: deadlock rate plus recent deadlocks, pulled straight from the system_health Extended Events session.
Indexes
Fragmentation, usage, and Missing Indexes recommendations, with a Create Index dialog that submits an EM job.
Analysis
Database capacity and growth: used and free space per database, volume-level disk space, and file autogrowth settings.
AG Failover Readiness
New in this plug-in: per-database RPO and RTO in seconds, redo and send queue depth, and link health for every Availability Group.
Enterprise-Grade Capabilities
Go beyond monitoring: run operational tasks, enforce compliance, and manage high availability without leaving Oracle Enterprise Manager.
Backup & Restore Inside Oracle EM
Run, schedule, and delete SQL Server backups, and restore from backup history, as Oracle EM job types. Full backup, delete-backup, and two restore variants ship out of the box.
Always On AG & Cluster Operations
Monitor replicas and Availability Groups, check per-database failover readiness (RPO/RTO), and run planned failover as an EM job.
SQL Server & Agent Service Control
Start, stop, and pause/resume SQL Server services as EM jobs (Windows agent).
Top Session Analysis & Kill Session
Track top sessions by CPU and memory live on the Home page, and terminate offending sessions with the Kill Session job.
Compliance Standards, Out-of-the-Box
14 built-in compliance rules ship in a ready-to-assign standard that covers configuration, security, backup hygiene, and index health. One rule flags SQL Server versions nearing or past end of support, which today means instances still on 2016 or older.
Least-Privilege & TLS-First Security
Monitoring runs without the sysadmin role, TLS is required by default, and xp_cmdshell stays off. The JDBC driver ships bundled, so there is nothing to stage on the agent.
Broad Compatibility
Enterprise-ready support across the SQL Server versions, Oracle EM platform, and agent configurations you rely on.
Microsoft SQL Server
2016, 2017, 2019, 2022, 2025 · Hosted on Windows or Linux, monitored remotely or locally
Oracle Enterprise Manager
Cloud Control 13.5 and 24ai (24.1).
Management Agent
Linux x86-64 or Windows x86-64, monitoring locally or remotely over pure JDBC with a bundled driver. The agent does not need to be on the SQL Server host. A Windows agent is only required for the service-control jobs and for Windows integrated authentication.
How It Works
Install the Plug-in
Deploy the signed OPAR artifact to your OMS and Management Agents using Oracle EM's standard plug-in deployment flow.
Configure Targets
Add each instance as a SQL Server Database (Beta) target with host, port, instance name, TLS mode, and your beta license key, in the console or in bulk with emcli.
Start Monitoring & Managing
Access all eight pages, assign the built-in Compliance Standard, and run backups, index creation, session kills, service control (Windows agent), and AG failovers, all from Oracle EM.
Ready to Unify Your Database Monitoring?
See how the Microsoft SQL Server Plug-in for Oracle Enterprise Manager can simplify operations and automate the routine work your DBAs do every day.