Top SQL Server Tools

templog

Asked 2/1/2012 1:35:29 PM by adveet

Hi!!

Its related to tempdb log file grow

we observered that templog is growing fastly,

to get more ,we ran dbcc open tran but we found there is no active open transaction , all session id 's are in sleeping

but customer is complaning its gowing, and it was really growing,

could you please tell what will be the reson even we had a simple recovery model of databases.

Answered 2/2/2012 9:34:10 AM by Ray Barley	(0)
Take a look at this tip to get some ideas: http://www.mssqltips.com/sqlservertip/1432/tempdb-configuration-best-practices-in-sql-server/

Answered 2/3/2012 8:55:22 AM by Jeremy Kadlec

(0)

Adveet,

Are there any large single transactions that are occurring? Are those transactions using temp tables or creating hash tables?

Thank you,
Jeremy Kadlec

Sponsor Information