Category: Query Store

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