Reporting Server: Queries Timing Out Under Load

From DocWiki

(Difference between revisions)
Jump to: navigation, search
(New page: == Queries Timing Out Under Load == <table border="1"><tr><td> '''Problem Summary''' </td><td>Queries are timing out under load. </td></tr><tr><td> '''Error Message''' </td><td>No messa...)
m (1 revision)

Revision as of 18:11, 18 September 2009

Queries Timing Out Under Load

Problem Summary Queries are timing out under load.
Error Message No message displays.
Possible Cause This is typical response when the database is under heavy load.
Recommended Action Consider querying the database when the database is not under heavy load.

You might also try to reduce contention with active processes using the following statements:

  • SET LOCK MODE WAIT 30
    the WAIT <seconds> option causes the session to suspend the process until the lock releases or until the waiting period ends.
  • SET ISOLATION DIRTY READ
    this option instructs the session not to place locks on the data when it is attempting to read, and potentially read data ignoring existing locks.
Release Release 7.0(2)
Associated CDETS # None.

Rating: 0.0/5 (0 votes cast)

Personal tools