Additional System Monitor Counter Monitoring (Windows SharePoint Services 2.0)

  • Article

Monitoring these System Monitor counters can help system administrators understand the system load and service usage information. The collected data can be further referred to pursue continuous capacity planning. Because Windows SharePoint Services has its own ISAPI filter and uses the Microsoft .NET Framework, it is also worthwhile to monitor the following front-end and back-end System Monitor counters and events.

Additional Monitoring Rules on Front-End Servers

  • Process(w3wp)\% Processor Time Process(w3wp)\Private Bytes

  • Process(w3wp)\Working Set Process(w3wp)\Handle Count

  • .NET CLR Memory\# Bytes in All Heaps

  • .NET CLR Memory\Large Object Heap Size

  • .NET CLR Memory\% Time in GC

  • ASP.NET\Worker Process Restarts

Additional Monitoring Rules on Back-End Servers

  • Process(sqlservr)\% Processor Time

  • Process(sqlservr)\Working Set

  • SQLServer:General Statistics\User Connections

  • SQLServer:Locks\Number of Deadlocks/sec

  • SQLServer:Locks\Lock Waits/sec

  • SQLServer:Locks\Lock Wait Time (ms)

  • SQLServer:SQL Statistics\Batch Requests/sec