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 |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2007-10-04 : 20:54:08
|
| Hello! I am trying to troubleshoot weird problem. I noticed that msdb log size was growing. I have discovered jobs executing particular stored procedure that had an open transaction in msdb and killed spid in question. This stored procedure was executing sp_send_dbmail at the time I killed spid and fn_get_sql returned xp_sysmail_format_query as currently executed statement. SPID is showing KILLED\ROLLBACK status but it hasn't changed for hours and msdb log continues to grow. I am running SQL Server 2005 SP1. I was wondering if anyone has expeienced similar problem. Any advice is greately appreciated.Thanks,Igor |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 21:46:43
|
| Didn't see that on my servers, try restart sql agent. |
 |
|
|
imarchenko
Yak Posting Veteran
57 Posts |
Posted - 2007-10-08 : 13:09:09
|
| Hello rmiao! I had this resolved. It turned out that database mail extended stored procedure called from main stored procedure was in turn blocked but it. Main stored procedure and mail stored procedure had differenet spids. That what made me confused. I got issue resolved by killing spid initiated by extended stored procedure.Thanks,Igor |
|
|
|
|
|
|
Unable to kill transaction in msdb