Sunday, January 1, 2012

Performance counters for Sharepoint 2010 WFEs

Hi, this is a set of performance counters covering both general performance and counters for how Output & ASP.NET cacheing works (providing you have them enabled) including problem description an possible resolution options.

Objects and Counters Problem Resolution Options
Processor
% Processor Time (_Total) Over 75-85% Upgrade processor
Increase number of processors
Add additional server(s)
% Processor Time - Process (w3wp)
% Processor Time - Process (OWSTIMER)
Disk
Avg. Disk Queue Length Gradually increasing, system not in a steady state and queue is backing up Increase number or speed of disks
Change array configuration to stripe
Move some data to an alternative server
% Idle Time Greater than 90% Increase number of disks
Move data to an alternative disk or server
% Free Space Less than 30% Increase number of disks
Move data to an alternative disk or server
Memory
Available Mbytes Less than 2GB on a Web server. Add memory.
note
 Note:
SQL server available memory will be low, by design, and does not always indicate a problem.
Cache Faults/sec Greater than 1 Add memory
Increase cache speed or size if possible
Move data to an alternative disk or server
Pages/sec Greater than 10 Add memory
Paging File
% Used and % Used Peak The server paging file, sometimes called the swap file, holds "virtual" memory addresses on disk. Page faults occur when a process has to stop and wait while required "virtual" resources are retrieved from disk into memory. These will be more frequent if the physical memory is inadequate. Add memory
NIC
Total Bytes/sec Over 40-50% of network capacity. This is the rate at which data is sent and received via the network interface card. Investigate further by monitoring Bytes received/sec and Bytes Sent/sec.
Reassess network interface card speed
Check number, size, and usage of memory buffers
Process
Working Set Greater than 80% of total memory Add memory
% Processor Time Over 75-85%. Increase number of processors
Redistribute workload to additional servers
ASP.NET
Errors/sec The number of errors per second that occur during the execution of HTTP requests, including any parser, compilation, or run-time errors
Application Pool Recycles Should be as low as possible, 0 or close to.Several per day, causing intermittent slowness.  Make sure that you have not implemented settings that automatically recycle the application pool unnecessarily throughout the day.
Worker Process Restarts The number of times a worker process has been restarted on the server computer. A worker process can be restarted if it fails unexpectedly or when it is intentionally recycled. If this counter increases unexpectedly, you should investigate as soon as possible.
Requests Queued Hundreds or thousands of requests queued. Implement additional Web servers
The default maximum for this counter is 5,000, and you can change this setting in the Machine.config file
Request Wait Time As the number of wait events increases, users will experience degraded page rendering performance. Implement additional Web servers
Requests Rejected Greater than 0 Implement additional Web servers
Application Restarts Should be as low as possible, 0 or close to.Several per day, causing intermittent slowness. 
Cache Total Entries The total number of entries in the cache. 
Cache Total Hits The total number of hits from the cache. 
Cache Total Misses The number of failed cache requests per application. 
Cache Total Hit Ratio The ratio of hits to misses for the cache. 
Cache Total Turnover Rate The number of additions and removals to the cache per second, which is useful in helping to determine how effectively the cache is being used. If the turnover rate is high, the cache is not being used efficiently
Output Cache Entries The total number of entries in the output cache.
Output Cache Hits The total number of requests serviced from the output cache.
Output Cache Misses The number of failed output-cache requests per application.
Output Cache Hit Ratio The percentage of total requests serviced from the output cache.
Output Cache Turnover Rate The number of additions and removals to the output cache per second. If the turnover rate is high, the cache is not being used effectively.
Session SQL Server Connections Total The total number of session-state connections made to the Microsoft SQL Server database in which session-state data is stored.

© Copyright 2012, Tomas Elfving