Home Forums SQL Server 2005 Administering timeouts on resource intensive queries on all dbs RE: timeouts on resource intensive queries on all dbs

  • Timeout is thrown by our iis (timeout is set to 30 secs) but when I run those queries manually they run and run and after couple minutes i just cancel them.

    If there is anything that blocks those queries it has to be at server level because we got timeouts from both dbs. It seems like one of resources is under pressure but after clearing proc cache or updating statistics they run normally again.Any thoughts?