August 17, 2016 at 11:36 pm
Hi,
I checked the blocking history, and found that a lot of blockings on an index when the system tried to insert records to the table. Do you think if I disable this index, the blocking will be resolved immediately? Does it mean that if more indexes in the table, it will be easier to see blocking happening?
Thanks,
August 18, 2016 at 4:11 am
It means that while inserts/updates/deletes are occurring, the processing necessary to add/modify that data in that index is causing blocking of other processes. That's all. Based on this, we don't know if you have a problem or not. Are your queries around this index and this table running slow? Are there user complaints? Are these indexes necessary to support SELECT statements? You need to answer these questions. Treat anything in your database like the Chesterton Fence. If you can at least understand why it's there, what it's doing, and whether it's doing what was intended, then you can easily decide to remove it or not.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply