SQL连接超时错误 [英] SQL Connection TimeOut Error

问题描述

我有一个SP，可以从三个不同的数据库中获取数据.
要获取数据大约需要40-50秒.

当我从开发环境即Visual Studio Asp.Net 3.5(Local PC)调用此SP时，它可以正常工作.

但是当我实时部署这些东西时，它会出现以下错误

错误:超时已过期.操作完成之前已过超时时间，或者服务器没有响应.

我尝试使用一些最大值设置连接超时"，命令超时"，执行超时".但是我失败了.所以现在我需要您的帮助.

感谢您提供有效的答案.

谢谢.

Hi,

I have a SP Which fetch data from three different database.
To fetched the data it takes approximately 40-50 seconds.

When I call this SP from my development environment i.e. Visual Studio Asp.Net 3.5 (Local PC) it works fine.

But when i deploy the things on live it gives me below error

Error : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I tried setting Connect Timeout, Command Timeout, Execution Timeout with some max values. But I failed. So now i need your help.

Valid Answers are appreciated.

Thank you.

推荐答案

嗨
请在这里检查我的帖子，并让我知道thaat是否对您有帮助.

http://www.codeproject.com/Answers/123878/Application-Database- Performance-becomes-slow#answer1

Hi
Plese check my post here and let me know if thaat helps you.

http://www.codeproject.com/Answers/123878/Application-Database-Performance-becomes-slow#answer1

这篇关于SQL连接超时错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！