Showing posts with label missing. Show all posts
Showing posts with label missing. Show all posts

Friday, March 23, 2012

Performance Counters Missing

My SQL Server 2000 (SP2) performance counters are missing/corrupted. They
seem to be in the Performance COunter drop down, as a series of 4-digit
numbers. The SQL server runs on a active/passive Windows 2000
clusterconfiguration (W2K SP3). I've tried manually reloading them with
lodctr and the sqlctr.ini file looks clean. The other (passive) cluster
node doesn't have them either, but it also doesn't have the odd 4-digit
number entries in the drop down list of counters. Any help would be
appreciated.
PJ
Have you tried this:
http://support.microsoft.com/?kbid=300956
Markus
|||I'll give that a try and get back to the group. Thanks for the suggestion.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegr oups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>
|||Thanks for the suggestion Markus. I tried it, and it got rid of the weird
numbered counters in the Performance Monitor Counter list (except for one,
listed as 0 - ZERO). However, the SQL counters are completely missing ...
any further ideas? Thanks again.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegr oups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>
|||I tried to fathom the recommended article and was completely flummoxed. That
called for some scary registry manipulation in a whole lot of places. Is
there not some way to get a value to plug in just to the 009 branch? I found
a large number of last counter and last help fields throughout the registry
and got scared off. Where does a mere mortal go for help on this?
"msnews.microsoft.com" wrote:

> Thanks for the suggestion Markus. I tried it, and it got rid of the weird
> numbered counters in the Performance Monitor Counter list (except for one,
> listed as 0 - ZERO). However, the SQL counters are completely missing ...
> any further ideas? Thanks again.
> PJ
>
> "MarkusB" <m.bohse@.quest-consultants.com> wrote in message
> news:1133340824.530847.203620@.g44g2000cwa.googlegr oups.com...
>
>
sql

Performance Counters Missing

After installing Sharepoint application on to my SQL Server 2000, all the
performance counters for SQL went missing.
How do I get them back and would I need to restart SQL/Reboot afterwards?
In NT machine heard about executing,
diskperf -y in command prompt and reboot to get few performance counter
enabled...
Thanks,
Sree
"Woo" wrote:

> After installing Sharepoint application on to my SQL Server 2000, all the
> performance counters for SQL went missing.
> How do I get them back and would I need to restart SQL/Reboot afterwards?
>
|||The server is Windows 2003.
"Sreejith G" wrote:
[vbcol=seagreen]
> In NT machine heard about executing,
> diskperf -y in command prompt and reboot to get few performance counter
> enabled...
> Thanks,
> Sree
> "Woo" wrote:

Performance Counters Missing

My SQL Server 2000 (SP2) performance counters are missing/corrupted. They
seem to be in the Performance COunter drop down, as a series of 4-digit
numbers. The SQL server runs on a active/passive Windows 2000
clusterconfiguration (W2K SP3). I've tried manually reloading them with
lodctr and the sqlctr.ini file looks clean. The other (passive) cluster
node doesn't have them either, but it also doesn't have the odd 4-digit
number entries in the drop down list of counters. Any help would be
appreciated.
PJHave you tried this:
http://support.microsoft.com/?kbid=300956
Markus|||I'll give that a try and get back to the group. Thanks for the suggestion.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>|||Thanks for the suggestion Markus. I tried it, and it got rid of the weird
numbered counters in the Performance Monitor Counter list (except for one,
listed as 0 - ZERO). However, the SQL counters are completely missing ...
any further ideas? Thanks again.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>|||I tried to fathom the recommended article and was completely flummoxed. Tha
t
called for some scary registry manipulation in a whole lot of places. Is
there not some way to get a value to plug in just to the 009 branch? I foun
d
a large number of last counter and last help fields throughout the registry
and got scared off. Where does a mere mortal go for help on this?
"msnews.microsoft.com" wrote:

> Thanks for the suggestion Markus. I tried it, and it got rid of the weird
> numbered counters in the Performance Monitor Counter list (except for one,
> listed as 0 - ZERO). However, the SQL counters are completely missing ...
> any further ideas? Thanks again.
> PJ
>
> "MarkusB" <m.bohse@.quest-consultants.com> wrote in message
> news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
>
>

Performance Counters Missing

After installing Sharepoint application on to my SQL Server 2000, all the
performance counters for SQL went missing.
How do I get them back and would I need to restart SQL/Reboot afterwards?In NT machine heard about executing,
diskperf -y in command prompt and reboot to get few performance counter
enabled...
Thanks,
Sree
"Woo" wrote:
> After installing Sharepoint application on to my SQL Server 2000, all the
> performance counters for SQL went missing.
> How do I get them back and would I need to restart SQL/Reboot afterwards?
>|||The server is Windows 2003.
"Sreejith G" wrote:
> In NT machine heard about executing,
> diskperf -y in command prompt and reboot to get few performance counter
> enabled...
> Thanks,
> Sree
> "Woo" wrote:
> > After installing Sharepoint application on to my SQL Server 2000, all the
> > performance counters for SQL went missing.
> >
> > How do I get them back and would I need to restart SQL/Reboot afterwards?
> >
> >

Performance Counters Missing

My SQL Server 2000 (SP2) performance counters are missing/corrupted. They
seem to be in the Performance COunter drop down, as a series of 4-digit
numbers. The SQL server runs on a active/passive Windows 2000
clusterconfiguration (W2K SP3). I've tried manually reloading them with
lodctr and the sqlctr.ini file looks clean. The other (passive) cluster
node doesn't have them either, but it also doesn't have the odd 4-digit
number entries in the drop down list of counters. Any help would be
appreciated.
PJHave you tried this:
http://support.microsoft.com/?kbid=300956
Markus|||I'll give that a try and get back to the group. Thanks for the suggestion.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>|||Thanks for the suggestion Markus. I tried it, and it got rid of the weird
numbered counters in the Performance Monitor Counter list (except for one,
listed as 0 - ZERO). However, the SQL counters are completely missing ...
any further ideas? Thanks again.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>|||I tried to fathom the recommended article and was completely flummoxed. That
called for some scary registry manipulation in a whole lot of places. Is
there not some way to get a value to plug in just to the 009 branch? I found
a large number of last counter and last help fields throughout the registry
and got scared off. Where does a mere mortal go for help on this?
"msnews.microsoft.com" wrote:
> Thanks for the suggestion Markus. I tried it, and it got rid of the weird
> numbered counters in the Performance Monitor Counter list (except for one,
> listed as 0 - ZERO). However, the SQL counters are completely missing ...
> any further ideas? Thanks again.
> PJ
>
> "MarkusB" <m.bohse@.quest-consultants.com> wrote in message
> news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> > Have you tried this:
> > http://support.microsoft.com/?kbid=300956
> >
> > Markus
> >
>
>

Performance counter missing

Sometimes the SQL Performance counters dissappear.
I have this problem when I change "Reserve physical memory" from Enterprise
Managers (I'm using dynamically memory allocation), its ask me about restart
the service, if I answer Yes the service is restarted but the sql counters
disappear. When I restart (shutdown) the server, the counter appear again...
The same occurs if I use sp_configure 'set working set size', after I
restart the service, the counters are missing; when I restart the server,
it's OK...
It isn't a big problema cause I can restart the server for a while, but I
think it's not a normal condition.
sio Nunes
It's a bug that usually happens if you restart SQL Server and have something
running that is polling the counters at the time you shut down the service.
The trick is to ensure nothing is accessing any of the counters (perfmon,
custom traces etc) before you restart.
These may help:
SQL Perf Counters Missing After MDAC Install on Cluster [Q246328]
"Event ID (1001) in Source (SQLCTR70) Could Not Be Found" [Q196657]
Missing Objects and Counters in Performance Monitor [Q127207]
SQL Performance Monitor Counters Missing [Q227662]
Andrew J. Kelly SQL MVP
"Esio Nunes" <esio_nunes@.hotmail.com> wrote in message
news:%23EgzFlC5EHA.828@.TK2MSFTNGP14.phx.gbl...
> Sometimes the SQL Performance counters dissappear.
> I have this problem when I change "Reserve physical memory" from
> Enterprise
> Managers (I'm using dynamically memory allocation), its ask me about
> restart
> the service, if I answer Yes the service is restarted but the sql counters
> disappear. When I restart (shutdown) the server, the counter appear
> again...
> The same occurs if I use sp_configure 'set working set size', after I
> restart the service, the counters are missing; when I restart the server,
> it's OK...
> It isn't a big problema cause I can restart the server for a while, but I
> think it's not a normal condition.
> sio Nunes
>
>

Performance counter missing

Sometimes the SQL Performance counters dissappear.
I have this problem when I change "Reserve physical memory" from Enterprise
Managers (I'm using dynamically memory allocation), its ask me about restart
the service, if I answer Yes the service is restarted but the sql counters
disappear. When I restart (shutdown) the server, the counter appear again...
The same occurs if I use sp_configure 'set working set size', after I
restart the service, the counters are missing; when I restart the server,
it's OK...
It isn't a big problema cause I can restart the server for a while, but I
think it's not a normal condition.
Ésio NunesIt's a bug that usually happens if you restart SQL Server and have something
running that is polling the counters at the time you shut down the service.
The trick is to ensure nothing is accessing any of the counters (perfmon,
custom traces etc) before you restart.
These may help:
SQL Perf Counters Missing After MDAC Install on Cluster [Q246328]
"Event ID (1001) in Source (SQLCTR70) Could Not Be Found" [Q196657]
Missing Objects and Counters in Performance Monitor [Q127207]
SQL Performance Monitor Counters Missing [Q227662]
--
Andrew J. Kelly SQL MVP
"Esio Nunes" <esio_nunes@.hotmail.com> wrote in message
news:%23EgzFlC5EHA.828@.TK2MSFTNGP14.phx.gbl...
> Sometimes the SQL Performance counters dissappear.
> I have this problem when I change "Reserve physical memory" from
> Enterprise
> Managers (I'm using dynamically memory allocation), its ask me about
> restart
> the service, if I answer Yes the service is restarted but the sql counters
> disappear. When I restart (shutdown) the server, the counter appear
> again...
> The same occurs if I use sp_configure 'set working set size', after I
> restart the service, the counters are missing; when I restart the server,
> it's OK...
> It isn't a big problema cause I can restart the server for a while, but I
> think it's not a normal condition.
> Ésio Nunes
>
>