Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Reports: SQL Error Timeout Expired

I am trying to generate the "Average and Peak Traffic Rates" report and I consistently get an error. The error is SQL Error:Timeout Expired. Does anyone know how to resolve the issue? I have increased the SQL query timeout to the maximum of 20 minutes and I continue to get the error after only 1 minute.

Find more posts tagged with

Accepted answers

All comments

iunderwo

In addition to the application timeout, I think there needs to be an increase on the timeout at the SQL server itself.

// Ian Underwood - Network Engineering
// Boston Stock Exchange

Network_Guru

Another thing to try, is to tweak your query.
Keep in mind that how you order the query has a big impact on the DB response time. Make sure you have the most specific query first.

Example, if you have 500 nodes & 8000 interfaces & you want an interface report for specific interfaces, try to filter out the nodes first, before you filter/query the interface data.

-=Cheers=-
NG

savell

Have a look here also..

www4.solarwinds.net/.../topic.asp

Sav.