Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Service Broker (2005)
 Service Broker message taking 1.5 to 30 seconds

Author  Topic 

Starting Member

6 Posts

Posted - 2012-06-27 : 03:47:39
I 'm using Service Broker in .net Windows Form application. While I ran the SQL Profiler trace I found many messages taking 1.5 to 30 seconds.

It has overall performance implications on application.

While in SQL Server error log I found the following error related to service broker.

The query notification dialog on conversation handle '{D001E238-F9B9-E111-9C9E-E83935A8B050}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns=""><Code>-8490</Code><Description>Cannot find the remote service 'SqlQueryNotificationService-7595ba40-1ba1-4878-8ce4-fdb4ac8a384b' because it does not exist.</Description></Error>'

- Advertisement -