We are cloud DT / Saas. In the past I was never able to access our query execution plan. Now in pilot I can see that I can click the little running guy icon to export the plan. This downloads as a *.sqlplan file.
My question is, what is this? Can I do anything with it?
Thanks!
Nate
You can open up the file in SSMS (even if it’s not connected to anything) and see what it’s doing. You don’t have control of your server/indexes, so really you will only be able to decide if you should be including more fields in your joins, but that’s about it. Normally when you see something like a missing index, you can add something to help.
4 Likes
There is also nice alternative to SSMS - Sentry Plan Explorer.
4 Likes