No Indicators on Windows Performance Monitor and Sybase 10

[Former Member]

Hey at all,

i've got a problem with Sybase10 on an Server2008 R2 Std. I want to use the windows performance monitor and the performance Counters of Sybase 10. Sybase run as service with system privileges.

When i run dbsrv10 directly from command box (cmd > dbsrv10) and then starting the perfmon then its no problem and then I see the indicators, such as the bottom of the image

i also tested to re-register the dbtrs10.dll (SQL Anywhere Perf Counter) and go to regedit under [HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\SQL_Anywhere_10\\Performance] an create a new DWORD

Name: Disable Performance Counters value = 0

I've testet it with Sybase 10 on Server2008, (not working) Vista (not working), Win 7 (not working), XP (it works)

with Sybase 16 on Server 2008 (it works), Windows 8 (it works)

An Example for Sybase 16 (i need this for Sybase 10)

any ideas to fix this?

[VolkerBarth]

Are you using a 32-bit or 64-bit engine?

[Former Member · Accepted solution]

Hello again. it's not an Windows or an Sybase Problem. When you are using a deployment-tool or installer like "Wise Installer" or "Install Shield" check up your current installer version. It might be a problem using the 64-bit cmd shell because when you open cmd in 64bit you also use regsvr32 in 64bit mode. Solution: call regsvr32 from sysWOW64 so the cmdshell is started as 32-bit cmd shell and the regsvr32 will be also 32bit.

this is only when you are using an deployment tool or installer, if you try it manually it works with no problems in 32 and 64bit

[Former Member]

I guess I have found the error... it's on 64 bit (the regsvr32.exe in 64Bit not works correctly)

When we install Sybase 10 64bit on Server 2008 64Bit there is no value in "cmd > regedit" HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\SQL_Anywhere_10_64Bit

The engine ist registered as service and its startet but no entry in "cmd > PerfMon"

Solution:

I register the dll with 32-Bit regsvr (on the 64-Bit Machine) C:\\Windows\\SysWOW64\\regsvr32.exe C:\\Sybase10x64\\x64\\dbctrs10.dll

Then i restart the Sybase10-service

it works.

[Former Member]

Your results would indicate, to me, that you are running a 32bit dbsrv10 service but a 64bit dbsrv10 from the cmdprompt.

[VolkerBarth]

the regsvr32.exe in 64Bit not works correctly

What do you mean by that?

AFAIK, you do not really need to call the appropriate bitness of regsvr32.exe for your DLL - if you call the wrong one, it will spawn the correct one and that will register the DLL. Cf. that article:

http://www.differentpla.net/content/2008/10/things-i-learnt-week-regsvr32exe-windows-x64

Therefore it's only important to specify the desired DLL to register, and in your sample you have registered the DLL from the \\x64 SA subfolder so it should be the 64-bit DLL... (and if that has been successful, the 64-bit version of regsvr32.exe must work properly:))