Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
microsoftee
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="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>' |
|
|
|
|
|
Service Broker message taking 1.5 to 30 seconds