- Code: Select all
Blocked process: SQBCoreService.exe
Process ID: 152
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
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?