The preview of the next version of SQL Server Management Studio is out, and it has a radical improvement to query plans that will shock and amaze you. It’s best to just show you:
You can see the estimated and actual number of rows right there on the query plan just like live query plans! You no longer have to waste hours of your life hovering over different parts of the query plan in order to see where the estimated row counts veer off from the actual row counts.
This doesn’t require SQL Server 2019, either.
I am fully prepared to call this the Best Management Studio Ever.
However, one could still look this gift prize-winning thoroughbred in the mouth and point out that it only works on actual plans, not estimates. (It’d be nice to see the estimates on estimated plans.)
Also, the readability on this is pretty bad, especially on large query plans. We desperately need commas to separate thousands and millions, and some color coding for variances would be kinda nice. Here’s a live view of me looking at a large plan and trying to figure out if there’s a variance between tons of large numbers: