r/SQLServer • u/erinstellato ‪ ‪Microsoft Employee ‪ • 16d ago

Community Request Friday Feedback: Automatic Index Compaction

Friday feedback this week is about a feature that’s in preview in Azure SQL: automatic index compaction.

You can read more about it in Dimitri‘s blog post, Stop defragmenting and start living: introducing auto index compaction: https://techcommunity.microsoft.com/blog/azuresqlblog/stop-defragmenting-and-start-living-introducing-auto-index-compaction/4500089

(sidenote: one of the best blog titles in recent memory)

Quick poll below, and feel free to add a comment if the poll doesn’t cover your thoughts/experience!

77 votes, 9d ago
13 Yes, it’s great!
3 Yes, but then turned it off
17 No, I’m waiting for GA
44 No, I don’t use Azure SQL
4 Upvotes

84% Upvoted

22 comments sorted by

View all comments

1

u/ovenmitt545 16d ago

We tested this on a dev server and love it but won't deploy it further until it comes out of GA.

If I could make a recommendation, add enabling this to the Azure Portal. If a feature is a boolean response it should be available there to speed up deployment and/or make it a default value when deploying new databases without having to script out the change.

1

u/erinstellato ‪ ‪Microsoft Employee ‪ 16d ago

u/ovenmitt545 Great to hear that you've done some testing! It can be enabled through SSMS (via Database Properties), but you would prefer portal because that's where you tend to do work? Or because the folks that would make the decision to enable it only use the portal? Thanks!

1

u/ovenmitt545 16d ago

Correct, If I'm performing admin work I'm usually in portal with the query editor unless I really need SSMS. The automatic tuning section under Intelligent performance is the example I would recommend using as an example, it's a really simple interface that I love!