SQL Server Management Studio Standard Reports – Service Broker Statistics

I'm continuing my series on the Standard Reports in SQL Server Management Studio. Today I'm covering a report on a feature you might not have used yet – the Service Broker. This feature, which you can read more about here, allows you to set up a messaging system in SQL Server. You’ll often see this kind of architecture in a Service Oriented Architecture, where each server in the landscape provides a “service”, allowing you to effectively make a single, big system out of many servers.

We are still in the server-level reports, which span all the activity on a system. You can find this report by starting SQL Server Management Studio and right-clicking an instance name. From the menu that appears, click the Standard Reports, and then select Service Broker Statistics.

You’re presented with four bands in the report:

Each report has two columns: Performance Counter Name and Value. The counter that shows depends on what you have running – and you can find out the meanings and values for each here.

I urge you to read the Books Online entries on Service Broker to understand more about this powerful feature.