Clients ask me questions, I try my best to help if I know the answer. Recently I was asked if I know the how-to List Service Broker Queue Count.
SQL SERVER – Service Broker and CAP_CPU_PERCENT – Limiting SQL Server Instances to CPU Usage
I have mentioned several times on this blog that the best part of blogging is the questions I receive from readers. They are often very interesting. The questions from readers give me a good idea what other readers might be thinking as well. After reading my earlier article Simple Example…
Read MoreSQL SERVER – Introduction to Service Broker and Sample Script
Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation.” Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered…
Read MoreSQL SERVER – Change the Port of Service Broker Configuration
Just two days ago, I wrote a small note about SQL SERVER – Introduction to Service Broker.
SQL SERVER – Introduction to Service Broker
Service Broker is message queuing for SQL Server. It is used for sending emails and through Database Mails. You can read about SQL SERVER – Difference Between Database Mail and SQLMail here. Service Broker is feature which provides facility to SQL Server to send an asynchronous, transactional message.