February 20, 2009 at 10:04 am
Performance counter not working on a 64 bit server with SQL Server 2005 32 bit
February 20, 2009 at 11:09 am
More information please. Performance counters do work. Are missing all of them or one specific one?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 20, 2009 at 11:44 am
The server is 64 bit and SQL Server installed is of 32 bit. Now when we run the perfmon from the server it will default run the 64 bit perfmon which does not show the counters/objects for SQL Server. So After doing some research we found that if we execute the perfmon.exe which is staying at the path "C:\WINDOWS\SysWOW64" this will show all the counters of SQL Server. Nowe succeeded in getting all the counters for the SQL server on local server. But when we tried to get the counters from remote server we noticed the same issue as the remote server is by default picking the counters from 64 bit perfMon. Please let me know if any further information is required.
we need to have the counters visible from remote server for monitoring purpose..
February 20, 2009 at 11:59 am
Hmmm. I've never run 32 bit SQL Server on a 64 bit machine. Seems to kind of defeat the purpose. But anyway, I don't know the answer to the problem. Sorry.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply