SSRS Reports 2008性能优化案例二

前几天一同事反映海外工厂A的SSRS报表比较慢，让我检查优化一下。于是我检查了下2015-07-13到2015-07-15 12:00这段时间报表的耗时记录

USE [ReportServer]; 

GO

SELECT C.Name AS ReportName 

 ,E.ReportID AS ReportID 

 ,E.UserName AS UserName 

 ,E.Format AS Format 

 ,E.Parameters asparameters

 ,E.TimeStart AS TimeStart 

 ,E.TimeEnd AS TimeEnd 

 ,E.TimeDataRetrieval*1.0/1000 AS TimeDataRetrieval