求救：tempdb的log满

tyhl1999

Space available in the log segment has fallen critica
lly low in database 'tempdb'.  All future modifications to this database will be suspended until th
e log is successfully dumped and space becomes available.
什么情况导致log满，除了重启SERVER和扩tempdb，还有其他解决方案吗？
另外经常报“WARNING: memory usage in procedure headers (2)
does not match memory usage count in Pss (4) for server process id 29.”这类警告是什么意思，怎么解决？

zrzdream

有大量的临时数据就会把tempdb占慢，要解决只有扩库。

chuxu

给tempdb 加“trunc log on chkpint"的选项