In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts are the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 – Index Usage Index … Continue reading Index Black Ops Part 5 – Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 – Index Usage … Continue reading Index Black Ops Part 4 – Index Overhead and Maintenance
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part … Continue reading Index Black Ops Part 3 – Index Usage
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 … Continue reading Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the information that the DMV contains. In this post, we are going to look at the locking and blocking columns. Base Columns Before we jump over to the meat and potatoes, let's first take a look at … Continue reading Index Black Ops Part 1 – Locks and Blocking
Here we are with another T-SQL Tuesday and time for my entry into the fray. This month we are talking about indexes. This is great timing because I’ve been meaning to write about indexes for a while. A few months back I had outlined a number of articles I wanted to write and have been … Continue reading An Index on Indexing #TSQL2sDay
Today started with some quality time getting to know a deadlock that had occurred. While working through the deadlock, I noticed that there were a number of foreign key relationships that weren't indexed on the parent side of the relationship. I am going to skip over the why to index foreign keys and save that … Continue reading Index Those Foreign Keys
A while back I put together a number of posts around an index analysis query that I had put together to assist when I go out to clients. If you are interested, the background for the query can be found in the following posts: Analyze Your Indexes Part 1 Analyze Your Indexes Part 2 Analyze … Continue reading Analyzing Your Indexes with a Custom Report
Occasionally, I need to determine where index hotspots are located within databases. To do this, I use the DMV sys.dm_db_index_operational_stats. I’ve talked about this DMV before while I was going through the index analysis blogs posts. This DMV returns locking and blocking information for tables and indexes in the database. This information is aggregated since … Continue reading Snapshots of Index Contention
This is the sixth and last for now post in which I’m going through a query that can be used to analyze indexes. Thus far the following has been added to the query: Combine existing index statistics and missing indexes into a single output Find existing duplicate and overlapping indexes Find the relationship between indexes … Continue reading Analyze This – Analyze Your Indexes – Part 6
Strate SQL 