Hi MyDoggieJessie, thank you for giving such a wonderfull information for finding potential index already exists in database. Mr.Brent Ozar's, sp_BlitzIndex - it is very useful for find idex issues.

Aggressive Indexes: Recent Contention Information, there is one PK clustered index took too high

Reads: 291,840 (256,852 seek 2,138 scan 32,850 lookup) Writes:13,936

Row lock waits: 3; total duration: 10 minutes; avg duration: 3 minutes; Lock escalation attempts: 1,172; Actual Escalations: 0.

Could you suggestion me, how to reduce the total duration 10 minutes?

Thanks

ananda