• Adam Thurgar

Query store


Whilst investigating performance issues on a SQL Server 2017 instance, I had made some recommendations to hopefully alleviate the issue. They worked, but in the back of my mind I was a bit disappointed as I wanted to enable query store on this database and use this feature. I am now trying to convince them that enabling query store will help them troubleshoot issues in the future. Maybe I want to make it as part of my best practices on critical databases.

I would need to look at the configuration parameters especially the default for capture mode to make sure it is not impacting performance.

https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store?view=sql-server-2017


8 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t