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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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!


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Project Management Software

From novice to tech pro — start learning today.