Idera announced the availability of its latest free tool, SQL Statistics Aggregator.
The new tool allows users to speed up the aggregation and analysis of Statistics IO data that is common when doing query tuning by creating an interactive table of the data making it much easier to view and interpret. Using this information, database administrators (DBAs) can quickly see where the problems are that otherwise could take hours to dissect and correlate.
DBAs in smaller companies may typically have SQL Servers that have less incoming queries than larger enterprises. The DBAs in smaller companies may find parsing through query lines to find potential performance issues an annoyance. Larger organizations, however, produce thousands of lines for analysis that could cripple a team of DBAs attempting to solve a critical issue.
“With SQL Statistics Aggregator, Idera continues to create tools that make the lives of DBAs easier by solving complex and time-consuming problems, and offering them free of charge,” said Randy Jacops, CEO of Idera. “SQL Statistics Aggregator is a powerful tool that will save DBAs countless hours, enabling them to focus on improving the health and performance of their SQL Servers and making critical business decisions. There is no other similar tool on the market.”
SQL Statistics Aggregator works by compiling detailed Statistics I/O and time data in an interactive table for easy aggregation and viewing. Using the table, DBAs can quickly see where I/O activity is occurring and correlate that to a particular query node. SQL Statistics Aggregator also allows DBAs to run and re-run problem queries against an instance right from the tool. That way they can gather and analyze data, make tuning changes, re-run the query and continue to iterate until performance is optimized.
SQL Diagnostic Manager customers can use SQL Statistics Aggregator to troubleshoot their SQL Server problems at no additional cost.
The Latest
In MEAN TIME TO INSIGHT Episode 5, Shamus McGillicuddy, VP of Research, Network Infrastructure and Operations, at EMA discusses the network source of truth ...
A vast majority (89%) of organizations have rapidly expanded their technology in the past few years and three quarters (76%) say it's brought with it increased "chaos" that they have to manage, according to Situation Report 2024: Managing Technology Chaos from Software AG ...
In 2024 the number one challenge facing IT teams is a lack of skilled workers, and many are turning to automation as an answer, according to IT Trends: 2024 Industry Report ...
Organizations are continuing to embrace multicloud environments and cloud-native architectures to enable rapid transformation and deliver secure innovation. However, despite the speed, scale, and agility enabled by these modern cloud ecosystems, organizations are struggling to manage the explosion of data they create, according to The state of observability 2024: Overcoming complexity through AI-driven analytics and automation strategies, a report from Dynatrace ...
Organizations recognize the value of observability, but only 10% of them are actually practicing full observability of their applications and infrastructure. This is among the key findings from the recently completed Logz.io 2024 Observability Pulse Survey and Report ...
Businesses must adopt a comprehensive Internet Performance Monitoring (IPM) strategy, says Enterprise Management Associates (EMA), a leading IT analyst research firm. This strategy is crucial to bridge the significant observability gap within today's complex IT infrastructures. The recommendation is particularly timely, given that 99% of enterprises are expanding their use of the Internet as a primary connectivity conduit while facing challenges due to the inefficiency of multiple, disjointed monitoring tools, according to Modern Enterprises Must Boost Observability with Internet Performance Monitoring, a new report from EMA and Catchpoint ...
Choosing the right approach is critical with cloud monitoring in hybrid environments. Otherwise, you may drive up costs with features you don’t need and risk diminishing the visibility of your on-premises IT ...
Consumers ranked the marketing strategies and missteps that most significantly impact brand trust, which 73% say is their biggest motivator to share first-party data, according to The Rules of the Marketing Game, a 2023 report from Pantheon ...
Digital experience monitoring is the practice of monitoring and analyzing the complete digital user journey of your applications, websites, APIs, and other digital services. It involves tracking the performance of your web application from the perspective of the end user, providing detailed insights on user experience, app performance, and customer satisfaction ...
