server 2 task(s) are sleeping waiting for space to become available in the log segment for database...

最新推荐文章于 2023-01-12 16:38:51 发布

最新推荐文章于 2023-01-12 16:38:51 发布 · 359 阅读

文章标签：

#数据库

本文记录了在特定时间点内，服务器由于tempdb数据库的日志段空间不足导致任务挂起的问题，并提供了解决方案：通过执行dumptrancwbase16withtrancate_only命令来释放日志空间。

00:00000:00004:2007/07/19 10:07:45.36 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00004:2007/07/19 10:07:47.22 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00004:2007/07/19 10:08:45.95 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00004:2007/07/19 10:09:46.54 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
00:00000:00004:2007/07/19 10:10:47.13 server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.

解决办法：dump tran cwbase16 with trancate_only