Missing SQL perfmon counters in 2003 Cluster

Hi,
I have SQL2000 cluster on Windows 2003 (2 Active nodes and 1 passive), one
of the active server is missing the SQL performance counters, the weird
thing is, if I run Perfmon remotely connecting to this node, it will not
display any SQL Performance counters but if I login locally to the server
and run Perfmon, it will show the SQL performance counters.
Any idea why is this happening.
Thanks
Ayad
Permissions.
Try running the performance monitoring service using a real domain account
rather than the Network Service account.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:O59UFK28EHA.2572@.tk2msftngp13.phx.gbl...
> Hi,
> I have SQL2000 cluster on Windows 2003 (2 Active nodes and 1 passive),
one
> of the active server is missing the SQL performance counters, the weird
> thing is, if I run Perfmon remotely connecting to this node, it will not
> display any SQL Performance counters but if I login locally to the server
> and run Perfmon, it will show the SQL performance counters.
> Any idea why is this happening.
> Thanks
>
> Ayad
>

Missing SQL perfmon counters - Problem Solved

SQL perfmon counters are missing. Running SQL 2005 Workgroup (which is a 32 bit app) on a 64 bit OS. Could the counters be missing because of running a 32 bit app on a 64 bit OS? Anyone know? Thanks.try running x86 perfmon (i.e. %windir%\SysWOW64\perfmon.exe).|||Thanks! This worked.

Missing SQL perfmon counters

SQL perfmon counters are missing. Running SQL 2005 Workgroup (which is a 32 bit app) on a 64 bit OS. Could the counters be missing because of running a 32 bit app on a 64 bit OS? Anyone know? Thanks.try running x86 perfmon (i.e. %windir%\SysWOW64\perfmon.exe).|||Thanks! This worked.

Missing RAM

My server has Windows 2000 Advanced Server as the operating system with 4GB
of RAM and SQL Server 2000 as the database server. In perfmon the SQL Server
target server memory and SQL Server total server memory list at 1.68 GB.
What could be reducing the memory to 1.68 GB. How can I resolve this issue.
Thank You,
What edition of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this issue.
> Thank You,
|||Joe,
Check the memory setting (esp the max memory) for the SQL Server. In EM
right click the SQL Server -->Properties--> Memory.
HTH
Jerry
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with
> 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL
> Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this
> issue.
> Thank You,

Missing RAM

My server has Windows 2000 Advanced Server as the operating system with 4GB
of RAM and SQL Server 2000 as the database server. In perfmon the SQL Server
target server memory and SQL Server total server memory list at 1.68 GB.
What could be reducing the memory to 1.68 GB. How can I resolve this issue.
Thank You,What edition of SQL Server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this issue.
> Thank You,|||Joe,
Check the memory setting (esp the max memory) for the SQL Server. In EM
right click the SQL Server -->Properties--> Memory.
HTH
Jerry
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with
> 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL
> Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this
> issue.
> Thank You,

Missing RAM

My server has Windows 2000 Advanced Server as the operating system with 4GB
of RAM and SQL Server 2000 as the database server. In perfmon the SQL Serve
r
target server memory and SQL Server total server memory list at 1.68 GB.
What could be reducing the memory to 1.68 GB. How can I resolve this issue.
Thank You,What edition of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with 4G
B
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL Ser
ver
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this issu
e.
> Thank You,|||Joe,
Check the memory setting (esp the max memory) for the SQL Server. In EM
right click the SQL Server -->Properties--> Memory.
HTH
Jerry
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:693A66FC-45B1-482E-B59D-FC068E4B6218@.microsoft.com...
> My server has Windows 2000 Advanced Server as the operating system with
> 4GB
> of RAM and SQL Server 2000 as the database server. In perfmon the SQL
> Server
> target server memory and SQL Server total server memory list at 1.68 GB.
> What could be reducing the memory to 1.68 GB. How can I resolve this
> issue.
> Thank You,

Missing perfmon SQL objects

I'm having an issue with a SQL 2000 cluster. On each node, there always
seems to be only one instance of perfmon SQL objects available at a time.
There are 3 instances of SQL installed on the cluster, default, PROD0 and
PROD1. On each physical node, opening perfmon to set up counters, there is
always only one set of SQL objects available. for example, as I write this,
only the default instance counters are available (SQLServer:<objectname>) on
the active node, but on the passive node, only the MSSQL$PROD0 objects are
available.
Any ideas?
Hello dwaine,
I understand that you could not see the performance counter in a SQL 2000
cluster environment.
You may use the following steps:
To get the counters loaded, SQL Server was taken offline and perfmon was
closed on the active node.
Simple Network Management Protocol (SNMP) service and the antivirus
software service were both stopped.
The following files were copied to the C:\Program Files\Microsoft SQL
Server\MSSQL\Binn folder:
From the SQL Server 2000 setup files: sqlctr.h
From the SQL Server 2000 sp4 setup files: sqlctr.ini and sqlctr80.dll
The following commands were run from the command prompt in the Binn folder
of the SQL Server instance:
unlodctr MSSQLServer
lodctr.exe \\VirtualServerName sqlctr.ini
net helpmsg %errorlevel%
Then, you will see the counter.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.