sql2005, long running queries, will "remote login time out " option would help if I increase the value
Hi,
I have a scenario where the store procedure running extremely slow >30 sec from the web client so in sql server 2005 configurations properties "remote login time out", will it help if I increase the default value which is 20 sec to something bigger >40 sec, will this option resolve the time out issue from web client.
and what is the difference between this option with "remote query time out" that come with 0 as default values
I have a scenario where the store procedure running extremely slow >30 sec from the web client so in sql server 2005 configurations properties "remote login time out", will it help if I increase the default value which is 20 sec to something bigger >40 sec, will this option resolve the time out issue from web client.
and what is the difference between this option with "remote query time out" that come with 0 as default values
Last Comment
possibly changing the default will help but I'd be looking to see if i could improve the stored proc to return data in a more timely way. What is it doing that it takes over 30 seconds?
ASKER
when it execeeded 20 sec, the we client does not display the data, giving me page not found. I need to know which option is the most appropriate according to my error? its remote login time out or remote query time out?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
