SolarWinds Enhances Plan Explorer to Help Database Pros Improve Operations, Performance, and Business Outcomes
SolarWinds announced enhancements to Plan Explorer, a tool for analyzing query performance in Microsoft SQL Server environments. The free product helps database professionals improve database performance and technical efficiency. Plan Explorer provides insights through graphically displaying query execution plans, index scoring, live query profiles, and more. It is natively built into SolarWinds SQL Sentry, offering comprehensive monitoring and diagnostics for effective SQL Server performance management.
Enhancements to Plan Explorer improve query performance analysis and deadlock resolution.
Compatibility with SQL Server 2022 and plan guide indication provide enhanced visibility into query execution.
Streamlined deadlock investigation allows users to dissect deadlock events efficiently.
No significant negative aspects were highlighted in the press release.
SolarWinds doubles down on free tooling for better visibility and more seamless SQL Server integration
The Plan Explorer tool helps database teams find the root of query problems in Microsoft SQL Server. Plan Explorer provides insights by graphically delivering query execution plans in helpful plan comparisons, as well as color and layout options for diagrams. It also has a number of performance-tuning capabilities:
- Runtime metrics unavailable in SQL Server Management Studio (SSMS)
- Index scoring and histogram analysis
- Live query profile with resource charts
- Wait statistics with links to the SQLskills wait type library
- Full query call stack for dynamic SQL and iterative queries
- Session history, versioning, and comments
- Unique analysis and visualization of deadlocks
Plan Explorer is also natively built into the SolarWinds SQL Sentry® product. By combining the Plan Explorer tool's detailed query plan analysis with the comprehensive monitoring and diagnostics of SQL Sentry, database administrators and developers can achieve a more effective approach to managing SQL Server performance. This dual approach helps ensure immediate query performance improvement and long-term SQL Server performance, stability, and efficiency.
"Plan Explorer is a much-beloved free product in the modern DBA’s toolbox,” says Suril Jasani, SQL Sentry Product Manager. “SolarWinds is committed to investing in the products that make the lives of DBAs a little easier.”
The powerful new SolarWinds® Plan Explorer upgrades enable teams to optimize query performance and resolve deadlocks more swiftly and efficiently and include:
- Compatibility with SQL Server 2022: Plan Explorer has expanded its performance analysis capabilities to fully support SQL Server 2022. With this support, Plan Explorer maintains its high standard of performance analysis, helping ensure users can maximize the benefits of the latest SQL Server features.
- Enhanced visibility with plan guide indication: Plan Explorer now provides insights into query execution. The feature demystifies the often complex execution plans, making it easier to identify potential performance bottlenecks and apply targeted optimizations.
- Streamlined deadlock investigation: Users can now dissect deadlock events, understand their root causes, and implement corrective measures more efficiently.
- Revamped start page: The start page of Plan Explorer has been redesigned to offer a more intuitive user experience and encourage community engagement with easy access to documentation, industry events, and information about other SolarWinds solutions.
SolarWinds has continued to innovate its powerful database management solutions to provide customers with amplified visibility, more seamless integrations, and the ability to redefine the capabilities of the database environment as it becomes increasingly complicated. The company recently announced major enhancements to its comprehensive database performance monitoring and DataOps solution, SQL Sentry. These include introducing query-level wait statistics and a revamped Environmental Health Overview dashboard that enables organizations to identify and prevent database performance issues.
For more information about how Plan Explorer can help enterprises get more value from their databases with minimal risk, please visit: https://www.solarwinds.com/free-tools/plan-explorer.
Connect with SolarWinds
#SWI
#SWIproducts
#SWIdatabase
About SolarWinds
SolarWinds (NYSE:SWI) is a leading provider of simple, powerful, secure observability and IT management software built to enable customers to accelerate their digital transformation. Our solutions provide organizations worldwide—regardless of type, size, or complexity—with a comprehensive and unified view of today’s modern, distributed, and hybrid network environments. We continuously engage with IT service and operations professionals, DevOps and SecOps professionals, and database administrators (DBAs) to understand the challenges they face in maintaining high-performing and highly available hybrid IT infrastructures, applications, and environments. The insights we gain from them, in places like our THWACK community, allow us to address customers’ needs now and in the future. Our focus on the user and our commitment to excellence in end-to-end hybrid IT management have established SolarWinds as a worldwide leader in solutions for observability, IT service management, application performance, and database management. Learn more today at www.solarwinds.com.
The SolarWinds, SolarWinds & Design, Orion, and THWACK trademarks are the exclusive property of SolarWinds Worldwide, LLC or its affiliates, are registered with the
© 2024 SolarWinds Worldwide, LLC. All rights reserved.
View source version on businesswire.com: https://www.businesswire.com/news/home/20240430172139/en/
John Eddy
Goldin Solutions
Phone: +1-646-660-8648
solarwinds@goldinsolutions.com
Dillon Townsel
SolarWinds
Phone: +1-512-498-5583
pr@solarwinds.com
Source: SolarWinds Worldwide, LLC.
FAQ
What is Plan Explorer?
What are the enhancements to Plan Explorer?
Where can I learn more about Plan Explorer?
