April 10, 2012 at 12:30 pm
Long story short: Oracle DBA creates an SSRS report for some users, but due to the way the Oracle partitions are setup, if 2 users runs the same report at the same time (same or different parameters), the entire oracle database grinds to a halt.
The report is running a very complicated SELECT. My first suggestion, put the select in a proc and code logic in there so that if the proc is already running it just returns an empty set or some message to the user instead of executing the ugly select, but that idea was shot down.
So, until the Oracle database re-partitioned, they've come to me for a way to keep a single reports from running if another request for that report is already running. Any ideas?
Thanks in advance.
-Mario
April 10, 2012 at 12:37 pm
Does the report need to gather real time data?
Or
Can you create a subscription and schedule for the report then also cache the results of that?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 10, 2012 at 12:38 pm
The report needs to get real time data. Subscriptions don't really work since the users will pretty much always run the report with different parameters every time.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply