project 2007 performance checker

Posted on 2008-11-13
Last Modified: 2013-11-15
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

Question by:ITDataCenter
    LVL 18

    Accepted Solution

    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!

    LVL 1

    Author Comment

    Thanks Lars for your help!
    do you know any best practices for MS project Server 2007? thank you. Andrea.
    LVL 1

    Author Comment

    upgraded to ESX 3.5 and added new hosts. the performance looks better.
    LVL 1

    Author Comment

    upgraded to ESX 3.5 and added new hosts. the performance looks bett
    LVL 18

    Assisted Solution

    After upgrading, also make sure you upgrade VMware Tools in your VMs.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    VMware vCenter Converter Standalone 5.0 is a FREE tool available from VMware upon registration, the purpose of this software tool is to easily convert physical or virtual computers, images of computers to VMware virtual machines. Server and Workstat…
    Learn about cloud computing and its benefits for small business owners.
    Teach the user how to install log collectors and how to configure ESXi 5.5 for remote logging Open console session and mount vCenter Server installer: Install vSphere Core Dump Collector: Install vSphere Syslog Collector: Open vSphere Client: Config…
    Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now