Groups > comp.databases.ms-sqlserver > #1799

Re: How to tell if Server Broker is in use?

Newsgroups	comp.databases.ms-sqlserver
Date	2014-08-22 08:52 -0700
References	<7b43ce52-f091-440b-b1a9-2b86b8a56bec@googlegroups.com> <64c472b7-9d48-4c7f-a798-baa396964acd@googlegroups.com>
Message-ID	<fd070743-18fe-400d-9747-7328711c79ce@googlegroups.com> (permalink)
Subject	Re: How to tell if Server Broker is in use?
From	Ross Presser <rpresser@gmail.com>

Show all headers | View raw

On Friday, August 22, 2014 11:49:33 AM UTC-4, Ross Presser wrote:
> On Friday, August 22, 2014 11:42:29 AM UTC-4, Mark D Powell wrote:
> > I know how to tell if Server Broker is enabled by checking
> > sys.databases but what can I query to see if the database
> > feature is actually being used?
>
> Assuming you mean SQL Server Service Broker:
>
> Service Broker Catalog Views
> http://technet.microsoft.com/en-us/library/ms173780(v=sql.105).aspx
>
> In particular, I would check sys.services, sys.routes, etc to see
> if anybody has created anything yet.

Also, you can use Service Broker Performance Objects in System
Monitor, or Service Broker SQL Trace Events in SQL Trace, to watch
if anything's happening.

Links on this page:

Troubleshooting Tools (Service Broker)
http://technet.microsoft.com/en-us/library/bb522922(v=sql.105).aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

How to tell if Server Broker is in use? Mark D Powell <markp28665@gmail.com> - 2014-08-22 08:42 -0700
  Re: How to tell if Server Broker is in use? Ross Presser <rpresser@gmail.com> - 2014-08-22 08:49 -0700
    Re: How to tell if Server Broker is in use? Ross Presser <rpresser@gmail.com> - 2014-08-22 08:52 -0700
    Re: How to tell if Server Broker is in use? Mark D Powell <markp28665@gmail.com> - 2014-08-26 08:47 -0700

csiph-web