如何修复C＃.net和MS sql server 2000中的超时过期 [英] how to fix timeout expired in C#.net and MS sql server 2000

问题描述

当我执行查询时，它很好。但是我从程序运行发生超时到期。我已经将命令超时增加到600并将sql server执行超时增加到1800并将连接超时增加到500.Timeout过期发生超过4分钟。

为什么会出现这个错误？请帮助我并告诉我如何解决这个问题。请解释为什么会这样。请提前谢谢。

When I execute query, it is fine.But I run from program occur timeout expired.I already increase command timeout to 600 and increase sql server execution timeout to 1800 and increase connection timeout to 500.Timeout Expired occur in over 4 minutes.
Why did this error occur?Please help me and give me a way how to fix this.Please explain why this occur.Thanks in advance.

推荐答案

要做的第一件事是调试程序并查看问题发生的操作。如果是执行SQL语句，请检查您是否正确提供了所有参数，并且SQL语句看起来应该是这样。



之后你可以使用profiler来调查更多，在执行语句期间会发生什么。请参阅使用SQL事件探查器进行监控 [ ^ ]。

The first thing to do is to debug the program and see on what operation the problem is occuring. If it is the execution of the SQL statement, check that you have provided all parameters correctly and the SQL statement looks as it should.

After that you can use profiler to investigate more, what happens during the execution of the statement. See Monitoring with SQL Profiler[^].

这篇关于如何修复C＃.net和MS sql server 2000中的超时过期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！