EPM & SharePoint Performance Counters
Following Joel Oleson’s blog post on SharePoint performance counters please find below a list of EPM performance counters.
I’m sure you are all already monitoring these in your production environment!
|
Front End Perf Counters |
Back End (SQL Server) Performance Counters | ||
|
Object |
Counter |
Object |
Counter |
|
ASP.NET |
Application Restarts |
Processor(_Total) |
% Processor Time |
|
ASP.NET |
Request Execution Time |
|
|
|
ASP.NET |
Request Wait Time |
Memory |
Pages/sec |
|
ASP.NET |
Requests Queued |
|
|
|
ASP.NET |
Requests Rejected |
PhysicalDisk(_Total) |
Current Disk Queue Length |
|
ASP.NET |
Worker Process Restarts |
PhysicalDisk(_Total) |
Disk Read Bytes/sec |
|
|
PhysicalDisk(_Total) |
Disk Write Bytes/sec | |
|
Memory |
Available Bytes |
|
|
|
Memory |
Pages/sec |
Process(sqlservr) |
% Processor Time |
|
Memory |
Pages/sec |
Process(sqlservr) |
Private Bytes |
|
|
Process(sqlservr) |
Working Set | |
|
Process(LSASS) |
% Processor Time |
|
|
|
Process(OWSTIMER) |
% Processor Time |
SQLServer:Databases |
Transactions/sec |
|
Process(OWSTIMER) |
% Processor Time |
SQLServer:General Statistics |
User Connections |
|
|
SQLServer:Locks(_Total) |
Lock Wait Time (ms) | |
|
Process(w3wp) |
% Processor Time |
SQLServer:Locks(_Total) |
Lock Waits/sec |
|
Process(w3wp) |
Page Faults/sec |
SQLServer:Locks(_Total) |
Number of Deadlocks/sec |
|
Process(w3wp) |
Page File Bytes |
SQLServer:SQL Statistics |
Batch Requests/sec |
|
Process(w3wp) |
Page File Bytes Peak |
|
|
|
Process(w3wp) |
Private Bytes |
System |
Context Switches/sec |
|
Process(w3wp) |
Private Bytes |
|
|
|
Process(w3wp) |
Virtual Bytes |
|
|
|
Process(w3wp) |
Virtual Bytes Peak |
|
|
|
Process(w3wp) |
Working Set |
|
|
|
Process(w3wp) |
Working Set |
|
|
|
Process(w3wp) |
Working Set Peak |
|
|
|
|
|
| |
|
Processor(_Total) |
% Processor Time |
|
|
|
|
|
| |
|
System |
Context Switches/sec |
|
|
|
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib | |
|
ProjectServer:QueueGeneral |
ProjectServer:QueueJobs |
|
% Sql Retries / Day |
% Jobs Failed / Day |
|
% Sql Retries / Hour |
% Jobs Failed / Hour |
|
Active Job Processing Threads |
% Jobs Retried / Day |
|
Average Unprocessed Jobs / Day |
% Jobs Retried / Hour |
|
Current Unprocessed Jobs |
Average Processing Time / Day |
|
New Jobs / Minute |
Average Processing Time / Minute |
|
Sql Calls / Hour/Day |
Average Wait Time / Day |
|
Sql Calls / Minute |
Average Wait Time / Minute |
|
Sql Retries / Minute |
Jobs Failed / Minute |
|
|
Jobs Processed / Hour/Day |
|
|
Jobs Processed / Minute |
|
|
Jobs Retried / Minute |
|
|
|
|
ProjectServer:Winproj |
ProjectServer:User Activity |
|
Average time taken for Project Open |
PSI Calls per Second |
|
Percentage of incremental save to full save |
|
|
Winproj full open count in the last hour |
|
|
Winproj full save count in the last hour |
|
|
Winproj incremental open count in the last hour |
|
|
Winproj incremental save count in the last hour |
|
Comments
- Anonymous
March 20, 2008
Lately I’ve heard a few requests to improve the Project Server queue performance. For instance some of