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 ...
