October 30, 2007 at 12:42 pm
I am running Windows 2003 x64 with SQL Server 2000 32-bit and using Performance Monitor 32-bit. I can add SQL Server counters to the real-time monitoring in Performance Monitor but when I try to log the counters to a text file in the logging section it won't capture the SQL counters data. Any reason why this would be?
-Matt
October 30, 2007 at 1:44 pm
Found the answer to this:
--------------------------------------------------------------------------------
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 HKLM\System\CurrentControlSet\Services\Sysmonlog.
3) Change the ImagePath from the default value to %SystemRoot%\syswow64\smlogsvc.exe.( This would launch the 32-bit service on starting the Counter logs)
4) Open the 32-bit Perfmon from Start - Run - %SystemRoot%\syswow64\perfmon.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:\WINDOWS\SysWOW64\odbcad32.exe to setup DSNs that can be used by the 32bit PerfMon to log to database as well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply