1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Aggressive Over Indexing

Discussion in 'Programming/Internet' started by Sunny, Oct 8, 2018.

  1. Sunny

    Sunny Guest

    I observed blokcing and time outs in one of our production server and there is prod outage to one of the application continuosly,

    When i run sp_BlitzIndex i got Aggressive Over-Indexing, ran script in more info script it didn't find any missing indexes,

    Aggressive Over-Indexing: Total lock wait time > 5 minutes (row + page) with long average waits

    The Create Table script contains below ALTER TABLE script..

    ALTER TABLE [schema].[table] ADD CONSTRAINT [Primary_Key_Index] PRIMARY KEY ( [ID] ) WITH (FILLFACTOR=90, ONLINE=?, SORT_IN_TEMPDB=?, DATA_COMPRESSION=?);

    In this table Primary Key is non clustered Index and Non_Clustered_Index is primary key Can any one suggest how do i clear this over indexing?

    Thanks a ton in Advance

    Login To add answer/comment
     

Share This Page