LinkedIn | FaceBook | Twitter
I'm continuing my series on the Standard Reports in SQL Server Management Studio, and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, click the Standard Reports, and then select the title at the top of this post.
If you use the Service Broker, you know that monitoring the process is essential. If you’re new to the service Broker, you can read more about it here. To monitor service Broker, you normally use a lot of stored procedures and functions. This report is indispensable to that process, since it runs those commands for you and tracks them historically.
The first section of this report has the Service Broker ID, and the Status of the feature.
The second section of the report has a set of graphs that shows the following information:
The first band of information is Services, grouped by the Service Name:
The second band of information is Queues, grouped by the queue Name:
The final band of information is a simple chart that shows the overall statistics for the Task Activations:
PingBack from http://www.biosensorab.org/2008/02/29/sql-server-management-studio-standard-reports-%e2%80%93service-broker-statistics-databasename/
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re