Post reply

Performance Monitor Problem

  • April 16, 2003 at 7:26 am

    #65287

    I am using windows xp performance monitor to monitor the remote sql 2000 server with sql sp3. I am monitroing following counters

    Memory\Pages/sec

    Network Interface\Bytes Total/sec

    PhysicalDisk(_Total)\Avg. Disk Queue Length

    Processor(_Total)\% Processor Time

    SQLServer:Access Methods\Page Splits/sec

    SQLServer:Buffer Manager\Buffer cache hit ratio

    SQLServer:Cache Manager(_Total)\Cache Hit Ratio

    SQLServer:General Statistics\User Connections">

    SQLServer:Memory Manager\Total Server Memory (KB)

    If I stop/start MSSQLServer and Agent services on sql server then I am loosing all sql performance counters until reboot the SQL server. I tried same countres on another SQL 2000 server with SP2, I did not have any the problem. Is there any way I can enable the SQL performance counters without rebooting the SQL server on sQL 2000 with SP3?. I also tried unlodctr.exe and lodctr.exe the SQL counters.

    Thanks

    Manesh

  • April 16, 2003 at 8:02 am

    #454356

    What do you mean reboot SQL Server? Do you reboot the machine or just restart SQL Server?

    You only need to restart SQL Server (SQL Server and Agent services).

    Stop SQL Server services will definitely lose the SQL Server performance counters from performance monitor. I would think there is something worng you were still able to to see them when you tried on SQL Server 2000 with SP2.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply