Oracle Enterprise Manager and IDERA SQL Diagnostic Manager for SQL Server are competing products focused on optimizing database management. Oracle Enterprise Manager holds an edge for large enterprises with complex needs due to its extensive feature set.
Features: Oracle Enterprise Manager is known for its comprehensive monitoring, configuration management, and performance diagnostics, making it suitable for diverse IT landscapes. Key features include SQL Monitoring, ADDM, and ASM Space Manager. In contrast, IDERA SQL Diagnostic Manager specializes in granular SQL Server performance monitoring with features like advanced diagnostics, alerting capabilities, and real-time performance metrics, making it ideal for SQL Server-focused environments.
Room for Improvement: Oracle Enterprise Manager could improve in simplifying the deployment process and reducing resource requirements. Enhancements in user interface intuitiveness and faster resolution times would also benefit users. IDERA SQL Diagnostic Manager might focus on expanding support for other database systems to increase its versatility. Further development in cross-platform integration and advanced reporting features could enhance its functionality.
Ease of Deployment and Customer Service: IDERA SQL Diagnostic Manager is noted for its straightforward deployment and dedicated SQL Server support, which is praised for efficiency. In contrast, Oracle Enterprise Manager, while robust, is more complex to deploy and requires significant resources. Oracle provides strong enterprise-level support, although complexity can lead to extended resolution times compared to IDERA's direct support.
Pricing and ROI: Oracle Enterprise Manager has a higher setup cost, reflecting its extensive capabilities and enterprise-level service but offers substantial ROI for those managing multiple platforms. IDERA SQL Diagnostic Manager, with its lower setup cost and faster deployment, can offer higher ROI in SQL Server environments, emphasizing lower total ownership cost. The choice often hinges on organizational needs for breadth versus specialization.
SQL Diagnostic Manager for SQL Server helps database administrators to find and fix SQL Server performance problems in physical, virtual, and cloud environments. Unlike its competition, it provides effective scalability, advanced SQL query analysis and optimization, prescriptive analysis with corrective SQL scripts, powerful automated alert responses, broad PowerShell integration, complete customization, and extensive support for current and legacy SQL Server and Windows.
Oracle Enterprise Manager is an on-premises management platform that provides a comprehensive integrated solution for managing and automating your various Oracle products, including applications, databases, middleware, hardware, and engineered systems located either in your Oracle data center or in the cloud.
With the Oracle Enterprise Manager's console, you can administer multiple databases and servers, distribute software to multiple servers and clients, monitor objects and events throughout the network, and integrate with other tools.
Key Oracle Enterprise Manager Features and Products
Reviews from Real Users
Oracle Enterprise Manager stands out among its competitors for a number of reasons. Several major ones are its central management and monitoring and its reporting capabilities
Robin C., head of Oracle Exadata Centre of Excellence at Tata Consultancy Services, writes, "The database performance monitoring features are very useful and allow us to quickly zero in on DB-related issues. Exadata storage server and Infiniband switches can be viewed from the GUI in OEM which cannot be done in other tools. The ability to deploy metric extensions makes this tool extensible for our custom monitoring also."
PeerSpot users note the effectiveness of these features. A database manager at a tech services company notes, “The solution's most valuable aspect is the fact that it is embedded with the Oracle database and Oracle's engineering system, its extra data, and analytics. They have plug-ins that are very helpful. Due to the infrastructure's size, the introduction they offer is very, very useful. It helps with an overall understanding of the product. They have a very nice graphical user interface. The monitoring is good. We can capture the SQL tune from us. With Oracle Enterprise Managers, we can see the rich performance tuning.”
We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.