Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
izaltsman
A custom title
1139 Posts |
 Posted - 2006-10-19 : 18:21:34
|
| Hi All! It appears that one of my production servers (SQL2k SP3a) has stopped issuing checkpoints on tempdb database. In other words, normally I expect that whenever tempdb log fills up to about 70% mark, a checkpoint happens, and tempdb log gets truncated. However, currently this isn't happening on this specific server. Here, the log keeps filling up until I issue CHECKPOINT command manually. When I do run it manually -- the log gets truncated as expected. Any thoughts on what could possibly cause this? Naturally, my tempdb is in SIMPLE recovery mode. There are no long-standing open transactions in tempdb. |
|
|
|
|
|
No checkpoint in tempdb