Additional System Monitor Counter Monitoring (Windows SharePoint Services 2.0)
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