tempdb using excessive space  
Author Message
englitchick





PostPosted: Tue Jan 27 08:23:59 CST 2004 Top

SQL Server >> tempdb using excessive space

For some reason I cannot figure out, our development db server's tempdb data
file has allocated nearly 14 GB of space.

Its mdf and ldf files live on the root drive, while others live on a
separate drive. I'd like to move them off and repoint the mdf/ldf files, but
first I want to know what could possible cause it to allocate so much space.
Our production servers, which emulate the database structure, have their
respective tempdb sizes at a more modest 800 MB.

Sorry if this comes off as a dumb question, but this isnt something I've
come across before. Thanks for your help.

--
Elliot M. Rodriguez, MCSD

My .Net blog, with tips here and there:
http://www.hide-link.com/

SQL Server299  
 
 
Aaron





PostPosted: Tue Jan 27 08:23:59 CST 2004 Top

SQL Server >> tempdb using excessive space > Its mdf and ldf files live on the root drive, while others live on a
> separate drive. I'd like to move them off and repoint the mdf/ldf files,
but
> first I want to know what could possible cause it to allocate so much
space.

http://www.aspfaq.com/2446

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


 
 
Elliot





PostPosted: Tue Jan 27 08:37:18 CST 2004 Top

SQL Server >> tempdb using excessive space Thanks, Aaron.

Our scenario only meets a few of the criteria - I'll go ahead and shrink adn
relocate the tables.

--
Elliot M. Rodriguez, MCSD

My .Net blog, with tips here and there:
http://derivedclass.europe.webmatrixhosting.net



> > Its mdf and ldf files live on the root drive, while others live on a
> > separate drive. I'd like to move them off and repoint the mdf/ldf files,
> but
> > first I want to know what could possible cause it to allocate so much
> space.
>
> http://www.aspfaq.com/2446
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>