What does it mean when Query Store Tracked Queries shows the same Plan Id twice?
-
I'm investigating a query which sometimes performs badly and, when I locate one of the query instances in Query Store and look at it with Tracked Queries, it shows the same Plan Id twice. What does this mean?
Obviously, I can't force a plan, since it's the same plan it's already using!
Derek
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
-
The square ones didn't complete
https://joeydantoni.com/2016/11/02/circles-and-squares-what-do-they-mean-in-the-query-store/
- Jo Pattyn wrote:
The square ones didn't complete
https://joeydantoni.com/2016/11/02/circles-and-squares-what-do-they-mean-in-the-query-store/
Interesting... you might want to let joey know. Some people will be able to see the site. I can't because my system has higher security than a lot of folks.
Secure Connection Failed
An error occurred during a connection to joeydantoni.com. PR_CONNECT_RESET_ERROR
Error code: PR_CONNECT_RESET_ERROR
The page you are trying to view cannot be shown because the authenticity of the received data could not be verified.
Please contact the website owners to inform them of this problem.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Here you go Jeff:
DBASupport
- cyrusbaratt wrote:
Here you go Jeff:
Thank you! That'll help others, as well as preventing future dead links.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
btw: If you hover over the icon, you’ll get an explanation of it
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply