Plan Explorer Change List

 

Version 1.3 (Build 6.4.933.0)

Date: 12/JAN/2012

FEATURES:
ID Component Name
1016 PA-Plan Explorer Include partition information available in actual plans
1063 PA-Plan Explorer SQL 2012 support for the Plan Explorer add-in (as of 3/20/12)
FIXES:    
ID Component Name
3288 PA-Plan Explorer GO <int> parsing is case sensitive
3289 PA-Plan Explorer SQL Server 2012 parsing requires updated ScriptDom
Version 1.3 (Build 6.4.931.0)

Date: 10/JAN/2012

FIXES:
ID Component Name
3285 PA-Plan Explorer User exception received: "Object reference not set to an instance of an object"
Version 1.3 (Build 6.4.930.0)

Date: 3/JAN/2012

FEATURES:
ID Component Name
902 PA-Plan Explorer File > Save As in addition to File > Save
996 PA-Plan Explorer Allow multiple batch execution via GO T-SQL command
1007 PA-Plan Explorer Show non-clustered index details for narrow DML plans
     
FIXES:    
ID Component Name
3242 PA-Plan Explorer Compute scalars may show zero cost when showing line widths by data size
3243 PA-Plan Explorer Paste option is never enabled within Plan XML pane context menu
3254 PA-Plan Explorer User exception received: "An error occurred while reading the plan xml: "
3263 PA-Plan Explorer Generic T-SQL icon shown for Hash Match (Aggregate) operator
     
Version 1.3 (Build 6.4.921.0)

Date: 21/OCT/2011

FEATURES:
ID Component Name
938 PA-Plan Explorer Show table-level I/O metrics for actual plans
993 PA-Plan Explorer Include table alias name in operator tooltips on plan diagram
995 PA-Plan Explorer SQL Server 2012 execution plan support
     
FIXES:    
ID Component Name
3213 PA-Plan Explorer Some SQL Server 2012 plans can generate errors
3224 PA-Plan Explorer Incorrect Duration and CPU values may be assigned to the last statement in multi-statement execution plans
3225 PA-Plan Explorer Descending is misspelled in the Sort tooltip of the plan diagram
3234 PA-Plan Explorer Only show Key Lookups and RID Lookups columns when there are lookups in the plan
3235 PA-Plan Explorer Estimated Execution Mode tooltip says True/False instead of Batch/Row
3236 PA-Plan Explorer Missing index warning icon does not show for cursor preparation calls
3237 PA-Plan Explorer Don't show Optimization Level in the tooltip unless it is defined
3238 PA-Plan Explorer Show cursor operation type instead of DECLARE CURSOR on cursor nodes
3239 PA-Plan Explorer Actual plans that use loops may not show every iteration of the same statement
3240 PA-Plan Explorer Add missing cursor operations like Population Query and Fetch Query
     
Version 1.2 (Build 6.2.39.0)

Date: 17/AUG/2011

FIXES:
ID Component Name
3188 PA-Plan Explorer Operation count columns are not always visible by default when there are corresponding operations
Version 1.2 (Build 6.2.37.0)

Date: 3/AUG/2011

FIXES:
ID Component Name
3174 PA-Plan Explorer Partitioning type shows "Broadcast" when no partitioning type exists in XML
3176 PA-Plan Explorer Some plans saved as .QueryAnalysis open but with error message
3177 PA-Plan Explorer Opening a plan through the activity monitor in SSMS can cause an error (requires the latest SSMS Add-in)
Version 1.2 (Build 6.2.34.0)

Date: 29/JUL/2011

FEATURES:

ID

Component

Name

917

PA-Plan Explorer

Version check capability for Plan Explorer

918 PA-Plan Explorer "Ordered" element for plan diagram tooltips
946 PA-Plan Explorer Support for Plan Explorer Add-in for SSMS query plans
954 PA-Plan Explorer Option to disable warning on Actual Plan collection
955 PA-Plan Explorer New theme for all grids
     
FIXES:
ID Component Name
3083 PA-Plan Explorer Selecting a statement in a nested stored procedure does not select exec statement in Text Data
3084 PA-Plan Explorer Nested stored procedures do not count operations correctly
3111 PA-Plan Explorer Actual plan values may be assigned to incorrect statements in multi-statement actual execution plans
3112 PA-Plan Explorer Saving an actual execution plan that was executed from an existing statement does not save actuals
3114 PA-Plan Explorer Self-referencing columns show up in Query Columns tab for Key Lookup operations
3115 PA-Plan Explorer Filters that are compared to a parameter may contain an extra space
3116 PA-Plan Explorer Table nodes show invalid tooltips on Join Diagram
3148 PA-Plan Explorer Repartition Streams icon incorrectly shows a Gather Streams icon
3149 PA-Plan Explorer Plans may incorrectly show estimated vs actual highlighting in plan grid views when there are no actuals available
3151 PA-Plan Explorer Expressions tab can show nested expressions as direct decendents
3173 PA-Plan Explorer When gathering an Actual Execution Plan, IO metrics may be incorrect
     
Version 1.2 (Build 6.1.34.0)

Date: 9/MAY/2011

FIXES:
ID Component Name
3082 PA-Plan Explorer User exception received: "An item with the same key has already been added"
Version 1.2 (Build 6.1.33.0)

Date: 2/MAY/2011

FIXES:
ID Component Name
3074 PA-Plan Explorer You may receive an "Object reference not set..." error when viewing certain plans
Version 1.2 (Build 6.1.32.0)

Date: 26/APR/2011

FEATURES:

ID

Component

Name

893

PA-Plan Explorer

Show “Output” column for INSERTs on Query Columns

     
FIXES:
ID Component Name
3063 PA-Plan Explorer You may receive an exception when saving a .queryanalysis file
3069 PA-Plan Explorer Batches with identical statements can be sorted incorrectly
3070 PA-Plan Explorer Actual plan collection will time out after 30 seconds
3071 PA-Plan Explorer You may receive an Out of Memory exception when opening a plan with self-referencing expressions
Version 1.2 (Build 6.1.28.0)

Date: 12/APR/2011

FEATURES:

ID

Component

Name

890

PA-Plan Explorer

Add Hash Match and Merge Join predicates to Filters column on Query Columns tab

891 PA-Plan Explorer Highlight both tables and join links on Join Diagram tab when a join operation is selected
     
FIXES:
ID Component Name
3054 PA-Plan Explorer Plan Explorer sets itself as the default file handler for .XML
3059 PA-Plan Explorer Statements that do not return rows are not shown when gathering an actual plan
Version 1.2 (Build 6.1.26.0)

Date: 8/APR/2011

FEATURES:

ID

Component

Name

884

PA-Plan Explorer

Join Diagram tab which shows graphical view of all joins

885 PA-Plan Explorer Show expressions for Stream Aggregate operators
886 PA-Plan Explorer Expressions tab which lists all expressions and references for a plan
887 PA-Plan Explorer Ability to retrieve actual plans and metrics from executed queries
888 PA-Plan Explorer Command Text tab to allow editing SQL for estimated and actual plan retrieval
889 PA-Plan Explorer Synchronize StmtSimple section in plan XML with the selected SQL statement
FIXES:    
ID Component Name
3014 PA-Plan Explorer User exception received: "An error occurred while reading the plan xml: There"
3028 PA-Plan Explorer Miscellaneous cleanup and fixes for plan diagram tooltips
3032 PA-Plan Explorer Statements that are not associated with a plan do not sort properly in Plan Explorer
3041 PA-Plan Explorer User exception received: "Arithmetic operation resulted in an overflow"
     
Version 1.1 (Build 6.0.99.0)

Date: 4/MAR/2011

FEATURES:

ID

Component

Name

860

General

Use ngen on Plan Explorer/SQL Sentry Console for better startup performance

Version 1.1 (Build 6.0.95.0)

Date: 2/MAR/2011

FIXES:

ID

Component

Name

2980

PA-Plan Explorer

Horizontal and Vertical layouts for Plan Explorer are reversed inside SQL Sentry

2965

PA-Plan Explorer

Regional settings are not fully obeyed

2984 PA-Plan Explorer User exception received: "Requested Clipboard operation did not succeed"
2999 PA-Plan Explorer Plan Explorer links can remain highlighted even when mouse is not over them
3004 PA-Plan Explorer Selecting the 'Display Estimated Execution Plan' button can cause an exception for certain plans
3007 PA-Plan Explorer Certain columns do not show valid data for Top Operations or Plan Tree
3009 PA-Plan Explorer User exception received: "Arithmetic operation resulted in an overflow"
Version 1.1 (Build 6.0.77.0)

Date: 13/JAN/2011

FIXES:

ID

Component

Name

2979

PA-Plan Explorer

Plan Diagram resets position when changing from estimated to actual mode or vice versa

2935

PA-Plan Explorer

User exception received: "Value was either too large or too small for an Int"

Version 1.1 (Build 6.0.76.0)

Date: 12/JAN/2011

FIXES:

ID

Component

Name

2969

PA-Plan Explorer

Cryptic error message when opening empty/invalid XML file

2970

PA-Plan Explorer

File type for XML files should be less specific

2972 PA-Plan Explorer If a plan contains only statements and no operations, nothing is shown
2976 PA-Plan Explorer User exception received: "The indicator is not allowed to be zero-length"
2977 PA-Plan Explorer Deleting text using context menu in Text Data editor does not put editor into Edit Mode
Version 1.1 (Build 6.0.68.0)

Date: 28/DEC/2010

FIXES:

ID

Component

Name

2963

PA-Plan Explorer

User exception received: "Value was either too small or too large for Int32"

2964

PA-Plan Explorer

User exception received: "The indicator is not allowed to be zero-length"

Version 1.1 (Build 6.0.67.0)

Date: 22/DEC/2010

FEATURES:

ID

Component

Name

794

PA-Plan Explorer

Add items that are opened in any way to recent file list

795

PA-Plan Explorer

Support pasting files via clipboard from shell

796

PA-Plan Explorer

Streamline Open File dialog filters

798

PA-Plan Explorer

Setup file associations for .xml files in the Plan Explorer

807

PA-Plan Explorer

Add Recent Files menu item under File menu

808

PA-Plan Explorer

Improve visual difference between edit and non-edit modes

821

PA-Plan Explorer

"Parameter List" tab which lists all statement parameters with runtime and compiled values

822

PA-Plan Explorer

Show "Reason for Early Termination" in statement node tooltip

823

PA-Plan Explorer

For parallel operations in actual plans, show rows processed by each thread on the Plan Tree tab

824

PA-Plan Explorer

Show expression names in Compute Scalar tooltips

 

 

 

FIXES:

 

 

ID

Component

Name

2897

PA-Plan Explorer

An exception occurs if a plan contains a conditional block where one of the nested children has no child statements

2900

PA-Plan Explorer

Paste option is available in SQL Editor if clipboard content is plan or file

2903

PA-Plan Explorer

Copying and pasting XML for an actual plan doesn't enable the "Show Estimated Plan" toolbar button

2904

PA-Plan Explorer

Actuals aren't used for operation highlighting when it's an actual plan

2905

PA-Plan Explorer

Plan does not always stay in sync with selected statement

2907

PA-Plan Explorer

Pasting plan xml while Text Data editor has focus doesn't change to read-only mode

2911

PA-Plan Explorer

When clicking the top row on Top Ops after loading a plan, it doesn’t auto-select the diagram node

2912

PA-Plan Explorer

The first time you load a file the file name is not displayed in the Title of the form

2914

PA-Plan Explorer

Don't show Plan/Query Info tab unless there are statistics

2915

PA-Plan Explorer

Statements that begin with an open parenthesis are not always matched

2921

PA-Plan Explorer

Enabling AlwaysInstallElevated for a User and System causes the Plan Explorer setup to fail reporting that the .NET Framework 4.0 is not installed

2925

PA-Plan Explorer

Right-clicking in text editor enables edit-mode

2944

PA-Plan Explorer

Don't show estimated plan collection button on SQL Server 2000

2949

PA-Plan Explorer

If a file is opened using the Open toolbar item, preferences can be reset

2950

PA-Plan Explorer

Miscellaneous tooltip and grid formatting updates

 

 

 

Version 1.0 (Build 6.0.29.0)

Date: 5/NOV/2010

FIXES:

ID

Component

Name

2884

PA-Plan Explorer

Costs by CPU and IO not calculating properly in all scenarios

Version .98 Beta (Build 6.0.22.0)

Date: 29/OCT/2010

FEATURES:

ID

Component

Name

788

PA-Plan Explorer

Add Estimated and Actual Executions columns to Plan Tree and Top Ops grids

789

PA-Plan Explorer

Show code for Compute Scalar operations in toolips on Plan Diagram

790

PA-Plan Explorer

Virtualize actual rows for statement nodes on Plan Diagram for operators that don't have this data

 

 

 

FIXES:

 

 

ID

Component

Name

2883

PA-Plan Explorer

Miscellaneous minor fixes and enhancements

 

 

 

Version .96 Beta (Build 6.0.19.0)

Date: 27/OCT/2010

FIXES:

ID

Component

Name

2880

PA-Plan Explorer

Plan XML tab doesn't update XML after loading new plan if a plan is already loaded

2881

PA-Plan Explorer

Estimated plans with procedures may generate a NullReferenceException

 

 

 

Version .96 Beta (Build 6.0.17.0)

Date: 26/OCT/2010

FIXES:

ID

Component

Name

2876

PA-Plan Explorer

Malformed XML shows exception reporter rather than a friendly message

 

 

 

Version .96 Beta (Build 6.0.15.0)

Date: 21/OCT/2010

FIXES:

ID

Component

Name

2875

PA-Plan Explorer

Estimated plans can show statements in the wrong place in the tree due to how statement nodes are stored in the plan xml

 

 

 

Version .96 Beta (Build 6.0.13.0)

Date: 21/OCT/2010

FIXES:

ID

Component

Name

2871

PA-Plan Explorer

SQL Server Connection Dialog doesn't enable text boxes when unchecking "Use Integrated Windows Authentication"

2872

PA-Plan Explorer

Authentication label is not wrapping properly in SQL Server Connection dialog

2873

PA-Plan Explorer

Backspace and delete keys do not change the text editor to edit mode