前幾天一同事反映海外工廠A的SSRS報(bào)表比較慢，讓我檢查優(yōu)化一下。于是我檢查了下2015-07-13到2015-07-15 12:00這段時(shí)間報(bào)表的耗時(shí)記錄

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