I also very much dislike that in both the ADS and SSMS plans, the index operation is cut off. My criticisms of how query plans are displayed are somewhat nit-picky, and I’d even wager that some people might disagree with me on how things should show up.įor example, i think it’s quite confusing that batch mode operators track time differently than row mode operators, and that there’s no real visual indication as to which operators use batch mode. nice fontĪside from slight variations in CPU timing, the plans are virtually identical. The only point here is that in this plan you can see parallelism more easily, and maybe that the operator icons aren’t quite as spiffy. I recently changed the font that my query plans use to one that’s a bit less offensive. Also, I like the highly accusatory, Snag-It style arrows here. It is cool that you can get the full properties of any of the operators, and that operator times are consistent with what SSMS shows. The arrow is just to point out the the plan does have parallelism engaged, but it is not shown anywhere (yet, I know, I know). Here’s what it looks like: clean and shiny If you enable the workbench editor enable preview setting, you can hit CTRL+M to get an actual execution plan. While I hear that a lot of improvements are on the to-do list, between whatever is going on internally along with the GitHub backlog, I have no idea what the timeline is for them. ![]() ![]() There’s some key stuff missing, like being able to hide query results, and plan operators don’t show parallelism yet. The pro here is that it looks like the query plan assets are much higher DPI than the ones in SSMS, but… I still can’t picture using it every day just yet. Since not having query plans available was one of my chief gripes about ADS, I figured this was a good time to install it. While I still don’t install Azure Data Studio by default, I heard recently from Erin Stellato ( t) that there’s a preview of real, live, actual execution plans out now. You may remember me from such hits as Make ADS An Optional Install Alongside SSMS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |