SUM(total_worker_time) AS sort_order, -queries burning up CPU SUM(total_logical_reads) AS sort_order, -queries reading data (SELECT TOP 10 query_hash, statement_start_offset, statement_end_offset,ĬOUNT(query_hash) AS sort_order, -queries with the most plans in cache Run this query to tell your developers which queries are involved: You could fix this by changing the application so that it uses parameterized SQL instead of strings. SQL ConstantCare® suggests forced parameterization when we see that you have a ton of these over time, and can’t keep plans in the cache as a result.You can do EXEC sp_BlitzCache = ‘query hash’ to find the queries to focus on, too.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |