none
PWA Task list loading long time RRS feed

  • Question

  • Our company using Task to report work status.

    In this few week , the PWA task page(http://projectserver/pwa/tasks.aspx)

    every time need more than 3 mins to loading.

    Before just need few second to loading all task.

    already reboot the server.

    But can't fix it.

    Please Help


    Thursday, January 24, 2013 9:08 AM

All replies

  • Hi there,

    Have you set up the correct database maintenance plans?

    http://technet.microsoft.com/en-us/library/cc973097.aspx

    Also have you set the correct optimisations for SQL:

    http://pwmather.wordpress.com/2012/09/14/projectserver-optimisations-for-sql-server-and-ps2010-databases-sp2010-msproject/

    Execute the following SQL against all 4 Project Sever PWA databases then retest to see if there is an improvement:

    EXEC sp_updatestats

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Thursday, January 24, 2013 1:16 PM
    Moderator
  • Not yet,

    because the sql server not administration by me.

    May i know have other setting can do first?


    • Edited by Arvin Wong Friday, January 25, 2013 3:49 AM
    Friday, January 25, 2013 2:40 AM
  • Hello,

    No other settings, for all perfromances issue start with the SQL Server to make sure the correct maintenance plans are in place and also that the SQL Server is optimised for SharePoint / Project Server. Pass this over to your SQL Server DBA to review.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Saturday, January 26, 2013 8:52 AM
    Moderator
  • Hi Arvin,

    As Paul has provided you with some really handful of optimization scripts requires to be executed at DB server.

    Additionaly you can also look into these points in order to enhance your PWA loading time.

    1. Is your sever connected to internet? because if the server hosting the PWA is not connected to the internet, you have to actively do something to avoid performance being impacted. This was also blogged here by Brian Smith in detail: 

    http://blogs.msdn.com/b/brismith/archive/2012/03/05/project-server-2010-slow-load-times-of-pwa-and-sharepoint-pages.aspx

    You have to  disabled the timeouts for the certificates verification in the SharePoint server, this component is on by default and , whenever an application is presented with a certificate that is not present in the trusted root store, it will attempt to contact Microsoft download servers to get the latest root chain. 

    You need to by pass this validation, please see the above mentioned blog in detail for the steps.

    2. And perphaps you can also give it a try to this warm up tool available here : http://spswarmup.codeplex.com/

    this will help speed up the load time of your PWA pages, and lot of people use this to improvise the load time.

    Hope this helps.


    Khurram Jamshed - MBA, PMP, MCTS, MCITP ( Blog, Twitter, Linkedin )

    Sunday, January 27, 2013 6:53 AM