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
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.
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?
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?