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 (1)
  1. Lately I’ve heard a few requests to improve the Project Server queue performance. For instance some of

Comments are closed.

Skip to main content