Hoping some of you server-savvy types can help me out.
I have a report that is running slowly. I keep tweaking the SQL to improve the efficiency of the query. Seems to work great. I make the changes and run the report 3 or 4 times. Render time drops from 5 minutes to 40 seconds. Great!
An hour later, it's taking 5 minutes again without any additional changes having been made.
When I run the query from Management Studio it is plenty fast. Using the same parameters, I get results in 10 seconds. From BIDS or from Tessitura, it is several minutes.
Where should I be looking for the bottle neck?
It might be SSRS. I find that it slows down the processing. I tried running a report every hour but that doesn’t help.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: Wednesday, June 05, 2013 3:22 PM To: Gloria Ormsby Subject: [Tessitura Technical Forum] Report performance issue
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!