When originally setting up Temp db.....
I give it a size container of 8MB, with autogrowth of 2 MB, unlimited...total size of drive is 20 MB
Actual size of tempdb at first is 3 MB
My question: When the temp db is triggered to grow by 2 MB...does the original container of 8MB goto 10 MB ?...or will the actual tempdb grow from 3 to 5 MB ? ...and only extend past the original container of 8 MB, when the actual temp db is that big ?
I ask because, Im getting messages that my disk is almost full, but I can see that the tempdb is not even close to the hypothetical 20 MB, but my container has grown from 8 to 19 MB