Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

usp_AdaptiveIndexDefrag / Not working on very large tables #311

Open
eliasbalasis opened this issue Jul 5, 2024 · 0 comments
Open

usp_AdaptiveIndexDefrag / Not working on very large tables #311

eliasbalasis opened this issue Jul 5, 2024 · 0 comments

Comments

@eliasbalasis
Copy link

eliasbalasis commented Jul 5, 2024

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.

@eliasbalasis eliasbalasis changed the title Not working on large databases Not working on very large tables Aug 19, 2024
@eliasbalasis eliasbalasis changed the title Not working on very large tables usp_AdaptiveIndexDefrag / Not working on very large tables Aug 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant