2.3.0.334 Error: Blocked Process stays Active if "Unknown"

Monitor, diagnose and receive alerts to problems across your SQL Servers.

2.3.0.334 Error: Blocked Process stays Active if "Unknown"

Postby PDinCA » Mon Oct 24, 2011 6:42 pm

Code: Select all
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?
PDinCA
 
Posts: 530
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby priyasinha » Wed Nov 02, 2011 5:14 pm

Hi,

Thanks for reporting this issue.

We are tracking this as SRP-5034. Restarting the SQL Server service should end these alerts. But if this is not possible, then you can clear them. There is no manual way to force an alert to end.

Regards,
Priya
priyasinha
 
Posts: 534
Joined: Wed Jan 03, 2007 5:02 pm

Postby PDinCA » Wed Nov 02, 2011 5:26 pm

As this is on the Production cluster, running a 24x7 app, we'll wait until the regular monthly maintenance failover.

Thanks for opening the case.
PDinCA
 
Posts: 530
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA


Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests