SolarWinds announced enhancements to Plan Explorer®, its tool for analyzing query performance in Microsoft® SQL Server® environments.
This free product helps database professionals analyze query execution plans to improve database performance and drive better technical efficiency in their data ecosystems.
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.
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.
The Latest
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 ...
IT spending is expected to jump nearly 10% in 2025, and organizations are now facing pressure to manage costs without slowing down critical functions like observability. To meet the challenge, leaders are turning to smarter, more cost effective business strategies. Enter stage right: OpenTelemetry, the missing piece of the puzzle that is no longer just an option but rather a strategic advantage ...
Amidst the threat of cyberhacks and data breaches, companies install several security measures to keep their business safely afloat. These measures aim to protect businesses, employees, and crucial data. Yet, employees perceive them as burdensome. Frustrated with complex logins, slow access, and constant security checks, workers decide to completely bypass all security set-ups ...
In MEAN TIME TO INSIGHT Episode 13, Shamus McGillicuddy, VP of Research, Network Infrastructure and Operations, at EMA discusses hybrid multi-cloud networking strategy ...
In high-traffic environments, the sheer volume and unpredictable nature of network incidents can quickly overwhelm even the most skilled teams, hindering their ability to react swiftly and effectively, potentially impacting service availability and overall business performance. This is where closed-loop remediation comes into the picture: an IT management concept designed to address the escalating complexity of modern networks ...
In 2025, enterprise workflows are undergoing a seismic shift. Propelled by breakthroughs in generative AI (GenAI), large language models (LLMs), and natural language processing (NLP), a new paradigm is emerging — agentic AI. This technology is not just automating tasks; it's reimagining how organizations make decisions, engage customers, and operate at scale ...
In the early days of the cloud revolution, business leaders perceived cloud services as a means of sidelining IT organizations. IT was too slow, too expensive, or incapable of supporting new technologies. With a team of developers, line of business managers could deploy new applications and services in the cloud. IT has been fighting to retake control ever since. Today, IT is back in the driver's seat, according to new research by Enterprise Management Associates (EMA) ...
In today's fast-paced and increasingly complex network environments, Network Operations Centers (NOCs) are the backbone of ensuring continuous uptime, smooth service delivery, and rapid issue resolution. However, the challenges faced by NOC teams are only growing. In a recent study, 78% state network complexity has grown significantly over the last few years while 84% regularly learn about network issues from users. It is imperative we adopt a new approach to managing today's network experiences ...
From growing reliance on FinOps teams to the increasing attention on artificial intelligence (AI), and software licensing, the Flexera 2025 State of the Cloud Report digs into how organizations are improving cloud spend efficiency, while tackling the complexities of emerging technologies ...