Performance Counters on Service Broker Transmission Queue

Hello,

is there built-in support for monitoring the number of elements in the transmission queue via performance counters?

Thanks,

There's no perfmon counter. Something like count () or sp_spaceused would be required to query the count. The message send perfmon counters probably are a better indication of what's happening at the connection level - depending on what you're trying to measure.|||

No performance counter. See this post for an efficient query to return the number of rows in the hidden table that represents the transmission queue: http://blogs.msdn.com/remusrusanu/archive/2006/11/08/fast-way-to-check-message-count.aspx

HTH,
~ Remus

|||Thank you both

Perf Mon

I want to monitor avg disk queue length and cpu for the
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
scope/" target="_blank">http://www.mercury.com/us/products/...e
scope/
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx
.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx
.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:

>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?

Perf Mon

I want to monitor avg disk queue length and cpu for the
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
http://www.mercury.com/us/products/application-management/foundation/monitors/sitescope/
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
--
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:
>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?

Perf Mon

I want to monitor avg disk queue length and cpu for the
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?
NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
http://www.mercury.com/us/products/a...ors/sitescope/
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?
|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?
|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:

>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?