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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 tempdb

Author  Topic 

wided
Posting Yak Master

218 Posts

Posted - 2013-03-05 : 08:56:33

I have large database (MyDatabase).

The size of the tempdb database on the sql instance is 1GB.

Yesterday, he went at once to 6GB

that happened?

What should I do?





















visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-05 : 09:26:27
look for some uncommited long transactions.
If there are large batch operations try breaking them into small batches

Based on your level of restore needed, choose a different recovery model (simple) if possible.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

wided
Posting Yak Master

218 Posts

Posted - 2013-03-05 : 09:29:15

the mdf file that is passed to 6GB
and not the log file





















Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-05 : 09:33:26
yep...mdf will grow because tempdb may be used by some process for huge data manipulations
see

http://strictlysql.blogspot.in/2010/03/whats-causing-my-tempdb-to-grow-sql_17.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -