Queries With High Variation

In SSMS 17, the newly added Queries With High Variation report allows you to easily identify queries with parameterization problems. 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; due to the parameterization problem, the standard deviation will be high:

Queries With High Variation report

In productions systems, there are usually hundreds or thousands of stored procedures and parameterized queries. Use this view to identify quickly those with widely variant performance.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.15.168.214