SSRS Reports 2008性能优化案例二

9/1/2015来源:SQL技巧人气:1159

SSRS Reports 2008性能优化案例二 2015-07-17 16:12 by 潇湘隐者, ... 阅读, ... 评论, 收藏, 编辑

前几天一同事反映海外工厂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 
<PRe style="border-top-style: none; overflow: visible; font-size: 12pt; font-family: 'Courier