question

sakuraime avatar image
0 Votes"
sakuraime asked Yufeishao-msft commented

Query store runtime stats : variation

anyone knows the formula for the following highlighted ?

138074-image.png


sql-server-general
image.png (29.9 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

1 Answer

Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered Yufeishao-msft commented

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

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

what's the formula ?

0 Votes 0 ·

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)

0 Votes 0 ·

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

0 Votes 0 ·
Show more comments