Skip to content

usp_AdaptiveIndexDefrag / Not working on very large tables #311

Description

@eliasbalasis

It was suggested to me that the solution does not require applications downtime.

However it does not seem to be working well in Azure SQL and databases with tables having more than 1 billion of small length records (often more than 2 billion)

The process takes too long to complete the reorganization of indexes, more than a few days.
By the time this finishes the tables are fragmented again.

EXEC dbo.usp_AdaptiveIndexDefrag
@Exec_Print=1 ,
@printCmds=1 ,
@rebuildThreshold=100 ,
@rebuildThreshold_cs=100 ,
@updateStats=1 ,
@scanMode = 'LIMITED' ,
@onlineRebuild=1 ,
@minFragmentation=5 ,
@debugMode = 1 ,
@timeLimit=2880

There is also a suspicion that the tool is responsible for deadlock conditions during its run.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions