sql server data warehouse: shrinking TEMPDB -- sql server data warehouse

shrinking TEMPDB

chris
8/29/2003 2:15:44 AM

try this

use tempdb
backup log tempdb WITH NO_LOG
dbcc shrinkfile (templog,0)
dbcc shrinkfile (tempdev,0)

templog is the name of log file and tempdev is the name
of the data file. Just check first these names in your
sysfiles.

Regards
[quoted text, click to view]

shrinking TEMPDB

mishel
8/29/2003 2:48:37 AM

thanks chris, but that's what we're doing right now. what
i would like to know, if there's a way to shrink the
tempdb while a query is running.

thanks again.

regards,
michelle

[quoted text, click to view]

Re: shrinking TEMPDB

Kevin
8/29/2003 3:18:33 PM

Generally heavy TEMPDB use is caused by very large sorts or joins. - check
for appropriate indexing to support the stored procedure.

--
Kevin Connell, MCDBA
--------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------
[quoted text, click to view]

Re: shrinking TEMPDB

Rob Anderson
8/29/2003 3:30:26 PM

What is happening in the query that is causing so much disk space to be
eaten up?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.