Query store runtime stats : variation

sakuraime 2,316

anyone knows the formula for the following highlighted ?

YufeiShao-msft 7,056 Reputation points

2021-10-26T08:00:19.977+00:00

Could you please validate all the answers so far and provide any update?
If all of them are not working or helpful, please provide more sample data or details about your issue.
Please remember to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

1 answer

YufeiShao-msft 7,056 Reputation points

2021-10-06T09:42:14.017+00:00

Hi @sakuraime ,

This is about the value of the queries with high variation
Analyze queries with high-execution variation as it relates to any of the available dimensions, such as Duration, in the desired time interval.
When a query has parameterization problems, there is a high variation in query execution. Sometimes the query runs well and very fast, sometimes the query will be very slow. Query Store keeps track of the standard deviation of query execution
Please sign in to rate this answer.
sakuraime 2,316 Reputation points

2021-10-06T10:01:57.293+00:00

what's the formula ?

YufeiShao-msft 7,056 Reputation points

2021-10-07T07:27:50.197+00:00

no formula, when you open the queries with high variation, and choose Metric: Duration(ms) Based on: variation, the bar chart will then show variation duration(ms)

sakuraime 2,316 Reputation points

2021-10-08T07:05:09.043+00:00

no formula ? So how can I know what this value is going to compare with ?

YufeiShao-msft 7,056 Reputation points

2021-10-18T07:39:12.043+00:00

the queries with high variation, All the icons inside are analyzing this parameter, in productions systems, there are usually hundreds or thousands of stored procedures and parameterized queries. Use this view to identify.

so what you can use this view directly to compare

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

YufeiShao-msft 7,056 Reputation points

2021-10-28T09:37:55.567+00:00

If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.
Sign in to comment

Query store runtime stats : variation

1 answer

so what you can use this view directly to compare