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

SQL Server with Mr. Denny:

Service Broker

1234
November 6, 2008  11:00 AM

Very useful little query to monitor the health of service broker



Posted by: Denny Cherry
Service Broker, SQL Server 2005, SQL Server 2008, sys.conversation_endpoints

While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was.  So I came up with this little query which is surprisingly effective. select far_service

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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

October 6, 2008  8:33 AM

Orange County SQL Server User Group has started up



Posted by: Denny Cherry
In Person Events, Lynn Langit, Orange County SSUG, Service Broker, SQL Server 2005

Orange County now has its own SQL Server User Group.  It is being run as a part of the Orange County .NET Users Group.  The first speaker...

  Bookmark and Share     0 Comments     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

August 21, 2008  11:00 AM

SoCal Code Camp Sessions are posted



Posted by: Denny Cherry
Back To Basics, Code Camp, In Person Events, Service Broker, SoCal Code Camp, SQL Server 2005, SQL Server 2008, Storage

I and many of the other presenters have begun entering our sessions for the next SoCal Code Camp on on October 25th and 26th...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

August 20, 2008  10:58 PM

I had a great talk with the NJ SQL User Group last night



Posted by: Denny Cherry
Awareness Technologies, In Person Events, Laptop Cop, Quest Software, Service Broker

Last night was my talk with the NJ SQL User Group.  I would jut like to thank them for the invite, I had a great time coming and speaking with them.  It was a very interactive night, with a lot of questions. 

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

August 14, 2008  11:00 AM

I’ll be speaking at the New Jersey SQL Server Users Group next week



Posted by: Denny Cherry
In Person Events, New Jersey SSUG, Service Broker, SQL Server 2005, SQL Server 2008

After months of waiting the time is finely here.  I'll be speaking at the

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

July 7, 2008  11:00 AM

Back To Basics: The RECEIVE command (and END CONVERSATION)



Posted by: Denny Cherry
Back To Basics, RECEIVE, Service Broker, SQL, T/SQL

The RECEIVE command is the last of the Service Broker items to cover in the Back To Basics series.  The RECEIVE command is what is used to actually get the message out of the queue so that you can process the data within the message_body column.  The RECEIVE command works just like the

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

June 26, 2008  11:00 AM

Back To Basics: The SEND command (and the BEGIN DIALOG command)



Posted by: Denny Cherry
Back To Basics, BEGIN DIALOG, SEND, Service Broker, SQL, T/SQL

The SEND command was introduced to SQL Server when SQL Server 2005 was released.  It's kind of like the INSERT command except that it is used only with the SQL Server Service Broker.  With the service broker you put data into a queue instead of a table.  Insert of inserting a command into the...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

June 19, 2008  11:00 AM

Back To Basics: Service Broker Routes



Posted by: Denny Cherry
Back To Basics, Route, Service Broker, SQL

Routes are only needed when sending service broker messages from one server to another.  They define the SQL Server and TCP Port which the sending SQL Server will connect to in order to deliver the message.  If you are sending the message to a mirrored database, then you can specify the mirror as...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1234