Link to home
Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America

asked on

performance of report on ssrs

query performance question.  I have a query that uses multiple databases(the databases are all on the same instance of sql).  The query takes about a minute to complete.  This is acceptable, but when ssrs runs off this dataset, it is painfully slow.   4 to 5 minutes to render.  

1) is it normal for there to be a drop off in the speed of ssrs displaying the results as compared to the actual speed of the query in ssms.  I suspect there should be but, is 4 to 5 times something that i should be wary of?
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Jim Metcalf

ASKER

We redesigned the query...  it runs better now