Mark Forums Read

Counters always 0 for instance not on active node

Go Back

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Reply

Page 1 of 2

1

#1

Old

Randy

Posts: n/a

Counters always 0 for instance not on active node - 02-28-2008 , 03:02 PM

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running on
the active node return a value 0. For example if Node A has Sql instance A
and Node B has Sql insatnce B, when I run perform on Node A I only get values
reurned for Sql Instance A and for Sql instance B the counters are always 0.
Is this by design or is there a fix for this?

Reply With Quote

#2

Old

Geoff N. Hiten

Posts: n/a

Re: Counters always 0 for instance not on active node - 02-29-2008 , 08:30 AM

The performance monitor service is not cluster-aware. As such, it can only
see counters that exist on the local node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running
on
the active node return a value 0. For example if Node A has Sql instance
A
and Node B has Sql insatnce B, when I run perform on Node A I only get
values
reurned for Sql Instance A and for Sql instance B the counters are always
0.
Is this by design or is there a fix for this?

Reply With Quote

#3

Old

Geoff N. Hiten

Posts: n/a

Re: Counters always 0 for instance not on active node - 02-29-2008 , 08:30 AM

The performance monitor service is not cluster-aware. As such, it can only
see counters that exist on the local node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running
on
the active node return a value 0. For example if Node A has Sql instance
A
and Node B has Sql insatnce B, when I run perform on Node A I only get
values
reurned for Sql Instance A and for Sql instance B the counters are always
0.
Is this by design or is there a fix for this?

Reply With Quote

#4

Old

Geoff N. Hiten

Posts: n/a

Re: Counters always 0 for instance not on active node - 02-29-2008 , 08:30 AM

The performance monitor service is not cluster-aware. As such, it can only
see counters that exist on the local node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running
on
the active node return a value 0. For example if Node A has Sql instance
A
and Node B has Sql insatnce B, when I run perform on Node A I only get
values
reurned for Sql Instance A and for Sql instance B the counters are always
0.
Is this by design or is there a fix for this?

Reply With Quote

#5

Old

Geoff N. Hiten

Posts: n/a

Re: Counters always 0 for instance not on active node - 02-29-2008 , 08:30 AM

The performance monitor service is not cluster-aware. As such, it can only
see counters that exist on the local node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running
on
the active node return a value 0. For example if Node A has Sql instance
A
and Node B has Sql insatnce B, when I run perform on Node A I only get
values
reurned for Sql Instance A and for Sql instance B the counters are always
0.
Is this by design or is there a fix for this?

Reply With Quote

#6

Old

Geoff N. Hiten

Posts: n/a

Re: Counters always 0 for instance not on active node - 02-29-2008 , 08:30 AM

The performance monitor service is not cluster-aware. As such, it can only
see counters that exist on the local node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running
on
the active node return a value 0. For example if Node A has Sql instance
A
and Node B has Sql insatnce B, when I run perform on Node A I only get
values
reurned for Sql Instance A and for Sql instance B the counters are always
0.
Is this by design or is there a fix for this?

Reply With Quote

#7

Old

Geoff N. Hiten

Posts: n/a

Re: Counters always 0 for instance not on active node - 02-29-2008 , 08:30 AM

The performance monitor service is not cluster-aware. As such, it can only
see counters that exist on the local node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running
on
the active node return a value 0. For example if Node A has Sql instance
A
and Node B has Sql insatnce B, when I run perform on Node A I only get
values
reurned for Sql Instance A and for Sql instance B the counters are always
0.
Is this by design or is there a fix for this?

Reply With Quote

#8

Old

Geoff N. Hiten

Posts: n/a

Re: Counters always 0 for instance not on active node - 02-29-2008 , 08:30 AM

The performance monitor service is not cluster-aware. As such, it can only
see counters that exist on the local node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running
on
the active node return a value 0. For example if Node A has Sql instance
A
and Node B has Sql insatnce B, when I run perform on Node A I only get
values
reurned for Sql Instance A and for Sql instance B the counters are always
0.
Is this by design or is there a fix for this?

Reply With Quote

#9

Old

Geoff N. Hiten

Posts: n/a

Re: Counters always 0 for instance not on active node - 02-29-2008 , 08:30 AM

The performance monitor service is not cluster-aware. As such, it can only
see counters that exist on the local node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running
on
the active node return a value 0. For example if Node A has Sql instance
A
and Node B has Sql insatnce B, when I run perform on Node A I only get
values
reurned for Sql Instance A and for Sql instance B the counters are always
0.
Is this by design or is there a fix for this?

Reply With Quote

#10

Old

Geoff N. Hiten

Posts: n/a

Re: Counters always 0 for instance not on active node - 02-29-2008 , 08:30 AM

The performance monitor service is not cluster-aware. As such, it can only
see counters that exist on the local node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.
When I use perfmon all the counters for the instances that are not running
on
the active node return a value 0. For example if Node A has Sql instance
A
and Node B has Sql insatnce B, when I run perform on Node A I only get
values
reurned for Sql Instance A and for Sql instance B the counters are always
0.
Is this by design or is there a fix for this?

Reply With Quote

Reply

Page 1 of 2

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.