Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
 Posted - 2010-12-23 : 06:04:34
|
Hi mates,this is a problem I can't understand and don't know what to do.The tempdb database_size AND unallocated space is growing and growing.SP_WHO2 isn't showing any blockings.DBCC opentran shows something about oldest distributed LSN (5788456:21789:4)oldest NOT distributed LSN (5788456:22223:1)but I don't know what that wants to tell me ...DBCC CHECKDB gives NO errors@@VERSION:Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) Our customer is now going to restart the whole box.Any ideas for future use?ThanksFred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-23 : 06:45:26
|
| Be interested to know if it does NOT return to initial size on Restart.I see posts here periodically about unexplained growth of TEMPDB (and failure to return to INIT size without intervention - e.g. starting SQLSERVER.EXE in single user and doing a SHRINK)So I kinda assumed that there are some bugs, and sometimes they happen and that's just life! |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-12-23 : 08:30:57
|
Before reboot the size of tempdb was about 40GB or more.After reboot the size of tempdb was about 11GB.Customer then has done a shrink (couldn't prevent that) and now the size is 1526.38 MB and the unallocated space (about 999 MB) is going up and down as expected...My question is:What is the reason for the increasing size of the temdb's mdf file without using the unallocated space?Sounds like a bug to me...This behaviour is IMHO a sql server internal problem and I can't imagine that an application which is using sql server should be blamed for that - right?ThanksFred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-23 : 08:59:51
|
| "Customer then has done a shrink (couldn't prevent that) "I hope they did it in Single User mode otherwise, my understanding, there is a risk of database [i.e. database other than TEMPDB] corruptionMight be worth doing DBCC CHECKDB across all databases just to be sure? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-12-23 : 09:23:21
|
I've already disconnected my remote connection to that customer and connected to another customer with another problem.But I am sure they shrinked before any database was in use by anyone...they are the dba's and I was involved only because they meant that our application has caused the problem...But I am still curious about the question:What is the reason for the increasing size of the temdb's mdf file without using the unallocated space?Maybe someone comes along who knows that problem and has a solution...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
tempdb database_size AND unallocated space growing