SQL防爆preSS 2005/2008并发连接 [英] SQL Express 2005/2008 Concurrent Connections

问题描述

多少个并发连接不前preSS版本允许？

How many concurrent connections do the express editions allow?

我的前端使用标准的ADO.Net code，我打开连接到服务器，让我的数据，然后关闭连接。难道我说得对，只要连接被关闭时，它则允许由其他用户打开此连接？

My front end uses standard ADO.Net code where I open the connection to the server, get my data, and then close the connection. Am I right in saying that as soon as the connection is closed, it then allows this connection to be opened by another user?

推荐答案

SQL Server的EX preSS版本上不封顶的并发连接数 - 它们施加的限制在其他方面 - 例如最大尺寸数据库（4GB），CPU插座（1）和内存量（1GB）。

The express editions of SQL Server don't cap the number of concurrent connections - they exert limitations in other ways - such as the maximum size of the database (4GB), CPU sockets (1) and amount of memory (1GB).

这里更多信息。

More info here.

您说得有道理，当连接被关闭，其资源被立即释放。在这唯一需要注意的是.NET连接池。

You are right in saying that when a connection is closed, its resources are released immediately. The only caveat on this is connection pooling in .NET.

这篇关于SQL防爆preSS 2005/2008并发连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！