126.96.36.1994 Error: Blocked Process stays Active if "Unknown"
This is 12:08 on 10/22/2011 and it is STILL ACTIVE! The Backup definitely ended successfully or I'd be in deep trouble.
Blocked process: SQBCoreService.exe Process ID: 152 Database: xcp_trans Host: 307997-DB1 User: IAD\935960-sqlsvc Start time: 12:08 AM SQL fragment: BACKUP LOG [xcp_trans] TO VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC3', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC301', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC302', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC303', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC304', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC305', VIRTUAL_DEVICE = 'SQLBACKUP_3626848A-0076-4B0C-B071-B240E9AA7CC306' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (xcp_trans), 10/22/2011 12:08:02 AM', DESCRIPTION = N'Backup on 10/22/2011 12:08:02 AM Server: 308187-SQLCLUS Database: xcp_trans', FORMAT Blocking process: Unknown Process ID: 13 Database: Host: User: Unknown Start time: 3:07 AM SQL fragment: Unknown
Seems that when SQL Monitor has an "Unknown" blocker, it can't determine when the Alert should be "Ended".
The problem is that every Blocked Process alert I have is still "Active". I had one that started this issue over four days ago.
How do I get back to normal - i.e. show "Ended", please?
Jesus Christ: Lunatic, liar or Lord?
0 · Share on Twitter