Memory Issues on Transaction Log Backups in SQL2005 (64 Bit)
We have noticed that memory is being held by the transaction log backup process and not released to SQl Server when SQLBackup transaction log backup jobs run on our production servers every 15 minutes.
It is severly impacting performance and PageLife Expectancy is going DOWN with each transaction log backup (every 15 minutes). We disabled the transaction log backup agent job and the page life expectancy started to climb back to acceptable levels.
We are concerned that there may be a bug of some sort that is causing transaction log backups to fix and hold memory that should be release when the job finishes execution.
Any thoughts or questions you have for me?