Skip to main content

IDERA Releases SQL Workload Analysis Product

IDERA announced the general availability of its SQL Workload Analysis product that provides database administrators (DBAs) deep insight into database performance and the applications that depend on it.

SQL Workload Analysis is provided with the company’s new SQL Diagnostic Manager Pro product and is available as an add-on to IDERA SQL Diagnostic Manager customers.

SQL Workload Analysis complements SQL Diagnostic Manager with continuous lightweight sampling of all SQL transactions combined with a simple browser user interface for detailed transaction analysis. All dimensions of SQL performance are exposed on a single screen and drill-down to root causes can be accomplished in a few mouse clicks. The product also helps non-DBAs identify how applications are running and where they may be creating bottlenecks in the database.

“The launch of SQL Workload Analysis provides a critical tool that will help customers ensure optimal application performance,” said Scott Stone, Group Product Manager at IDERA. “With SQL Diagnostic Manager Pro, SQL Workload Analysis combines extensive database resource monitoring with deep, easy-to-use performance analysis and recommendations to help you solve any issues that might come up. It’s like having an additional MVP DBA on your team.”

IDERA SQL Workload Analysis capabilities include:

- Detailed wait state analysis for applications and transactions

- Multi-faceted dashboard with drill-down into top wait categories, SQL statements, applications, databases, machines and logins

- Automatic analysis of query plans for faster tuning

- Integration with the Common Web Framework and Diagnostic Manager for streamlined problem analysis and resolution

SQL Diagnostic Manager Pro is a performance monitoring, alerting and diagnostics solution that proactively notifies administrators to health, performance or availability problems within their SQL Server environment via a central console, web-based dashboard or mobile device.

The Latest

According to Gartner, Inc. the following six trends will shape the future of cloud over the next four years, ultimately resulting in new ways of working that are digital in nature and transformative in impact ...

2020 was the equivalent of a wedding with a top-shelf open bar. As businesses scrambled to adjust to remote work, digital transformation accelerated at breakneck speed. New software categories emerged overnight. Tech stacks ballooned with all sorts of SaaS apps solving ALL the problems — often with little oversight or long-term integration planning, and yes frequently a lot of duplicated functionality ... But now the music's faded. The lights are on. Everyone from the CIO to the CFO is checking the bill. Welcome to the Great SaaS Hangover ...

Regardless of OpenShift being a scalable and flexible software, it can be a pain to monitor since complete visibility into the underlying operations is not guaranteed ... To effectively monitor an OpenShift environment, IT administrators should focus on these five key elements and their associated metrics ...

An overwhelming majority of IT leaders (95%) believe the upcoming wave of AI-powered digital transformation is set to be the most impactful and intensive seen thus far, according to The Science of Productivity: AI, Adoption, And Employee Experience, a new report from Nexthink ...

Overall outage frequency and the general level of reported severity continue to decline, according to the Outage Analysis 2025 from Uptime Institute. However, cyber security incidents are on the rise and often have severe, lasting impacts ...

In March, New Relic published the State of Observability for Media and Entertainment Report to share insights, data, and analysis into the adoption and business value of observability across the media and entertainment industry. Here are six key takeaways from the report ...

Regardless of their scale, business decisions often take time, effort, and a lot of back-and-forth discussion to reach any sort of actionable conclusion ... Any means of streamlining this process and getting from complex problems to optimal solutions more efficiently and reliably is key. How can organizations optimize their decision-making to save time and reduce excess effort from those involved? ...

As enterprises accelerate their cloud adoption strategies, CIOs are routinely exceeding their cloud budgets — a concern that's about to face additional pressure from an unexpected direction: uncertainty over semiconductor tariffs. The CIO Cloud Trends Survey & Report from Azul reveals the extent continued cloud investment despite cost overruns, and how organizations are attempting to bring spending under control ...

Image
Azul

According to Auvik's 2025 IT Trends Report, 60% of IT professionals feel at least moderately burned out on the job, with 43% stating that their workload is contributing to work stress. At the same time, many IT professionals are naming AI and machine learning as key areas they'd most like to upskill ...

Businesses that face downtime or outages risk financial and reputational damage, as well as reducing partner, shareholder, and customer trust. One of the major challenges that enterprises face is implementing a robust business continuity plan. What's the solution? The answer may lie in disaster recovery tactics such as truly immutable storage and regular disaster recovery testing ...

IDERA Releases SQL Workload Analysis Product

IDERA announced the general availability of its SQL Workload Analysis product that provides database administrators (DBAs) deep insight into database performance and the applications that depend on it.

SQL Workload Analysis is provided with the company’s new SQL Diagnostic Manager Pro product and is available as an add-on to IDERA SQL Diagnostic Manager customers.

SQL Workload Analysis complements SQL Diagnostic Manager with continuous lightweight sampling of all SQL transactions combined with a simple browser user interface for detailed transaction analysis. All dimensions of SQL performance are exposed on a single screen and drill-down to root causes can be accomplished in a few mouse clicks. The product also helps non-DBAs identify how applications are running and where they may be creating bottlenecks in the database.

“The launch of SQL Workload Analysis provides a critical tool that will help customers ensure optimal application performance,” said Scott Stone, Group Product Manager at IDERA. “With SQL Diagnostic Manager Pro, SQL Workload Analysis combines extensive database resource monitoring with deep, easy-to-use performance analysis and recommendations to help you solve any issues that might come up. It’s like having an additional MVP DBA on your team.”

IDERA SQL Workload Analysis capabilities include:

- Detailed wait state analysis for applications and transactions

- Multi-faceted dashboard with drill-down into top wait categories, SQL statements, applications, databases, machines and logins

- Automatic analysis of query plans for faster tuning

- Integration with the Common Web Framework and Diagnostic Manager for streamlined problem analysis and resolution

SQL Diagnostic Manager Pro is a performance monitoring, alerting and diagnostics solution that proactively notifies administrators to health, performance or availability problems within their SQL Server environment via a central console, web-based dashboard or mobile device.

The Latest

According to Gartner, Inc. the following six trends will shape the future of cloud over the next four years, ultimately resulting in new ways of working that are digital in nature and transformative in impact ...

2020 was the equivalent of a wedding with a top-shelf open bar. As businesses scrambled to adjust to remote work, digital transformation accelerated at breakneck speed. New software categories emerged overnight. Tech stacks ballooned with all sorts of SaaS apps solving ALL the problems — often with little oversight or long-term integration planning, and yes frequently a lot of duplicated functionality ... But now the music's faded. The lights are on. Everyone from the CIO to the CFO is checking the bill. Welcome to the Great SaaS Hangover ...

Regardless of OpenShift being a scalable and flexible software, it can be a pain to monitor since complete visibility into the underlying operations is not guaranteed ... To effectively monitor an OpenShift environment, IT administrators should focus on these five key elements and their associated metrics ...

An overwhelming majority of IT leaders (95%) believe the upcoming wave of AI-powered digital transformation is set to be the most impactful and intensive seen thus far, according to The Science of Productivity: AI, Adoption, And Employee Experience, a new report from Nexthink ...

Overall outage frequency and the general level of reported severity continue to decline, according to the Outage Analysis 2025 from Uptime Institute. However, cyber security incidents are on the rise and often have severe, lasting impacts ...

In March, New Relic published the State of Observability for Media and Entertainment Report to share insights, data, and analysis into the adoption and business value of observability across the media and entertainment industry. Here are six key takeaways from the report ...

Regardless of their scale, business decisions often take time, effort, and a lot of back-and-forth discussion to reach any sort of actionable conclusion ... Any means of streamlining this process and getting from complex problems to optimal solutions more efficiently and reliably is key. How can organizations optimize their decision-making to save time and reduce excess effort from those involved? ...

As enterprises accelerate their cloud adoption strategies, CIOs are routinely exceeding their cloud budgets — a concern that's about to face additional pressure from an unexpected direction: uncertainty over semiconductor tariffs. The CIO Cloud Trends Survey & Report from Azul reveals the extent continued cloud investment despite cost overruns, and how organizations are attempting to bring spending under control ...

Image
Azul

According to Auvik's 2025 IT Trends Report, 60% of IT professionals feel at least moderately burned out on the job, with 43% stating that their workload is contributing to work stress. At the same time, many IT professionals are naming AI and machine learning as key areas they'd most like to upskill ...

Businesses that face downtime or outages risk financial and reputational damage, as well as reducing partner, shareholder, and customer trust. One of the major challenges that enterprises face is implementing a robust business continuity plan. What's the solution? The answer may lie in disaster recovery tactics such as truly immutable storage and regular disaster recovery testing ...