SWQL Timeout issue

Hi,

We have an NTA report based on processing the amount of traffic transferred in a period of time (1 calendar month) and as this is a very large data set, we often hit timeout issues where the query exceeds the 2 minute timeout value.

Is there a configuration setting that allows this timeout to be adjusted, as I do not feel we are able to optimise the query any more, as we need Interface name filters and a SUM on a sub query.

The NTA flow storage server is pretty powerful with lots of RAM and Raided SSD storage.

Find more posts tagged with

netflow_traffic_report

netflow reporting

Accepted answers

tdanner

Edit C:\Program Files (x86)\SolarWinds\Orion SDK\SWQL Studio\SwqlStudio.exe.config and find this piece around line 33:

</setting>

And change the "2" to some higher value. It's in minutes. Restart SWQL Studio.

All comments

tdanner

Edit C:\Program Files (x86)\SolarWinds\Orion SDK\SWQL Studio\SwqlStudio.exe.config and find this piece around line 33:

</setting>

And change the "2" to some higher value. It's in minutes. Restart SWQL Studio.

m_roberts

Hi Tim

Thanks for this. Next question is how to then apply this in the web interface, as that is also timing out and as mentioned it is not possible to divide up the report into smaller chunks as the purpose of the report is to aggregate traffic over 1 month where total traffic per IP address source is over xGB.

thanks

Mark

tdanner

What is the specific timeout error you are hitting? There are multiple levels of timeout between the browser, IIS, and various backend services that contribute to the report.

m_roberts

The NTA report is collating bandwidth consumption across a couple of defined interfaces, with a links to the IP address groups to allow per customer reporting to be performed.

Increasing the SWQL Studio timeout allowed the report data to be returned, but it is still timing out when running via the Report area of the web application, with the following response.

URL: http://<orionserver>:80/Orion/NetPerfMon/ntareport.aspx

Referrer: http://<orionserver>:80/Orion/NetPerfMon/ntareport.aspx

Message: Request timed out.

ErrorSite:

ErrorType: System.Web.HttpException

KMSigma.SWI

Sidebar: Can you provide the SWQL that you are running? There may be a way to optimize it.