You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Plan release notes

Release:

2018.05.0182

Date:

November 22, 2018

Enhancements:


Release:

2018.04.0179

Date:

September 26, 2018

Enhancements:

Fixes:

  • Application main window remains disabled when restoring from taskbar after switching to another application but the Query store connection window remains active
  • Wrong query text formatting when importing XML query plan with multiple statements saved from SQL Server Management Studio
  • Query store window remains disabled when switched to and the Wait type tooltip remained opened in the main application window
  • Error list in the query text shows up when the execution plan is opened from the SQL Server Management Studio
  • „Incorrect syntax” error occurs in the Error list when some correct queries are inserted in the Query text tab
  • View query text in new tab option displays blank screen when one of the compared plan diagrams is shown in full screen mode
  • “Unable to cast object of type 'MS.Internal.NamedObject' to type 'ApexSQL.ExecutionPlanModel.NodeViewModel'“ error is encountered when using node selection after one of the compared plan diagrams was in full screen mode then restored
  • Execution results panel does not show any execution results for the selected statement with the “Checkpoint” used in the query when the actual plan is generated
  • Selected row in the Execution results tab does not get removed when using the “Remove row” option from the context menu
  • Application error is encountered when using right-click on the Execution plan history item after changing some code in the “Query text” editor
  • Application error is encountered when “Create missing index” button is used in the Query cost section after an empty query was executed
  • Application error is encountered when executing the same query two times and an element in the “Execution plan” diagram was selected after the first execution
  • Application error is encountered when invoking the Open window from the Home section of the main ribbon menu after using a removable media for the file Save/Open in previous session
  • The “Open in ApexSQL Plan” option from SQL Server Management Studio add-in is not initiating, if one instance of application is already opened
  • The Dashboard chart lines have multiple values at the same time point
  • Long statements are truncated when opened from the query store

Release:

2018.03.0163

Date:

April 05, 2018

Enhancements:

Fixes:

  • "System.NullReferenceException" message is encountered when there are no search results shown in Columns tab
  • The installer doesn't recognize already present NET Framework 4.7.1
  • The user settings are saved when the Options dialog is closed by Esc button on the keyboard
  • The application stops working when the search option is used in the Execution results tab
  • "No email client found and/or the application logs are too big (>5MB)" message is encountered when the Send logs button is clicked, even though there is an e-mail client installed and the log file is smaller than 5 MB
  • "System.Reflection.TargetInvocationException" message is encountered when the commands for comparison plans from the context menu are used under the Execution plan grid and there is no execution plan shown
  • "Provide value on 'System.Windows.StatisResourceExtension' threw an exception." message is encountered when the Send logs command is clicked in SQL Server Management Studio 2016 or 17 and no email client is set up on a machine

Changes:

  • Global results analysis options from the bottom of the application are now in the Management and Stored procedure main ribbon tabs
  • The alert icons now indicate cost thresholds instead of visual per-node operator cost highlights
  • Changing the metric used to display CPU and I/O resource costs on the operation icons has been deprecated and the information is now available in operation cost tooltips
  • Changing connection thickness according to row and data size has been deprecated and the connection thickness now represents estimated or actual number of rows

Release:

2018.02.0140

Date:

March 8, 2018

Enhancements:

  • Graphical execution plans:
    • Dashboard intervals selection
  • Query execution plan analysis:
    • XML view
    • Showplan node search
    • Execution plan comparison
    • Execution plan status bar
    • Results for actual execution plan
    • Viewing execution plans in Query store and Query performance tabs
  • Other:
    • Missing index creation
    • Recently used file list
    • Grid and execution plan nodes search option
    • Query code errors tab
    • Wait times descriptions
    • Keyboard shortcuts
      • (Ctrl+N) shortcut can be used to start a new, empty session with a new connection
      • (Ctrl+Q) shortcut can be used to start a new, empty session with the current connection
      • (Ctrl+O) shortcut can be used to open a file in a new session
      • (Ctrl+S) shortcut can be used to save a session (prompt for a filename if this is a new session) shortcut can be used
      • (Ctrl+Shift+A) shortcut can be used to save a session as a new filename
      • (Ctrl+Shift+S) shortcut can be used to save all sessions
      • (Ctrl+U) shortcut can be used to change database connection
      • (Ctrl+L) shortcut can be used to display an estimated execution plan
      • (Ctrl+M) shortcut can be used to display an actual execution plan
      • (Ctrl+F4) shortcut can be used to close a session
      • (Shift+Alt+Enter) shortcut can be used toggle full screen (also Esc to exit full screen)

Fixes:

  • "Unable to cast object of type 'System.Windows.Media.Color' to type 'System.Windows.Media.Brush''" message is shown and the application stops working in specific cases
  • The "Execution failed: Reason: The ConnectionString property has not been initialized" message is encountered when any execution plan button is clicked and the connection is not already established with SQL Server Query Store
  • The "The key is not present in the dictionary" error message is encountered when executing the Actual or Live execution plan on a machine with less than 4GB of RAM memory

Release:

2018.01.0133

Date:

February 6, 2018

Enhancements:

  • Open Query Store v2.1.0 support
  • SQL Server 2017 plan full support:
    • Batch Hash Table Build
    • Clustered Index Merge
    • Columnstore Index Delete
    • Columnstore Index Insert
    • Columnstore Index Merge
    • Columnstore Index Scan
    • Columnstore Index Update
    • Foreign Key References Check
    • Generic
    • Print
    • Put
    • Rank

Fixes:

  • An empty Query performance tab is opened instead of the Database connection window when there is no an active connection to a database and the Performance button is clicked
  • The Database connection window shows the "Loading..." indicator instead of "Connecting..." when the OK button is clicked to connect to a database
  • The Save as window selects an inappropriate file type under the Save as type drop-down list by default when the Save/Save as button is used
  • Approximately 45% of the data is missing when a session is saved to an execution plan (*.axep) file format and later opened from the application
  • Saving a session as the execution plan (*.axep) file stores SQL Server connection credentials in plain text
  • "Provide value on 'System.Windows.StatisResourceExtension' threw an exception" message is shown when the Send logs button is clicked
  • The values in the Actual row, Reads, Start time, End time, Duration columns under the Statements grid are not shown when the actual execution plan is used
  • The application shows incorrect names for the wait types in the Waits time grid
  • The default value in the Execution timeout box under the Connection options dialog is wrong
  • The add-in icons disappear in SQL Server Management Studio 2012 and 2014 when installed in parallel with any other ApexSQL add-in product released after January 22, 2018

Changes:

  • The application now requires Microsoft .NET Framework 4.7.1
  • SQL syntax highlighting is modified on dark theme

Release:

2017.03.0106

Date:

December 14, 2017

Fixes:

  • SQL Server Management Studio 17 stops working when the View dependencies command is used from the Object Explorer context menu or from the application main menu
  • "Application error: 'No coercion operator is defined between types 'System.Nullable`1[System.Int64]' and 'System.String'." error is encountered when applying a filter for any columns in the Profile a stored procedure pane
  • "Application error: 'No coercion operator is defined between types 'System.Double' and 'System.String'." error is encountered when applying a column filter for the Rows, Output, Data size columns in the Columns pane
  • "Application error: 'No coercion operator is defined between types 'System.Data.SqlTypes.SqlInt32' and 'System.String'." error is encountered when applying a column filter for any of the columns except the Table column in the I/O reads pane
  • "Application error: 'No coercion operator is defined between types 'ApexSQL.ExecutionPlanModel.ExecutionPlanMode' and 'System.String'." error is encountered when applying a column filter for the Execution type, Execution time and Created columns in the Execution plan history pane
  • The I/O reads tab does not appear in the appropriate location when the Actual execution plan is enabled and more than one SQL statements are used in a query editor
  • The T-SQL code in the tooltip under the Execution plan pane can be modified

Release:

2017.02.0100

Date:

October 26, 2017

Enhancements:

  • History statistics comparison
  • Save and open XML query execution plans
  • Open Query Store support
  • Query store dashboard
  • Resource cost profile bars
  • Stored procedure analysis

Fixes:

  • "option (querytraceon 9130)" text is added at the end of the query text when viewing an actual execution plan
  • "Incorrect syntax near the keyword 'option'" error message is shown when viewing an actual execution plan if the “Show number of rows read” option is turned on in the Options window
  • Graphical warning about a column with no statistics is not shown on a clustered index seek icon in the Execution plan tab
  • "(querytraceon9130)" text is added at the end of the query text when loading a saved XML file
  • JSON serialization of attached deadlock is not shown when loading a saved deadlock file
  • Session cannot be saved as an ApexSQL execution plan file
  • Zoom option drop-down in Execution plan tab doesn’t work
  • It is not possible to copy missing index details from the Execution plan tab
  • "NaN" value is shown in the Execution plan tab when creating an execution plan for a clustered index query

Changes:

  • Query store is now shown in a separate window, divided into three tabs: Data, Dashboard and Properties
  • Default output file name when exporting from XML view tab is changed

Release:

2017.01.0061

Date:

June 07, 2017

Features:

  • Supports SQL Server 2005 and higher
  • Supports SQL Server Management Studio 2012 integration and higher
  • Analyze and optimize SQL query execution plans
  • Identify query performance issues and deadlocks
  • Analyze wait statistics
  • Review query execution plans
  • Understand query performance characteristics
  • Customize graphical query execution plan view
  • Analyze query live performance statistics
  • Compare estimated and actual query execution plans
  • Compare history of different query versions
  • Review missing index details
  • Troubleshoot complex deadlocks
  • Focus on a specific metric
  • Compare compiled and runtime parameters
  • Trace the source of SQL statements
  • GUI themes