Geek Answers Handbook

SQL Express Parallel Connections 2005/2008

How many parallel connections do express editions allow?

My interface uses the standard ADO.Net code, where I open a connection to the server, get my data and close the connection. Am I right in saying that as soon as the connection is closed, will it allow another user to open this opening?

+6
sql sql-server
source share
2 answers

SQL Server Express Editions do not limit the number of concurrent connections — they limit other ways — such as the maximum database size (4 GB), processor sockets (1), and memory size (1 GB).

More details here .

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

+10
source share

.net handles all this for you. It creates a connection pool on a unique connection string, and your database calls will share the connection .. Net really does not open / close real connections when you call conn.Open (), connection pools combine this.

+1
source share

More articles:


All Articles