April 16, 2003 at 7:26 am
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
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