Hi,
I have a component that is executing a query on a SQL Server with high response times, often passing the component due to Down Query TimeOut.Is it possible to establish a larger query timeout to avoid this problem?Thank you very much.
Unfortunately it is not possible in the current version. We are already tracking this as a Feature Request.
what is the timeout set to? if you create a separate template with it's own timeout setting, does that not have the desired affect or is it controlled by something else?
we too have queries that sometimes take 30 seconds to compute and other times take 15 minutes.
I don't know how to accomplish this technically, but one thought I had was to write sql script job that runs every 30 minutes on each of our SQL servers that writes the result of our query to a txt file (it's just a number). and then every 30 minutes have the polling engine read that file into Orion.
again, not technical enough to know how, just know this could be done from what I hear.
