Service Broker message taking 1.5 to 30 seconds

• microsoftee

  Mr or Mrs. 500

  Points: 504

  More actions

  June 27, 2012 at 1:48 am

  #260504

  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>

• Nils Gustav Stråbø

  SSChampion

  Points: 11259

  More actions

  June 27, 2012 at 2:07 am

  #1506005

  Have you done any googleing?

  I found this support article, maybe related to your problem?

  http://support.microsoft.com/kb/958006