SQL Server Performance Forum – Threads Archive

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 C

rogram 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.

Check: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6506
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirÃ¡ luego de tu muerte
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Not sure on 64 bit of it, may checkhttp://support.microsoft.com/kb/824721 for relevancy. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

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.

I feel its best to contact MS PSS in this regard, as minimal help available about x64 on web. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

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.

Wow, thats a magic and glad to know the resolution. I appreciate your time to post feedback. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Looks like a good candidate for a FAQ. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>

Thats why submitted to Brad already [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />]. <hr noshade size="1">Satya SKJ Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

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"

]]>