Project Server 2010 performance counters

 

Applies to: Project Server 2010

Topic Last Modified: 2011-03-14

To help you determine when you have to scale up or scale out your Microsoft Project Server farm, use performance counters to monitor the health of the system. Use the information in the following tables to determine which performance counters to monitor, and to which process the performance counters should be applied:

  • Web servers

  • Database servers

  • Project Application Server performance counters

Web servers

The following table shows performance counters and processes to monitor for Web servers in your Project Server farm.

Performance counter Apply to object Notes

Processor Time

Total

Shows the percentage of elapsed time that this thread used the processor to execute instructions.

Memory Utilization

Application Pool

Shows the average utilization of system memory for the application pool. You must specify the correct application pool to monitor. The basic guideline is to determine peak memory utilization for a given Web application, and assign that number plus 10MB to the associated application pool.

Database servers

The following table shows performance counters and processes to monitor for database servers in your farm.

Performance counter Apply to object Notes

Average disk queue length

Hard disk that contains SharedServices.mdf

Average values larger than 1.5 per spindle indicate that the write times for that hard disk are insufficient.

Processor time

SQL Server process

Average values larger than 80 percent indicate that processor capacity on the database server is insufficient.

Processor time

Total

Shows the percentage of elapsed time that this thread used the processor to execute instructions.

Memory utilization

Total

Shows the average utilization of system memory.

Project Application Server performance counters

The following table shows performance counters and processes to monitor for your Application Server.

Performance counter Apply to object

% Sql Retries / Day

ProjectServer:QueueGeneral

Active Job Processing Threads

ProjectServer:QueueGeneral

Active Job Processing Threads

ProjectServer:QueueGeneral

Average Unprocessed Jobs / Day

ProjectServer:QueueGeneral

Current Unprocessed Jobs

ProjectServer:QueueGeneral

New Jobs / Minute

ProjectServer:QueueGeneral

Sql Calls / Hour/Day

ProjectServer:QueueGeneral

Sql Calls / Minute

ProjectServer:QueueGeneral

Sql Retries / Minute

ProjectServer:QueueGeneral

% Jobs Failed / Day

ProjectServer:QueueJobs

% Jobs Failed / Hour

ProjectServer:QueueJobs

% Jobs Retried / Day

ProjectServer:QueueJobs

% Jobs Retried / Hour

ProjectServer:QueueJobs

Average Processing Time / Day

ProjectServer:QueueJobs

Average Processing Time / Minute

ProjectServer:QueueJobs

Average Wait Time / Day

ProjectServer:QueueJobs

Average Wait Time / Minute

ProjectServer:QueueJobs

Jobs Failed / Minute

ProjectServer:QueueJobs

Jobs Processed / Hour/Day

ProjectServer:QueueJobs

Jobs Processed / Minute

ProjectServer:QueueJobs

Jobs Retried / Minute

ProjectServer:QueueJobs

Average time taken for Project Open

ProjectServer:Winproj

Percentage of incremental save to full save

ProjectServer:Winproj

Winproj full open count in the last hour

ProjectServer:Winproj

Winproj full save count in the last hour

ProjectServer:Winproj

Winproj incremental open count in the last hour

ProjectServer:Winproj

Winproj incremental save count in the last hour

ProjectServer:Winproj