project 2007 performance checker

Hello Experts,
MS Office Project Server 2007 SP1 + Hotfixes KB950816, kb941426, kb936984
MS Project Professional 2007 SP1 + KB941657, KB946691
MS SQL 2005 data analysis SP2 + hotfixes 3175 (KB936305)
Windows 2003 STD Server + SP2 + last MS security patches
(all DBs are stored in a separated MSSQL 2005 A/P cluster - netapp SAN, iscsi)

I'm looking for a freeware tool that can help me checking the performance of the Project Server.
the project server is based on a VMware virtual machine, runnning on a ESX 3.0 host in a virtual center v2.0.2 DRS/HA infrastructure (4 hosts, tot 96GB - 45Ghz, 16cpu, 40 VMs)
I need this tool for investigating possible bootlenecks, server queues, all project server related engines tthat could be monitorized.
the goal is to find out why PWA is slow, why some check-in and publish processses take a lot of time to be completed.
Thanks for your help!
Andrea Tiozzo Cuccaro

Who is Participating?
Troubleshooting this issue can be a bit complicated and you might have to look into all the components involved. You should look both at theProject Server, SQL Server and the VMware ESX Environment. I don't think there's one single freely available tool that will point you directly to the direct solution here after analysing all these components. Hosting 40 VMs across 4 hosts is normally the easiest thing in the world as it's a very low consolidation ratio. The most obvious errors that are causing such issues is slow storage or giving your VMs too many vcpus.

1. Try using perfmon inside your VMs to monitor AvgDiskQueueLength, and the Page life expectancy on your SQL Server.
2. Use esxtop from your esx servers console to monitor %RDY.
3. Check your SANs cache hit ratio.

These simple things will often quickly reveal where the bottle neck is.

Further reading include:
Performance Tuning Best Practices for ESX Server 3
Setting up Performance Monitor to collect SQL Server performance statistics
Windows Server 2003 Performance Tuning

Good luck!

ITDataCenterAuthor Commented:
Thanks Lars for your help!
do you know any best practices for MS project Server 2007? thank you. Andrea.
ITDataCenterAuthor Commented:
upgraded to ESX 3.5 and added new hosts. the performance looks better.
ITDataCenterAuthor Commented:
upgraded to ESX 3.5 and added new hosts. the performance looks bett
After upgrading, also make sure you upgrade VMware Tools in your VMs.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.