#United States #Houston #Idera #SQL Server #Microsoft Entra ID

Idera Launches SQL Diagnostic Manager 13.0

On March 6, 2025, Idera, Inc., a prominent provider of tools aimed at improving database productivity, announced the rollout of SQL Diagnostic Manager version 13.0. This substantial update brings several new features aimed at enhancing SQL Server performance monitoring, including the pivotal integration with Microsoft Entra ID authentication.

Enhanced Authentication Features

The integration with Microsoft Entra ID revolutionizes credential management for Azure SQL and SQL Server 2022 environments. Users can now rely on existing Azure Profiles to streamline the Azure Discovery feature, effectively eliminating the manual entry of credentials for each database or instance. This not only simplifies the monitoring setup but also enhances overall security by utilizing the most secure connection available to Azure SQL.

Among the enhancements driven by this integration are:

• - Reuse of Azure Profiles: Users can leverage existing Azure Profiles for defining Custom Counters or for discovering Azure resources. This heightens operational efficiency.
• - Effortless Large Resource Management: With shared Entra ID credentials, adding significant numbers of Azure resources is now more efficient than ever.
• - Simplified Credential Management: The new streamlined process significantly reduces the administration burden compared to traditional SQL Server authentication methods.

Key Features of SQL Diagnostic Manager 13.0

SQL Diagnostic Manager facilitates proactive monitoring and management of SQL Server environments. Its user-friendly desktop and mobile-compatible web consoles help Database Administrators (DBAs) minimize server downtime through real-time monitoring and customizable alerts.

Some of the key features of this release include:

• - Scale-out Browser Compatibility: This feature allows users to view multiple Diagnostic Manager installations in a single pane, enhancing performance and scalability.
• - Configurable Heat Map Overview: Users can graphically represent the overall health of all instances through a calculated health index which provides at-a-glance insights.
• - Service Now Integration: Alerts from SQL Diagnostic Manager can now be forwarded to Service Now, allowing teams to efficiently track incidents within the Service Now ticketing system.

The Importance of SQL Diagnostic Manager

In an era where data drives business decision-making, ensuring optimal SQL Server performance is crucial. SQL Diagnostic Manager provides essential tools designed to assess server health, availability, and performance metrics comprehensively. As a result, organizations can quickly identify and mitigate potential bottlenecks, keeping systems running smoothly.

• - Continuous Proactive Monitoring: The tool continuously evaluates server performance to provide real-time insights that prevent issues before they become serious problems.
• - In-depth Diagnostics: SQL Diagnostic Manager enables users to delve deep into performance metrics to efficiently tackle performance bottlenecks.
• - Custom Alerts: Users can tailor alerts to their specific requirements, ensuring that they remain informed of any anomalies that could affect performance.

Future Developments

Max Hunsicker, General Manager at Idera, expressed confidence in the new capabilities stating, "The integration of Microsoft Entra ID authentication enhances security while simplifying credential management. This release reinforces our commitment to continuously innovate and meet the evolving needs of SQL Server professionals."

Idera, Inc. provides a suite of software tools that empower database and IT professionals to manage their systems optimally. With SQL Diagnostic Manager 13.0, organizations can maximize productivity and reduce the risk of downtime in their SQL Server environments.

For those interested in SQL Diagnostic Manager 13.0, trial versions are available for download on Idera's official website.