February 27, 2014 at 1:18 am
Hi,
Can anybody tell me what action should be taken if Temdb is full and how to investigate why tempdb became full.
Thanks and Regards,
Nikhil P Desai
February 27, 2014 at 1:46 am
Grow the file or add additional files on another drive if it filled as part of regular activity.
On SQL 2000 it's very hard to identify queries using TempDB, the DMVs added in 2005 make it a lot easier.
Look for queries/procedures with large temp tables and see if you can reduce or remove the temp table usage. Queries doing lots of sorts or hash joins/hash aggregates should be investigated, see if they can be tuned.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply