Is temp DB scalable in azure SQL DB

Question

I’m trying to bulk import a very large table (75G) into the azure SQL DB (pricing tier P6 premium 1000 DTUs), it failed with the following error message “Msg 40544, Level 17, State 2, Line 179 The database ‘tempdb’ has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.”

I looked up a few blogs where they are suggesting an increase in the tier. I was wondering if I could just scale up tempdb without having to increase the tier itself.

Right now I’m chunking up the file into smaller volumes to load it but if I have to build index on this table after loading, I’m pretty sure it would fail again with the same error message.

Any thoughts??

did you manage to solve this issue ? I am facing this in azure data factory. — Mandar Jogalekar
– Mandar Jogalekar, Commented Jun 6, 2021 at 12:42

Grant Fritchey · Accepted Answer · 2017-11-30 15:24:51Z

1

No. You have no direct control over TempDB and it's behavior. However, as you scale up your service tier, it's my understanding that your thresholds within TempDB also go up.

answered Nov 30, 2017 at 15:24

Grant Fritchey

2,84125 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is temp DB scalable in azure SQL DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related