I'm testing a C# application on SQL Server 2008. It used to work perfectly on 2005 Express edition, but now it seems to take ages to open connections to 2008 Express (default install, using sharedmem protocol).
我正在测试SQL Server 2008上的C#应用程序。它曾经在2005 Express版本上完美运行,但现在打开与2008 Express的连接似乎需要很长时间(默认安装,使用sharedmem协议)。
Also, repeteadly I got errors of connection problems.
而且,我还是遇到了连接问题的错误。
Any idea?
2 个解决方案
#1
Are you getting any error message? What does it say exactly?
你收到任何错误信息吗?这到底是什么意思?
Any chance that this has something to do with the default instance name problem?
这有可能与默认实例名称问题有关吗?
#2
Here is someone with the same problem:
这是有同样问题的人:
http://sql-server-performance.com/Community/forums/p/28118/159186.aspx
Appears that there are problems with statistics on upgraded databases. They recommend droping and recreating the database statistics.
出现升级数据库的统计信息存在问题。他们建议删除并重新创建数据库统计信息。
#1
Are you getting any error message? What does it say exactly?
你收到任何错误信息吗?这到底是什么意思?
Any chance that this has something to do with the default instance name problem?
这有可能与默认实例名称问题有关吗?
#2
Here is someone with the same problem:
这是有同样问题的人:
http://sql-server-performance.com/Community/forums/p/28118/159186.aspx
Appears that there are problems with statistics on upgraded databases. They recommend droping and recreating the database statistics.
出现升级数据库的统计信息存在问题。他们建议删除并重新创建数据库统计信息。