Friday, March 23, 2012

performance counters

well, it doesn't look so good.
i did all the troubleshoot i could find in the web but with a minor success.
it's not a corrupted registry, counters or something like that. out of 5
different machine - only one agreed to cooperate and allow access to those
counters remotely. the rest had varius behavior...
i tried lodctr, unlodctr, exctrlst, diskperf -Y and re-register sqlctr80.dll
with regsvr32 - with no maijor success. even though i got an error message
for the command "regsvr32 sqlctr80.dll" about an entry point that it couldnt
find, i don't think that's the problem.
any more assistance will be appreciated.
thanks, em.
"Plamen Ratchev" wrote:

> The following steps may help (but not always):
> - At the command prompt run: unlodctr.exe MSSQLServer
> - Then run: lodctr.exe <SQL Server path>\binn\sqlctr.ini
> - Reboot the computer
> If you have a named instance you should use the named instance name (for
> example: unlodctr.exe MSSQL$InstanceName).
> Regards,
> Plamen Ratchev
> http://www.SQLStudio.com
>
> "em" <em@.discussions.microsoft.com> wrote in message
> news:C2C1B0E8-2FE0-488F-A085-C392CDA89E5C@.microsoft.com...
>
>
Can you please clarify if you can access the performance counters on the
local machine and the problem is with remote access? How is that one machine
that works fine different than the others? Are there any related messages in
Event Log or the log files?
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"em" <em@.discussions.microsoft.com> wrote in message
news:8DA8FEEC-77F4-451C-9508-280F5F038745@.microsoft.com...[vbcol=seagreen]
> well, it doesn't look so good.
> i did all the troubleshoot i could find in the web but with a minor
> success.
> it's not a corrupted registry, counters or something like that. out of 5
> different machine - only one agreed to cooperate and allow access to those
> counters remotely. the rest had varius behavior...
> i tried lodctr, unlodctr, exctrlst, diskperf -Y and re-register
> sqlctr80.dll
> with regsvr32 - with no maijor success. even though i got an error message
> for the command "regsvr32 sqlctr80.dll" about an entry point that it
> couldnt
> find, i don't think that's the problem.
> any more assistance will be appreciated.
> thanks, em.
> "Plamen Ratchev" wrote:

No comments:

Post a Comment