Maximum Capacity Specifications for SQL Server 2008 Express - User connections

Question

I'm looking for this specification, but not find. Can you tell me?

The maximum number of connections supported by SQL Server 2008 Express!

thanks

Answer 1

Hi

Execute the following T-SQL to know it.

SELECT @@MAX_CONNECTIONS

The actual number of user connections allowed also depends on the version of SQL Server you are using and the limits of your application or applications and hardware. SQL Server allows a maximum of 32,767 user connections.

Because user connections is a dynamic (self-configuring) option, SQL Server adjusts the maximum number of user connections automatically as needed, up to the maximum value allowable. For example, if only 10 users are logged in, 10 user connection objects are allocated. In most cases, you need not change the value for this option. Use sp_configure to determine the maximum number of user connections that your system allows.

Refer http://msdn.microsoft.com/en-us/library/ms143432.aspx for more information.

http://msdn.microsoft.com/en-us/library/ms187030.aspx for setting the user connection

Thanks
Sreekar

Answer 2

ok, but this specifications in your references, they are to the version Express too?

thanks

Answer 3

Yep, no additional restrictions except that one mentioned on the comparison site here:

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

-Jens K. Suessmeyer

Answer 4

thanks for the help!