How can we improve Azure SQL Database?

Exempt all system functions from DTU limits

Even on our P4 database I cannot rebuild indexes on a 5gb table without the operation running absurdly slowly - and killing production. Currently I have to upgrade to at least a P11 just to do standard index maintenance! The quickest solution might be to allow system maintenance functions like this to run outside the DTU limit - even if they also incur a (modest) additional charge. On S3 I cannot even begin to do these things. Short of a complete revamp of the DTU system, exempting system functions from the limits would be a good thing.

14 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
jrstern shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base