The aim of this post is to present a lightweight alternative to the SQL Server Query Store. You can find the full code on my Github Page here: https://github.com/bbalazs83/SQL-Server-Query-Statistics With a heavy adhoc workload and a lot of parsing, query store can cause major memory bottlenecks by consuming a lot of MEMORYCLERK_QUERYDISKSTORE_HASHMAP memory. Although there…
Read More →