dbTalk Databases Forums  

"dump transaction tempdb with truncate_only" takes 30+ mins

comp.databases.sybase comp.databases.sybase


Discuss "dump transaction tempdb with truncate_only" takes 30+ mins in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Graham Hick
 
Posts: n/a

Default "dump transaction tempdb with truncate_only" takes 30+ mins - 02-27-2004 , 07:51 AM






We're experiencing an intermittent problem whereby the
logsegment in tempdb gets <40% space free and a threshold
procedure is fired off. The proc collects some information
about what was running at the time then dumps the
transaction log with truncate_only. This regularly takes
around 30 mins to complete. While the dump is in progress,
the log continues to grow and further thresholds are passed.

We're unable to figure out why it takes this long, as we're
just truncating the log not saving it to an O/S file. Any
ideas would be much appreciated.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.