Skip to content

usp_AdaptiveIndexDefrag / Not working on very large tables #311

Open
@eliasbalasis

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.

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