Top 10 queries based on average duration in the last hour The following graphical representation elements of the Query store dashboard are implemented: This includes all editions (Express, Standard, Enterprise).ĭiagrams, who doesn’t like them? The new Extended Query store contains an additional tab reserved only for diagrams and charts that can provide visualization, deep insight and analysis of the data inside Query Store. This means that besides the original support of Query store for SQL Server 2016, previous versions of SQL Server from 2008 to 2014 are also supported. The main enhancement of the Data tab is that the Query store is now available to users that haven’t yet migrated to SQL Server 2016 or higher. This tab resembles the complete Query store feature in the previous version of ApexSQL Plan, but now as a separate tab, allows users to view specific Query store results using their predefined criteria. This means that the Query store is not separated into three different tabs with specific uses. The Extended Query store is an upgraded version of the Query store feature in previous version of ApexSQL Plan. In this version we added many new features and major improvements related Query store support and Stored procedure analysis along with other minor features. The Deadlock tab is shown when a deadlock file is opened.We are glad to announce that ApexSQL Plan 2017 R2 has just been released. The Advanced tab in the Options window is used for managing information and warning options: The Layout and colors tab in the Options window is used for setting up cost threshold values and selecting the desired GUI theme of ApexSQL Plan:
This feature is supported for SQL Server 2016 version and higher: The Query store tab is used for reviewing query execution data collected from SQL Server Query store. The Query performance tab displays the slowest queries recently executed by defined criteria and collected from SQL Server with provided all important details: The Execution plan history tab is used to display the history of different versions of query executions for the current application tab: The XML view tab is used to display the query execution plan in XML format: The Join graph tab is used to graphically display relationships between database tables involved in the execution plan: The Operations tree tab is used for analyzing query operation tree details: The Columns tab is used for reviewing all columns used in the plan, and their associated operations and indexes: The Operations tab shows simplified and expanded operations that are used in the selected query, and allows implicit conversions within. The Waits tab is used for analyzing wait statistics of executed queries: The I/O reads tab is used for performing I/O reads analysis along with scan counts: The Execution plan tab is activated, along with other tabs, seen on the bottom of the window, when an execution plan is executed to create an actual, live or estimated query execution plan: This tab is also shown when an previously saved execution plan query is loaded: This Query text tab is used for writing execution plan queries. Home ribbon bar, with dropdown action buttons: This window is shown when ApexSQL Plan is started: