Service Broker message taking 1.5 to 30 seconds

Last Post 27 Jun 2012 05:49 AM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
microsoftee
New Member
New Member

--
26 Jun 2012 11:52 PM
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="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service 'SqlQueryNotificationService-7595ba40-1ba1-4878-8ce4-fdb4ac8a384b' because it does not exist.</Description></Error>
gunneyk
New Member
New Member

--
27 Jun 2012 05:49 AM
It sounds like you may have connectivity issues between the two servers.


Acceptable Use Policy
---