Shrinking TempDB (SQL2k)

[compuveg]

I know that Microsoft lists 3 way to shrink a tempdb...

http://support.microsoft.com/Default.aspx?id=307487

But these aren't working. I don't get errors, but the 2 data files that make up the tempdb don't get smaller. The 2 temp logs are the right size though, so I think I'm doing it right.

Is it that the IIS App's locking the tempdb? It doesn't show anything using the tempdb in 'process info', but since these are system processes I wondered if it would ever show tempdb as being in use.

Method 2 from Microsoft's page above is the method I'm trying...

sp_spaceused @updateusage=true
dbcc shrinkdatabase (tempdb, 5)

Results in....


database_name database_size unallocated space
-------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------
tempdb 3394.44 MB 3389.63 MB


reserved data index_size unused
------------------ ------------------ ------------------ ------------------
1088 KB 464 KB 448 KB 176 KB
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

 

[mrdenny]

When you use the DBCC SHRINKFILE command was information is given in the messages tab?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[compuveg]

Yes, I had results return in text so I'd get them all with the results...

Here's just the results...

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

... No errors. I'm just going to have to break down and go in after hours and fix the thing.

 

[SQLBill]

What size is your Model database? When you rebuild Tempdb, it builds it with the size, etc of the Model database.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875