Query Store Database Dashboard v1.3 released!

Next to releasing a new version of sp_WhatsupQueryStore, I just released the 1.3 version of the Query Store Database Dashboard! Release notes: Forced execution plan overview removed Instead you should use sp_WhatsupQueryStore to quickly analyse forced plans by running EXEC sp_WhatsupQueryStore @dbname = ‘your database’, @return_forced_plans = 1. You can download sp_WhatsupQueryStore through GitHub at […]

sp_WhatsupQueryStore v1.2 available

sp_WhatsupQueryStore v1.2 has just been released! In this new version additional parameters are added to control what information is returned and a change has been made to the information that is returned by default. Releasenotes: Changed what information is returned by default when no additional parameters are supplied. In the previous versions of sp_WhatsupQueryStore all […]

sp_WhatsupQueryStore version 1.1 released

Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are stored inside the SQL Server Query Store through an easy to use stored procedure. In version 1.1 many new optional parameters are added that influence the output of the stored procedure: – @return_store_config : show […]

Query Store changes in SQL Server vNext CPT1

Not only did we receive a brand new Service Pack for SQL Server 2016 this week, since yesterday we are able to play with the first Community Technology Preview (CTP) of SQL Server vNext! Since I adore the Query Store feature which was introduced in SQL Server 2016, a large portion of my time today […]

Query Store Instance Dashboard

Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t always directly available through the built-in Query Store reports. The dashboard I shared last week returns information on a per-database basis by right-clicking a database with the Query Store enabled and selecting the Query Store […]

DBCC CLONEDATABASE and sensitive data

Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is a new DBCC command, DBCC CLONEDATABASE. As the name suggest this command can be used to make a clone of your user database without the table data. Instead it creates a schema and statistics only […]