前幾天一同事反映海外工廠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
新聞熱點
疑難解答