August 23, 2007 at 4:01 am
Hi all,
Has anyone noticed an issue when a report takes longer to run via a Sharepoint Integrated Reporting Services site than it does via the design studio preview? This is with SQL Version 2005 and WSS 3.0 SP2 and even after the web application has "worken up", i.e. after it has been first used.
The difference is quite noticeable. I would say that via the design studio the report takes less than a third of the time is takes via Sharepoint/Reporting Services.
Is there any IIS optomisation we can do ? I would have thought that visual studio design studio used the same engine as the web site though.
We have a dual core 64 bit server with 8GB of memory so resources shouldn't be an issue!
Thanks
Matthew
August 24, 2007 at 4:05 am
Hi,
> Is there any IIS optomisation we can do ? I would have thought that visual studio design studio used the same engine as the web site though.
It could help if you use an extra application pool for Reporting Services and sharepoint. A seperate process with it's own resources should be used then. You could even set the thread numbers seperately then.
You could check the performance of your reports and how much time is needed for which action with this query in Reportserver database.
--your reportserver database
use
Reportserver
go
--query to check for performance bottlenecks
select
cat.name,ex.TimeStart,ex.TimeEnd,ex.TimeDataRetrieval,ex.TimeProcessing,ex.TimeRendering,
ex
.UserName,ex.ByteCount,ex.[rowcount],*
from
Reportserver.dbo.ExecutionLog ex with (nolock) INNER JOIN Reportserver.dbo.Catalog cat with (nolock)
ON
ex.ReportID = cat.ItemID
where
ex.TimeStart > convert(datetime,'2007-05-08',120) and
--ex.UserName = 'YourDomain\Username' and
cat
.name = 'YourReport' and
ex
.Status = 'rsSuccess'
order
by ex.TimeStart
--query which shows names of all Reports
select
distinct cat.name
from
dbo.Catalog cat with (nolock)
order
by cat.name
Hope this helps,
Stefan
SK
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply