SQL Server Performance Forum – Threads Archive

tempdb issues

I’ve been having a lot of problems with tempdb getting very large lately. I’ve never had these issues in the past and I’m not really doing anything out of the ordinary. For instance, tempdb was just at about 16 gigs and I had to stop and restart sql to get it back down. Right after, I did an insert of about 2.5 million records from one table to another table. I didn’t use any sorting or anything….just straight insert. I can see the t-log getting huge on the database in question, but tempdb went back up to 3.5 gigs (data file, not log). Once it completed, it didn’t go back down. Any ideas? Thanks,
Chris

Hi,
here is a llink containing the resource on tempdb size & gaining control over it ,
http://support.microsoft.com/default.aspx/kb/307487
http://support.microsoft.com/default.aspx?scid=kb;en-us;110139
Regarads. hsGoswami
[email protected]

Tempdb only get down via shink or stop and restart SQL.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Any clue why an insert statement into another database with no ordering would cause it to blow up though? Chris

Have you checked execution plan, may try post sample of the statement for fine tuning. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>