Performance Counters not available after restart Take offline-Online

After stopping and starting the MSSQLSERVER service the Performance Counters are not available. After a reboot of the server they are there again. What is the proper way to shutdown the MSSQLSERVER process, starting it again and regaining access to the performance counters? The Unlodctr and lodctr sqlstr.ini trick seems not to work. A complete reboot of the server is needed.I've found that stopping and starting the MSSQL Service using the services mmc renders the performance log for SQLServer in accesible. However, stop and starting a SQLserver from the Enterprise Manger does not have that effect.

Performance Counters not available after restart Take offline-Online

After stopping and starting the MSSQLSERVER service the Performance Counters are not available. After a reboot of the server they are there again. What is the proper way to shutdown the MSSQLSERVER process, starting it again and regaining access to the performance counters? The Unlodctr and lodctr sqlstr.ini trick seems not to work. A complete reboot of the server is needed.I've found that stopping and starting the MSSQL Service using the services mmc renders the performance log for SQLServer in accesible. However, stop and starting a SQLserver from the Enterprise Manger does not have that effect.

Performance counters disappeared

I have an application written in C++ that querys all
available performance counters via RegQueryValueEx() API
at 10 second interval on some Windows 2000 computers that
have SQL Server 7.0 installed. After the application have
run for some period of time (several days or longer), the
SQL Server related performance counters disappeared. They
are disabeld by the OS. The knowledge base article
Q248993 mentions that the performance library of Windows
2000 disables any performance DLL that returns data in the
incorrect format, causes an unhandled program fault, or
takes too long to return the performance data (this is
usually the cause of a library being disabled). It is
obvious the incorrect format does not apply to my case
since it would have caused the problem right after it
started not several days later. Anyone knows what causes
the problem?Did you see Q812915?
"Tianxiang Zhang" <tianxiang_zhang@.bmc.com> wrote in message
news:013701c344b5$7f9caed0$a501280a@.phx.gbl...
> I have an application written in C++ that querys all
> available performance counters via RegQueryValueEx() API
> at 10 second interval on some Windows 2000 computers that
> have SQL Server 7.0 installed. After the application have
> run for some period of time (several days or longer), the
> SQL Server related performance counters disappeared. They
> are disabeld by the OS. The knowledge base article
> Q248993 mentions that the performance library of Windows
> 2000 disables any performance DLL that returns data in the
> incorrect format, causes an unhandled program fault, or
> takes too long to return the performance data (this is
> usually the cause of a library being disabled). It is
> obvious the incorrect format does not apply to my case
> since it would have caused the problem right after it
> started not several days later. Anyone knows what causes
> the problem?|||I did. They don't seem to be the same issue. Thanks for
the help.
>--Original Message--
>Did you see Q812915?
>
>"Tianxiang Zhang" <tianxiang_zhang@.bmc.com> wrote in
message
>news:013701c344b5$7f9caed0$a501280a@.phx.gbl...
>> I have an application written in C++ that querys all
>> available performance counters via RegQueryValueEx() API
>> at 10 second interval on some Windows 2000 computers
that
>> have SQL Server 7.0 installed. After the application
have
>> run for some period of time (several days or longer),
the
>> SQL Server related performance counters disappeared.
They
>> are disabeld by the OS. The knowledge base article
>> Q248993 mentions that the performance library of Windows
>> 2000 disables any performance DLL that returns data in
the
>> incorrect format, causes an unhandled program fault, or
>> takes too long to return the performance data (this is
>> usually the cause of a library being disabled). It is
>> obvious the incorrect format does not apply to my case
>> since it would have caused the problem right after it
>> started not several days later. Anyone knows what
causes
>> the problem?
>
>.
>sql

Performance

I have sql server running an enterprise software with
several clients. After running for about a week sql server
increasingly uses all the available memory until
performace becomes unacceptable. Is this normal or is
there a configuration or patch that I need to apply?
thanksHave a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"scat" <anonymous@.discussions.microsoft.com> wrote in message
news:0ff801c393dc$aaa93550$a101280a@.phx.gbl...
> I have sql server running an enterprise software with
> several clients. After running for about a week sql server
> increasingly uses all the available memory until
> performace becomes unacceptable. Is this normal or is
> there a configuration or patch that I need to apply?
> thanks
>