Home Forums SQL Server 2005 Administering max worker threads RE: max worker threads

  • May 12, 2009 at 5:49 am

    #992766

    trayalacheruvu (5/12/2009)

    hi Markus,

    There are few queries which is taking time to execute..but in the application level they have set that connection timeout period as 100 sec. for testing purpose i am planing to change this 100 sec to 200sec. after changing 200sec if its not giving the time error means we can optimize those long running queries. I have created indexes each and every table. and all the indexes are making use of the application.

    Thanks,

    Thulasi

    You should look for the query timeout, not the connection timeout. The connection timeout is just how long will it wait for the sewrver to respond when logging on to the database. The query timeout means how long the app waits for the results of a query.

    [font="Verdana"]Markus Bohse[/font]