March 26, 2012 at 2:47 am
which trace flage i need to enable to disable Query notifications in Error log of Application Log.(beacause there error log are consuming more disk space)
Thanks in advance
March 26, 2012 at 4:19 am
Can you be more detailed? What query notification messages? You have some query notifications enabled?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 26, 2012 at 8:30 am
SQL Server sends a new query notification to the application, SQL server can’t find the remote service.
Following errors are getting logged in application log. beacause of any loggings event log is getting more size.
However, I can see A LOT of the below error.
Event Type: Information
Event Source: MSSQL$SQL04
Event Category: (2)
Event ID: 9207
Date: 2/28/2012
Time: 10:10:39 AM
User: N/A
Computer: ABC
Description:
The query notification dialog on conversation handle '{66D0DCEF-F261-E111-8B0D-0026557FD35C}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service 'SqlQueryNotificationService-04fbdb53-5e63-4ba2-b048-e5421866cb9f' because it does not exist.</Description></Error>'.
Refered document :http://support.microsoft.com/kb/958006
db level we did patching and all.
Our Product version 9.00.4230 ---64bit
we have suggested application team to investigate on :Why notification is not canceled by SQLDpendency.stop method
For workarround i wold like to stop these notifications in event log
March 26, 2012 at 8:47 am
Simha24 (3/26/2012)
SQL Server sends a new query notification to the application, SQL server can’t find the remote service.Following errors are getting logged in application log. beacause of any loggings event log is getting more size.
However, I can see A LOT of the below error.
Event Type: Information
Event Source: MSSQL$SQL04
Event Category: (2)
Event ID: 9207
Date: 2/28/2012
Time: 10:10:39 AM
User: N/A
Computer: ABC
Description:
The query notification dialog on conversation handle '{66D0DCEF-F261-E111-8B0D-0026557FD35C}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service 'SqlQueryNotificationService-04fbdb53-5e63-4ba2-b048-e5421866cb9f' because it does not exist.</Description></Error>'.
Refered document :http://support.microsoft.com/kb/958006
db level we did patching and all.
Our Product version 9.00.4230 ---64bit
we have suggested application team to investigate on :Why notification is not canceled by SQLDpendency.stop method
For workarround i wold like to stop these notifications in event log
Did you look at :
http://support.microsoft.com/kb/958006 trace flag 4133
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply