Post reply

Query timeout

  • January 17, 2006 at 5:44 pm

    #113158

    Hi All,

    I have to query around 30 SQL servers in my domain to get data from different tables present in each of those databases. The problems is that if one of the dbserver is experiencing heavy usage or is having blocks, my query will timeout without getting data from remaining servers. What I would like to do is to ignore the query result from that server server if I dont get response within 1 min(Avg time for query result). How can I accomplish so that I collect data from others even when 1 or more servers fail to return data within specified time.

    Thanks in Advance.

    Regards,

    Prashanth

  • January 17, 2006 at 5:48 pm

    #615335

    I think it would be better if you consolidate all the data you need from all 30 SQL Servers to 1 central Database. This would be much better for perfromance as well as other reasons.

    You can achieve this with a DTS Package that could run overnight.

    Kindest Regards,

  • January 17, 2006 at 5:51 pm

    #615336

    Thanks Addict for information. I am collecting data from 30 different sql servers to my inventory database server. Also, I want have this job run every 1 hr and I have a webpage that should give recent data from this inventory db server. Hence I need a way to trap query timeout and move on with other server

  • January 17, 2006 at 6:03 pm

    #615337

    Have a look at the Remote Query Timeout option. You set this with sp_configure.

    Kindest Regards,

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply