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. Unified visibility, automated operations, and compliance — all inside OEM.
75
Metric Groups
2014–2022
SQL Server Versions
13.5 & 24ai
OEM Supported
13
Compliance Rules
6 Purpose-Built Dashboards
Comprehensive visibility into every SQL Server instance and database you monitor — right inside Oracle Enterprise Manager.
Home
Target status, server and SQL Agent control, database size and growth-potential table, reads/writes/errors chart, processor load, Always On Availability Groups panel, cluster summary, incident and job summaries.
Database
Per-database summary with Availability Group membership, backup history table, database composition pie chart, and in-OEM buttons for Backup Now, Schedule Backup, Restore Backup, and Delete Backup.
Performance
Day / Week / Month performance history for Process States, Logins/Logouts/sec, Connections Utilization, Reads/Writes/Errors/sec, Page Life Expectancy, Buffer Cache Hit Ratio, and Batch Requests/sec.
Analysis
Top 5 Session Statistics by CPU or Memory over the last Day, Week, or Month — with line charts, detail tables, and one-click Kill Session for runaway workloads.
Indexes
Index usage trends (seeks, scans, lookups, updates per second), index fragmentation table, and Missing Indexes recommendations with one-click Create Index execution.
Queries
Worst-performing queries by CPU time over a user-selectable date range, plus Performance History Comparison charts for database resources.
Enterprise-Grade Capabilities
Go beyond monitoring. Run operational tasks, enforce compliance, and manage high availability — all without leaving Oracle Enterprise Manager.
In-OEM Backup & Restore
Run, schedule, and delete SQL Server backups, and restore from backup history — all driven by OEM job types. Full backup, delete-backup, and two restore variants ship out of the box.
Always On AG & Cluster Operations
Monitor HADR replicas and Availability Groups, view cluster summary on the Home page, and kick off failover and pause/resume jobs from OEM. Deploy the purpose-built HADR or Cluster monitoring template in one click.
SQL Server & Agent Service Control
Start, stop, pause, and resume the SQL Server service and start/stop the SQL Server Agent directly from the Home page — no RDP session required.
Top Session Analysis & Kill Session
Identify the Top 5 session CPU and memory consumers over the last Day, Week, or Month and terminate offending sessions with a single click.
Compliance Standards, Out-of-the-Box
13 built-in compliance rules bundled into a ready-to-assign compliance standard: CLR Enabled, Max Degree of Parallelism, Max Memory, Transaction Log Files, Worker Threads, SQL Agent Automatic Start, Auto Growth, Auto Shrink, Index Fragmentation (Rebuild/Reorganize), Recent Backup, Transaction Log Backup, and xp_cmdshell.
Certified Monitoring Templates
Three Oracle-certified monitoring templates — Basic, Cluster, and HADR — so the right thresholds and collection schedules deploy to the right targets in minutes.
Broad Compatibility
Enterprise-ready support across the SQL Server versions, OEM platform, and agent configurations you rely on.
Microsoft SQL Server
2014, 2016, 2017, 2019, 2022
Oracle Enterprise Manager
Cloud Control 13.5 and 24ai (24.1).
Management Agent
Windows — local or remote monitoring. Agent does not need to be on the same host as SQL Server.
How It Works
Install the Plug-in
Deploy the signed OPAR artifact to your OMS and Management Agents using OEM's standard plug-in deployment flow.
Discover & Configure Targets
Add SQL Server instances as microsoft_sqlserver_database targets, provide connection details, and apply the monitoring template that matches the instance topology — Basic, Cluster, or HADR.
Start Monitoring & Managing
Access all six dashboards, assign the built-in Compliance Standard, and run backups, index creation, session kills, service control, and AG failovers — all from OEM.
Ready to Unify Your Database Monitoring?
See how the Microsoft SQL Server Plug-in for Oracle Enterprise Manager can simplify your operations, enforce compliance, and automate the operational work your DBAs do every day.