SSMS: Improve Actual Plan window by adding a switch to show relative percent not by estimated cost, but by ActualElapsedms - by Dmitry Pilugin

Status : 

 


2
0
Sign in
to vote
ID 3118828 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 1/15/2017 11:08:20 PM
Access Restriction Public

Description

Very often people mistakenly treat cost percent in a query plan as a real metric to compare what operator caused a problem. However, this is just an estimate over a model. Now with having extended metrics for plan operators (like ActualElapsedms, ActualCPUms, etc.) it would be very nice to be able to switch to those real metrics in an actual plan to see more realistic picture.
Sign in to post a comment.