I've mentioned a set of DMV queries that I use in a previous post on this blog. I've been chopping and changing the base set of queries for quite a while to suit my needs.
I have also written a series of posts describing how to perform index and statistics maintenance on a SQL Server's databases without losing the very important index stats that the queries mentioned above return.
So, in this post I will show you how I've modified a few of the index focused DMV queries to include the maintenance tables where I now store the cumulative index statistics.
I'm keeping this blog as a repository for SQL tips and tricks I have learned over my time working with SQL Server.
Showing posts with label index. Show all posts
Showing posts with label index. Show all posts
Sunday, 18 August 2013
Monday, 18 March 2013
SQL Server 2005+ Performance Tuning - Part 2
In my last post I covered the reasons for poor performance and the ways of pinpointing performance bottlenecks.
In this post I will detail some of the ways of resolving those performance bottlenecks.
Thursday, 14 March 2013
SQL Server 2005+ Performance Tuning - Part 1
Subscribe to:
Posts (Atom)