Hi Everyone,
I having a problem when generating the reports. Some time, the report generation are slow and there is frequent intermitten reporting svcs error such as process ID 86 or Deadlock victim error. But, some time the report generation are ok.
Please help !! Thank you.
Best Regard,
Terence Wong
I am speculating - but
Is there a "deadly embrace" on the table you are going after - cause you are timing out - and that indicates to me there is another process (ID 86) that is causing the "hang"..
Or in the SQL statement do you have a JOIN that is not correct -
Take your SQL statement your are using within the MS RS report and paste into query analyzer and
Within Query Analyzer <Query> <Display Estimated Execution Plan> this wil ltell you where the hang up is based upon percentages for every step within the SQL statement. As a general rule anything over 30% could potentially be a problem!
best regards,
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment