View the query plan from 'slow query widget' in ADS

Susja 716

Hello,

I am continue to follow steps in https://video2.skills-academy.com/en-us/sql/azure-data-studio/tutorial-qds-sql-server?view=sql-server-ver16 and stuck at the point where need to analyze Query Plan.

I followed all steps in tutorial and now I opened 'Run Query' item from ellipses(...)

Could you please explain the steps that I should take to analyze Query plan from this widget at this point?

Thanks

User's image

ShaktiSingh-MSFT 14,276 Reputation points Microsoft Employee

2023-08-22T04:43:36.9533333+00:00

Hi
Susja •,

If the answer did not help, please add more context/follow-up question for it, and we will help you out. Else, if the answer helped, please click Accept answer so that it can help others in the community looking for help on similar topics.

2 answers

Vahid Ghafarpour 20,480 Reputation points

2023-08-19T03:55:56.9866667+00:00

There are plan icons in the ribbon that you can select based on the analysis you need
Please sign in to rate this answer.
Susja 716 Reputation points

2023-08-19T08:48:53.8166667+00:00

@Vahid Ghafarpour - Thanks for replying

I saw those icons in the ribbon

My point was different

In my case I have a list of 7 slow queries

I assume that each of it has its own Plan

Hence my point was how to select Plan for each of it

In my case when I select any of the query and then click on e.g. 'Estimated Plan' button I see the same Plan

Thanks
Sign in to comment
ShaktiSingh-MSFT 14,276 Reputation points Microsoft Employee

2023-08-21T03:56:59.6533333+00:00

Hi
Susja •,

Welcome to Microsoft Q&A forum.

We observed that you are not satisfied by the provided answer.

As we understand from the question, you want to analyze query plan in Azure Data Studio.

Here is the detailed video from official Microsoft Developer Youtube Channel which can help:

https://youtu.be/pMVLs9oAPmk

Let us know if you have any questions.

Thanks
Please sign in to rate this answer.
Oury Ba-MSFT 17,631 Reputation points Microsoft Employee

2023-08-22T23:41:50.9733333+00:00

Susja

Checking if the above reply from @ShaktiSingh-MSFT was helpful.

Regards,

Oury

Susja 716 Reputation points

2023-08-23T00:55:38.8733333+00:00

hi @Oury Ba-MSFT and @ShaktiSingh-MSFT

Thanks for you referenced link I browsed and it looks very helpful. I will watch it later in details.

Still my confusion is how could I map Plan to particular Results record. My point: in my case I have Results which consists of 7 records. I expect that I should select particular record and then analyze Plan. It looks to me that in my case ... whatever record I select Plan is the same ... maybe it's only my confusion.

Hence my general question is for selection of corresponding Plan: is it correct that user should select a row in Results and then start to play with Plan?

Thanks

ShaktiSingh-MSFT 14,276 Reputation points Microsoft Employee

2023-08-24T10:41:52.3266667+00:00

Hi Susja,

Thanks for the reply.

For such scenario-based explanation, we recommend you to raise support case if you have support plan to get better support over your questions.

In case, you don't have support plan, please let us know so that we can look for other options to unblock you.

Thanks

Susja 716 Reputation points

2023-08-26T11:18:48.73+00:00

@ShaktiSingh-MSFT I don’t have any support plan

Thanks

ShaktiSingh-MSFT 14,276 Reputation points Microsoft Employee

2023-08-28T05:43:51.5+00:00

Hi Susja,

Could you send an email to AzCommunity@Microsoft.com with your Subscription ID and thread link to this post, and I will enable a one-time free support request for your subscription.

Please reference this forum thread in the Email Subject:

ATTN: SHAKTI - View the query plan from 'slow query widget' in ADS

Regards,

@ShaktiSingh-MSFT
Sign in to comment

Share via

View the query plan from 'slow query widget' in ADS

2 answers