Month: November 2018

A lightweight alternative to Query Store
By: Date: November 17, 2018 Categories: Query Store,SQL Server

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: 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 →