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 Ajani - KPNET

    Wednesday, July 25, 2012 7:42 AM

All replies