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