Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

END CONVERSATION

1
November 3, 2008  11:00 AM

Improving SQL Service Broker Performance



Posted by: Denny Cherry
END CONVERSATION, RECEIVE, Remus Rusanu, SEND, Service Broker, SQL Server 2005, SQL Server 2008, T/SQL

A while back I was talking to a Microsoft Support Engineer and he had mentioned that in a high load Service Broker environment such as ours there can be some impressive performance improvement can be achieved by reusing the service broker sessions. The cost of creating and closing a new...

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

September 11, 2008  11:00 AM

Service Broker may not remove messages after processing



Posted by: Denny Cherry
END CONVERSATION, Service Broker, SQL, SQL Server 2005, TempDB

I've seen an issue with Service Broker that others may be seeing.  Messages are sent into the service broker, and are processed as normal, and they are removed from the message queue.  However you still see the conversation in the sys.conversation_endpoints DMV in a CONVERSING state instead of a...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1