Elevate Performance across the Microsoft Data Platform

Fast resolution of performance issues. Actionable alerting, intuitive event management, and powerful performance analytics deliver fast and efficient database performance.

Get Started

"My only choice for SQL Server Performance Analysis"

Source: TrustRadius. The number one B2B software review site.

Available in the Azure Marketplace

Create an instance of SentryOne directly from the Azure Marketplace and easily monitor your SQL performance running in the cloud.

Visit the Azure Marketplace

is now...

Learn More

Plan Explorer - Change List

Features
ID Description
29093 Remove the 'Anonymize' Button from the Plan Explorer toolbar
32670 Update SSMS add-in to support v17
32713 Remove query text from operator tooltip
Fixes
ID Description
32239 Updated ScriptDom.dll needed to support SQL Server 2017
Features
ID Description
26656 Generate parameters representing literal values
29849 Support for New ShowPlanXML schema that arrived with SQL Server 2016 SP1.
30758 Update Index Management Message in PE
30775 Add Estimated Number of Rows to be Read to Tooltip
Fixes
ID Description
27141 Script button does not work if a cell outside of the Index column is selected
27678 Remove Table Scan operations from supported operations for Index Analysis
27779 Remove table valued functions from supported operations for Index Analysis
27781 Remove key lookup operations from supported operations for Index Analysis
27793 Exception: "Object reference not set to an instance of an object."
27933 Index Analysis incorrectly prefers include over key column when scoring indexes with certain properties
28023 Index analysis does not work with partitioned tables
28848 Script dialog does not always execute what is displayed in the script
29240 Statistics histogram chart for dates is rounding values and grouping them together
Fixes
ID Description
27690 Exception: "Sequence contains no elements"
27698 Exception: "The given key was not present in the dictionary"
27713 Exception: "Object reference not set to an instance of an object Intercerve.SqlServer.UI.QueryAnalysisViewOrchestrator..."
27762 Exception: "Object reference not set to an instance of an object Intercerve.SqlServer.UI.Plans.IndexAnalysisView ..."
27763 Exception: "Value cannot be null"
Features
ID Description
13933 Re-costing of actual plans
21299 Add 2016 ShowPlan icons and operators
27555 Provide full query call stack for actual plans (NOW FREE)
27556 Tabs for opening multiple Plan Explorer sessions (NOW FREE)
27557 Deadlocks can be viewed in Plan Explorer (NOW FREE)
27558 Save version history for actual and estimated plans (NOW FREE)
27559 Wait Stats information when collecting an actual plan (NOW FREE)
27560 Multiple layout options, including the ability to rotate, collapse, filter, and scale plans (NOW FREE)
27561 Live Query plan replay (NOW FREE)
27562 Live Query performance charts
27563 Index Analysis module
Fixes
ID Description
13911 UDF names may be missed when anonymizing plans
25181 The incorrect plan may be displayed when launching Plan Explorer from an Extended Events live data window
Fixes
ID Description
25025 Only the first plan is shown when using SSMS Add-in with multiple statements
Features
ID Description
973 Add paddles to both sides of layout control sliders
17146 Full support for anonymization and live query data
18313 Better handling of filtering large numbers of statements
18325 Maintain plan node selection of history entries as part of the state in .pesession file
20619 Support SSMS 2016 in the Plan Explorer Add-in
Fixes
ID Description
20097 Exception: "An item with the same key has already been added at PlanQueryProfile..."
20347 Inaccurate error message when canceling "Get Actual Plan" on offline server
21199 Exception: "Object reference not set to an instance of an object at Intercerve.SqlServer.Plans.PlanQueryProfileAggregateCosts..."
21387 Exception: "Index was out of range at System.Collections.ArrayList.get_Item"
Features
ID Description
16652 Compute Scalar operations with 0 cost will receive their row counts from upstream operations in live plans and plan replays
Fixes
ID Description
17380 Replay controls can disappear while scrubbing the playback line
17381 The "With Live Query Profile" checkbox displayed in the Get Actual Plan dropdown is dependent on the user preference setting when the tab was generated
17688 Completed statements continue to animate during replay playback for some statements
17793 Exception "The given key was not present in the dictionary"
17805 Exception "The wait completed due to an abandoned mutex"
Features
ID Description
10580 Live Query Plan Execution
13932 Live Query Plan Replay (PRO)
16657 Highlight excessive execution of user defined functions
Fixes
ID Description
16810 User exception received: "The wait completed due to an abandoned mutex"
Features
ID Description
4952 Disable animated line around selected diagram node
6541 Add "Paste Plan XML" context menu for the Plan XML window in PE
15339 Remove plan schema version restriction
Fixes
ID Description
6319 Statements which contain a where clause with a constant may not be linked correctly
7402 Identical operations in different trees can be combined on Query Columns grid
7931 Recent Files list is not updated if other plans are already open
9103 After opening a .sql file, text is displayed in the Text Data tab but not the Command Text tab
9662 Exception: "Object reference not set to an instance of an object at QueryAnalysisViewOrchestrator..."
Features
ID Description
13369 Support plan schema version 1.3
Features
ID Description
2588 Add Comment/Uncomment buttons to toolbar
3237 Restrict the number of trace rows returned to 1000
3305 Anonymize Command Text and Text Data
5346 Show partition columns in Plan Tree and tooltips
6082 Extract parameters from Command Text to populate runtime value for estimated plans
6899 Add Top Rows number to Top N sort tooltip
Fixes
ID Description
1488 Connector lines disappear when switching between statements in the Statement section of the Results tab
1486 No execution information or query plan collected for statement with insert to CTE
2097 Anonymized plans still show query details in Parameterized Text property
2616 Group By box can be shown for History grid, but is not usable
3416 Multiple optional columns yield class names instead of values
3434 Fix for opening plans with circular expression references
3766 Unable to generate plan for some queries with MERGE statement
3961 Exception when opening an .XML file from the Recent Files menu option if it has been deleted
4966 Null reference exception from QueryAnalysisViewOrchestrator
6297 Standard Copy commands are not available in the Table I/O tab
6304 Paste option is not enabled within context menu of several tabs
6305 Copy contents of certain columns yields class names
6326 Non-clustered index updates should be highlighted for heaps
8249 Remove unneeded decimals from PE Total Time column
8301 The interactive user is incorrectly displayed in the Login column for History entries in pesessions
Features
ID Description
153 SSMS Add-in bundled with Plan Explorer
347 Support SQL Server 2014 showplan attributes and operators
348 Show startup expressions in operators
Fixes
ID Description
132 User exception received: "System.Management.ManagementException: Not found"
744 Error message may be hidden from status bar
830 Parameterized Text is not being properly anonymized
935 Some Columnstore Updates are showing as Clustered Index Updates
3862 Save All command does not save plans loaded directly from the SSMS add-in
Fixes
ID Description
3741 User exception received: "Object reference not set to an instance of an object at Intercerve.SqlServer.UI.Plans..."
3884 User exception received: "Object reference not set to an instance of an object at DevExpress.XtraTreeList.TreeList..."
3914 User exception received: "Index 0 is out of range"
3919 User exception received: "Illegal operation attempted on a registry key that has been marked for deletion"
Fixes
ID Description
3794 Context menu of Plan Diagram for an Estimated Plan defaults to Actual Costs
Features
ID Description
1011 Customizable tab layout, to allow viewing the plan diagram and other query detail tabs simultaneously, etc
1198 Add "Copy Output List" context menu for scan and lookup nodes
1324 Provide distinct application names for PE query execution and trace connections
1336 Verify .NET Framework version at least RTM
1368 Optimize plan diagram animation behavior
Fixes
ID Description
3540 Long running queries that take a long time to return any data cannot be cancelled
3557 User exception received: "Index was outside the bounds of the array"
3626 Unable to copy/paste plan XML into PE integrated
3689 A number sign in the filename causes the filename to be truncated when a plan is downloaded from SQLPerformance.com
3705 "Preferences" dialog window in PE PRO doesn’t scale correctly when using custom DPI settings with Windows 8
3711 For plans with multiple statements the "Apply Embedded Layout Options" checkbox can stop functioning
3713 User exception received: "Access to the path 'C:\Program Files\SQL Sentry\..."
3716 User exception received: "Data at the root level is invalid. Line 71, position…"
3724 User exception received: "The victim-list start tag on line 1 position 19"
3741 User exception received: "Object reference not set to an instance of an object at Intercerve.SqlServer.UI.Plans..."
3750 User exception received: "Object reference not set to an instance of an object. at DevExpress.XtraBars.Docking..."
3768 User exception received: "Object reference not set to an instance of an object. at Intercerve.SqlServer.UI.SqlTextEditor..."
3771 User exception received: "xmlDocument does not contain a deadlock-list element"
3838 Table I/O tab does not show data in PE for some cultures
3852 Partition Id shows incorrect value
3861 Saving a dirty .pesession file brings up extra dialog and prompt
3872 Save message box may not prompt with the original file name
Features
ID Description
1286 Persist closing the plan layout toolbar (PRO)
Fixes
ID Description
3712 User exception received: "An error occurred while reading the plan xml"
Features
ID Description
1300 Add a default link style user preference (PRO)
1301 Add Seek Predicate to the tooltip and gridview of the Index Spool operation
1302 Add Top Expression and Tie Columns to the tooltip of the Top operation
Fixes
ID Description
3709 Using the anonymize button with a customized control layout may cause an exception
Fixes
ID Description
3704 The incorrect node may gain active focus when navigating between the Plan Diagram and Plan Tree tabs
Features
ID Description
1223 Add history entry when pasting plan XML into Plan XML tab (PRO)
1279 Option to anonymize plans before upload to SQLPerformance.com
1288 Dynamically auto-fit plan diagrams (PRO)
Fixes
ID Description
3700 Plan with selective XML index can't be opened
3701 Customized layout state may not be maintained during Plan Upload
3702 User exception received: "Key not valid for use in specified state"
Features
ID Description
1271 Plan operation filtering (PRO)
1272 Collapsible plan subtrees (PRO)
1273 Multiple plan layout modes (PRO)
1274 Ability to rotate plans (PRO)
1275 Adjustable plan height and width (PRO)
1276 "Angled" node link style option (PRO)
1277 Plan scale slider (PRO)
Fixes
ID Description
3686 No plan displayed when .sqlplan files opened directly in SSMS using Plan Explorer Add-In
Features
ID Description
1251 SQLPerformance.com query plan upload integration
Fixes
ID Description
3588 Show Estimated Plan button can get out of sync (PRO)
3633 Right-click, Open With > Plan Explorer does not work for deadlock .XDL files
3650 Opening a .queryanalysis or .sqlplan in PE PRO marks the file as modified and incorrect tab text is displayed
3654 Display text in Command Text tab when opening a .sql file
3664 Fixed incompatibility with opening initial version of the .queryanalysis file type
3668 Plans marked as modified while navigating to and from tabs
3669 When opening a .pesession file with PE free from windows file explorer, the version selector is not displayed
Fixes
ID Description
3615 Activation fails if FIPS compliance is enabled
Fixes
ID Description
3589 Inaccurate row estimates for plans with residual predicates applied to lookups in 2008+
3605 User exception received: "Cannot create a file when that file already exists"
3608 When gathering actual plans, an XEvent session may be left orphaned (PRO)
3609 Wait Stats can get dropped in SQL Server 2012 (PRO)
Fixes
ID Description
3586 Output columns may show incorrect information in Query Columns tab for some top level operations
3588 Show Estimated Plan button can get out of sync (PRO)
3592 User exception received: "Object reference not set to an instance of an object" (PRO)
3596 Multiple executions of code inside a T-SQL loop are not retained in queryanalysis file
Features
ID Description
1197 Add DOP as column in Statements Tree view
1202 Trim tab text in the middle to prevent overly long tabs (PRO)
Fixes
ID Description
3702 User exception received: "Key not valid for use in specified state"
3574 Status bar statistics show abnormally low values for duration when Wait Stats tab is selected
3578 Plan Explorer may not always yield an actual execution plan for statements that are auto-parameterized (PRO)
3584 Actual plan details may return incorrect row counts (PRO)
Features
ID Description
1187 Integration of SSMS Add-in (new version 2.0) with Plan Explorer
Fixes
ID Description
3557 User exception received: "Index was outside the bounds of the array"
Fixes
ID Description
3553 Plans with query text longer than 3800 chars can sometimes be missed
Features
ID Description
929 Grid copy options for Statements Tree tab
997 Support for new operation types in SQL Server 2012
1025 Enhancements to SELECT operator properties for SQL Server 2012 plans
1179 Wait Stats information when collecting an actual plan (PRO)
1180 Save version history for actual and estimated plans (PRO)
1181 Deadlocks can be viewed in Plan Explorer (PRO)
1182 Tabs for opening multiple Plan Explorer sessions (PRO)
1183 Provide full query call stack for actual plans (PRO)
Fixes
ID Description
3525 Gathering an actual execution plan for a batch that doesn't return rows cannot be cancelled
Features
ID Description
879 Grid copy options for Statements Tree tab
941 Support for new operation types in SQL Server 2012
Fixes
ID Description
3266 Captured statements that use CTEs may not be correctly associated with statements in the corresponding plan
3292 Parameters tab does not show for some plans
3312 Not all filters are listed on the Query Parameters tab
3371 User exception received: "Sequence contains no elements"
Features
ID Description
1016 Include partition information available in actual plans
1063 SQL 2012 support for the Plan Explorer add-in (as of 3/20/12)
Fixes
ID Description
3288 GO <int> parsing is case sensitive
3289 SQL Server 2012 parsing requires updated ScriptDom
Fixes
ID Description
3285 User exception received: "Object reference not set to an instance of an object"
Features
ID Description
902 File > Save As in addition to File > Save
996 Allow multiple batch execution via GO T-SQL command
1007 Show non-clustered index details for narrow DML plans
Fixes
ID Description
3242 Compute scalars may show zero cost when showing line widths by data size
3243 Paste option is never enabled within Plan XML pane context menu
3254 User exception received: "An error occurred while reading the plan xml: "
3263 Generic T-SQL icon shown for Hash Match (Aggregate) operator
Features
ID Description
938 Show table-level I/O metrics for actual plans
993 Include table alias name in operator tooltips on plan diagram
995 SQL Server 2012 execution plan support
Fixes
ID Description
3213 Some SQL Server 2012 plans can generate errors
3224 Incorrect Duration and CPU values may be assigned to the last statement in multi-statement execution plans
3225 Descending is misspelled in the Sort tooltip of the plan diagram
3234 Only show Key Lookups and RID Lookups columns when there are lookups in the plan
3235 Estimated Execution Mode tooltip says True/False instead of Batch/Row
3236 Missing index warning icon does not show for cursor preparation calls
3237 Restrict the number of trace rows returned to 1000
3238 Show cursor operation type instead of DECLARE CURSOR on cursor nodes
3239 Actual plans that use loops may not show every iteration of the same statement
3240 Add missing cursor operations like Population Query and Fetch Query
Fixes
ID Description
3188 Operation count columns are not always visible by default when there are corresponding operations
Fixes
ID Description
3174 Partitioning type shows "Broadcast" when no partitioning type exists in XML
3176 Some plans saved as .QueryAnalysis open but with error message
3177 Opening a plan through the activity monitor in SSMS can cause an error (requires the latest SSMS Add-in)
Features
ID Description
917 Version check capability for Plan Explorer
918 "Ordered" element for plan diagram tooltips
946 Support for Plan Explorer Add-in for SSMS query plans
954 Option to disable warning on Actual Plan collection
955 New theme for all grids
Fixes
ID Description
3083 Selecting a statement in a nested stored procedure does not select exec statement in Text Data
3084 Nested stored procedures do not count operations correctly
3111 Actual plan values may be assigned to incorrect statements in multi-statement actual execution plans
3112 Saving an actual execution plan that was executed from an existing statement does not save actuals
3114 Self-referencing columns show up in Query Columns tab for Key Lookup operations
3115 Filters that are compared to a parameter may contain an extra space
3116 Table nodes show invalid tooltips on Join Diagram
3148 Repartition Streams icon incorrectly shows a Gather Streams icon
3149 Plans may incorrectly show estimated vs actual highlighting in plan grid views when there are no actuals available
3151 Expressions tab can show nested expressions as direct decendents
3173 When gathering an Actual Execution Plan, IO metrics may be incorrect
Fixes
ID Description
3082 User exception received: "An item with the same key has already been added"
Fixes
ID Description
3074 You may receive an "Object reference not set..." error when viewing certain plans
Features
ID Description
893 Show “Output” column for INSERTs on Query Columns
Fixes
ID Description
3063 You may receive an exception when saving a .queryanalysis file
3069 Batches with identical statements can be sorted incorrectly
3070 Actual plan collection will time out after 30 seconds
3071 You may receive an Out of Memory exception when opening a plan with self-referencing expressions
Features
ID Description
890 Add Hash Match and Merge Join predicates to Filters column on Query Columns tab
891 Highlight both tables and join links on Join Diagram tab when a join operation is selected
Fixes
ID Description
3054 Plan Explorer sets itself as the default file handler for .XML
3059 Statements that do not return rows are not shown when gathering an actual plan
Features
ID Description
884 Join Diagram tab which shows graphical view of all joins
885 Show expressions for Stream Aggregate operators
886 Expressions tab which lists all expressions and references for a plan
887 Ability to retrieve actual plans and metrics from executed queries
888 Command Text tab to allow editing SQL for estimated and actual plan retrieval
889 Synchronize StmtSimple section in plan XML with the selected SQL statement
Fixes
ID Description
3014 User exception received: "An error occurred while reading the plan xml: There"
3028 Miscellaneous cleanup and fixes for plan diagram tooltips
3032 Statements that are not associated with a plan do not sort properly in Plan Explorer
3041 User exception received: "Arithmetic operation resulted in an overflow"
Features
ID Description
860 Use ngen on Plan Explorer/SQL Sentry Console for better startup performance
Fixes
ID Description
2980 Horizontal and Vertical layouts for Plan Explorer are reversed inside SQL Sentry
2965 Regional settings are not fully obeyed
2984 User exception received: "Requested Clipboard operation did not succeed"
2999 Plan Explorer links can remain highlighted even when mouse is not over them
3004 Selecting the 'Display Estimated Execution Plan' button can cause an exception for certain plans
3007 Certain columns do not show valid data for Top Operations or Plan Tree
3009 User exception received: "Arithmetic operation resulted in an overflow"
Fixes
ID Description
2979 Plan Diagram resets position when changing from estimated to actual mode or vice versa
2935 User exception received: "Value was either too large or too small for an Int"
Fixes
ID Description
2969 Cryptic error message when opening empty/invalid XML file
2970 File type for XML files should be less specific
2972 If a plan contains only statements and no operations, nothing is shown
2976 User exception received: "The indicator is not allowed to be zero-length"
2977 Deleting text using context menu in Text Data editor does not put editor into Edit Mode
Fixes
ID Description
2963 User exception received: "Value was either too small or too large for Int32"
Features
ID Description
794 Add items that are opened in any way to recent file list
795 Support pasting files via clipboard from shell
796 Streamline Open File dialog filters
798 Setup file associations for .xml files in the Plan Explorer
807 Add Recent Files menu item under File menu
808 Improve visual difference between edit and non-edit modes
821 "Parameter List" tab which lists all statement parameters with runtime and compiled values
822 Show "Reason for Early Termination" in statement node tooltip
823 For parallel operations in actual plans, show rows processed by each thread on the Plan Tree tab
824 Show expression names in Compute Scalar tooltips
Fixes
ID Description
2897 An exception occurs if a plan contains a conditional block where one of the nested children has no child statements
2900 Paste option is available in SQL Editor if clipboard content is plan or file
2903 Copying and pasting XML for an actual plan doesn't enable the "Show Estimated Plan" toolbar button
2904 Actuals aren't used for operation highlighting when it's an actual plan
2905 Plan does not always stay in sync with selected statement
2907 Pasting plan xml while Text Data editor has focus doesn't change to read-only mode
2911 When clicking the top row on Top Ops after loading a plan, it doesn’t auto-select the diagram node
2912 The first time you load a file the file name is not displayed in the Title of the form
2914 Don't show Plan/Query Info tab unless there are statistics
2915 Statements that begin with an open parenthesis are not always matched
2921 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 Right-clicking in text editor enables edit-mode
2944 Don't show estimated plan collection button on SQL Server 2000
2949 If a file is opened using the Open toolbar item, preferences can be reset
2950 Miscellaneous tooltip and grid formatting updates
Fixes
ID Description
2884 Costs by CPU and IO not calculating properly in all scenarios
Features
ID Description
788 Add Estimated and Actual Executions columns to Plan Tree and Top Ops grids
789 Show code for Compute Scalar operations in toolips on Plan Diagram
790 Virtualize actual rows for statement nodes on Plan Diagram for operators that don't have this data
Fixes
ID Description
2883 Miscellaneous minor fixes and enhancements
Fixes
ID Description
2880 Plan XML tab doesn't update XML after loading new plan if a plan is already loaded
2881 Estimated plans with procedures may generate a NullReferenceException
Fixes
ID Description
2876 Malformed XML shows exception reporter rather than a friendly message
Fixes
ID Description
2871 SQL Server Connection Dialog doesn't enable text boxes when unchecking "Use Integrated Windows Authentication"
2872 Authentication label is not wrapping properly in SQL Server Connection dialog
2873 Backspace and delete keys do not change the text editor to edit mode
Fixes
ID Description
2875 Estimated plans can show statements in the wrong place in the tree due to how statement nodes are stored in the plan xml

LOOKS LIKE YOUR BROWSER IS OUT OF DATE

For your convenience here are links to supported browsers:

Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.

Don't show this again