ASP.NET MVC调试非常慢 - SQL Server的防爆preSS连接问题？ [英] ASP.NET MVC Debugging Very Slow - SQL Server Express Connection Issue?

问题描述

我在开发ASP.NET MVC应用程序，使用SQL Server防爆preSS作为后端和卡西尼作为开发Web服务器（随Visual Studio 2008中的一个）。

I am developing an application in ASP.NET MVC, using SQL Server Express as the backend and Cassini as the development web server (the one that comes with Visual Studio 2008).

应用程序的性能极快的（几乎是瞬时的页面切换）。然而，纺调试器是十分缓慢;它需要大约30秒，从我打F5到ASP.NET欢迎页面出现的时间的时间。

The application performance is blazingly fast (nearly instantaneous page switches). However, spinning up the debugger is painfully slow; it takes about 30 seconds from the time I hit F5 to the time the ASP.NET welcome page comes up.

加载SQL Server Management Studio中前preSS时，我已经注意到了类似的延迟，当我在我的数据库首次进行查看打开表再次推迟。我打开我的第一个表后，一切顺利。

I have noticed a similar delay when loading SQL Server Management Studio Express, and another delay when I open a table in my database for the first time for viewing. After I open my first table, everything goes smoothly.

由于SQL Server Management Studio中前preSS的行为，我怀疑问题出在制作到SQL Server防爆preSS的初始连接。这真的是哪里出了问题，如果是这样，我怎么能解决这个问题？

Given the behavior of SQL Server Management Studio Express, I suspect that the problem lies in making the initial connection to SQL Server Express. Is this really where the problem is, and if so, how can I fix it?

推荐答案

我终于解决了通过重建我的TCP / IP协议栈，使用的NetShell从命令提示符窗口中的问题。显然，我得到一个TCP / IP超时。

I finally solved the problem by rebuilding my TCP/IP stack, using Netshell from a Command Prompt window. Apparently I was getting a TCP/IP timeout.

netsh int ip reset c:resetlog.txt

http://support.microsoft.com/kb/299357

这篇关于ASP.NET MVC调试非常慢 - SQL Server的防爆preSS连接问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！