Reporting Server: Queries Timing Out Under Load

Revision as of 19:03, 18 December 2009 by Docwikibot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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)