question

Sagar Bhargava avatar image
Sagar Bhargava asked

Investigate Index usefulness

Hi, I have below 3 indexes on foreign keys in a table with the below stats captured with Brent's sp_blitzIndex. I am trying to figure if they are doing any good or just adding a maintenance overhead. Could you please provide any inputs around this? **Usage Stats** index 1 - Reads: 3,496,036 (3,495,890 seek 146 scan) Writes:36,723,454 index 2 - Reads: 1,926 (1,910 seek 16 scan) Writes:36,723,459 index 3 - Reads: 1,819,529 (1,819,529 seek) Writes:36,723,454 **Op Stats** index 1 - 4,914 singleton lookups; 415,868,223 scans/seeks; 0 deletes; 0 updates; index 2 - 88,419 singleton lookups; 90,106 scans/seeks; 0 deletes; 0 updates; index 3 - 0 singleton lookups; 0 scans/seeks; 0 deletes; 0 updates; **Lock Waits** index 1 - Lock escalation attempts: 318,167; Actual Escalations: 0. index 2 - Lock escalation attempts: 318,155; Actual Escalations: 0. index 3 - Lock escalation attempts: 18,557; Actual Escalations: 0. Regards.
performanceindexingperformance-tuning
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Brent and his dbas hang out over at https://dba.stackexchange.com/. I would repost this there and I bet they will respond very quickly.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.