none
Slow execution times for Reporting (Project Publish) in 2007 Environment RRS feed

  • Question

  • Dear All.

    We are facing slow response times when dealing with "Reporting (Project Publish)" Jobs in a 2007 Environment: saving Plans to Draft and Published is quite fast (also for huge Projects) but the Reporting Job is often slow with peak times of 2-3 hours (for a 80 MB Plan) and job completion times that often exceed 40 minutes.

    Reporting DB size is about 35 GB with 5 GB of available space in DB File; SQL Maintenance Plan is in place for Published and Reporting DB and it runs every night.

    We executed a profiler trace but SQL Engine Tuning Advisor did not provide any special advice; execution of the few tasks proposed by P12ACTool did not mitigate the problem as well. 

    Any hint to further analyse and possibly speed up the process?

    Many thanks,

    Paolo


    Paolo Ajani - KPNET

    Wednesday, July 25, 2012 7:42 AM

All replies