x

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.

more ▼

asked Jul 05 at 12:04 AM in Default

avatar image

Sagar Bhargava
638 25 28 34

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.

Jul 05 at 06:44 PM rvsc49
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x310
x150
x74

asked: Jul 05 at 12:04 AM

Seen: 41 times

Last Updated: Jul 05 at 06:44 PM

Copyright 2017 Redgate Software. Privacy Policy