August 25, 2011 at 1:03 pm
SQL 2008 64-bit.
Have been having a problem where the inital size of tempdb is changing. What would cause this? I have never seen the intial size change on it's own before but am somewhat new to SQL2k8.
Here is a brief partial history:
initial size--------physical db size--------date
21GB------------ 21.3GB------------6/16
22.09GB----------? forgot to get-----6/17
22.2GB-----------? forgot to get-----6/27
25.012-----------? forgot to get-----7/15
10MB-------------Resized initial------8/17
3894MB-----------25GB--------------8/24
10GB -------------Resized intial-------8/25
I up'd the intial size as I have some large reindexes that run.
What in the world is causing the intial to dynamically resize itself?
Model initial size is 2MB
:w00t::w00t:
Thanks
August 25, 2011 at 1:18 pm
query(s) that use temp tables?
August 25, 2011 at 2:21 pm
Yes lots of queries that use temp table. The problem is the INITIAL size in changing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply