Azure sql database rebuild index never end

sakuraime 2,316 Reputation points
2021-03-08T03:02:22.917+00:00

I have a index around 8GB size , Clustered Index and rebuild with the default option .
And here using Standard 100DTU tier ..

I takes me now more than 30MINS !!!!!!! and seems need to take more .... .

There is nothing block behind

May I know is it real ??

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-03-09T03:01:04.013+00:00

    @sakuraime Thank you for reaching out.
    The time taken for rebuilding indexes depends on the size of the index and available compute (DTU's).
    Azure SQL tries to rebuild the index in a way that utilizes minimal system resources while allowing read/write operations on the table.

    With Azure SQL Database, you don't need to do rebuild indexes frequently unless you see an extremely high fragmentation.
    We have provided more details on this post.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    0 comments