Missing performance counters X64 OS with SQL2000

Hi

I am using Windows 2003 Server Standard Edition X64 SP1. On top of that I have SQL 2000 Server SP4. Its a plain vanilla installation. Still, I miss all the SQL counters.

SQLCTR80.DLL is in Crogram Files (x86)Microsoft SQL ServerMSSQLBinn.

Is SQLCTR80.DLL working under X64 wow? Are the missing counters in X64 w. SQL200 an known issue?

Kind regards,

Dennis.

Hi,

Thanks, I corrected original titel and subject, I forgot to state i applied SP1 on Windows 2003 Server, so thats covered. The clean install was: a clean Opteron dual SMP machine -> OS install W2k3 Server standard ed R1 X64, booted from CD -> w2k3se SP1 -> remaining OS updates from Windows Update -> SQL 2000 enterpise edition -> SQL 2000 SP4. This results in this problem. In an earlier installation I did SP3a as an intermediate step before SP4, same problem.

Well, problem solved.

In the logfile I overlooked Event ID 1021:

Windows cannot open the 32-bit extensible counter DLL MSSQLSERVER in a 64-bit environment. Contact the file vendor to obtain a 64-bit version. Alternatively, you can open the 32-bit extensible counter DLL by using the 32-bit version of Performance Monitor. To use this tool, open the Windows folder, open the Syswow64 folder, and then start Perfmon.exe.


You should start C:WINDOWSSysWOW64Perfmon.exe, this is the 32-bit version, and all the counters are there.

I renamed this perfom to perfmon32, with a shortcut to the desktop.

Now I can finally monitor the SQL memory usage, a important healthparameter running under X64.

This helped me too. I love this forum!!

But what about when you try to save the SQL 2000 counters to a file?
This is running like a 64bits application so SQL counters are not saved.

Anyone find a solution?

Same thing with saving to database as well. You can actually add the counters to a counter log in the 32 bit version. They show up in the 64 bit perf mon app as part of the counter log even. But the only counters that save to database are non-SQL Server counters.

Do need a fix for this, if its out there.

-Paul

"as you think, so shall you be"

Just in case, from another forum:

"bertcord
86 Posts
Posted - 08/07/2006 : 17:35:59
--------------------------------------------------------------------------------

You can use the following workaround for this issue.

1) Stop the Performance Logs & Alerts service from services.msc
2) Open up the registry editor (regedit.exe), browse down to HKLMSystemCurrentControlSetServicesSysmonlog.
3) Change the ImagePath from the default value to %SystemRoot%syswow64smlogsvc.exe.( This would launch the 32-bit service on starting the Counter logs)
4) Open the 32-bit Perfmon from Start - Run - %SystemRoot%syswow64perfmon.exe, & add the SQL counter objects to a Counter log.
5) Set the various parameters of the Counter log, & start it to collect the data.
"
--------------------------------------
"
Just wanted to add:

You can log to database as well by using the WOW64 ODBC drivers.

Run C:WINDOWSSysWOW64odbcad32.exe to setup DSNs that can be used by the 32bit PerfMon to log to database as well.

-Paul
"

"as you think, so shall you be"