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 →
Issues with monitoring open transactions: Schema lock
By: Date: January 10, 2018 Categories: LCK_M_SCH_S,open transaction,Schema Lock,SQL Server

Monitoring open transactions is beneficial for the performance of a database. There are many nice SQL queries which show the locked objects but there might be some special situations where these queries do not work. They get blocked by the open transaction of another session. Such a scenario can occur when one of the sessions…

Read More →