How many user can login at a time using asp.net application?

Question

How many user can login at a time using asp.net application?

Jagz W

SSC Veteran

Points: 257
More actions
July 13, 2011 at 6:39 am

#254405

Hi all,
My question is how many users can login at a time using in sql server 2008?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

From http://technet.microsoft.com/en-us/library/ms179874(SQL.100).aspx

@@MAX_CONNECTIONS returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. The number returned is not necessarily the number currently configured.

The actual number of user connections allowed also depends on the version of SQL Server that is installed and the limitations of your applications and hardware.
To reconfigure SQL Server for fewer connections, use sp_configure.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 2

Oddly enough, this isnt true and is something Microsoft dont really reveal.

It is actually 32767 concurrent and running connections as its based on an smallint value but is generally not mentioned due to connection pooling.

Jagz W SSC Veteran Points: 257 More actions · Answer 3

Jagz W

SSC Veteran

Points: 257

July 13, 2011 at 10:49 am

#1352296

is the 32767 users can login to sql server?

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 4

MysteryJimbo (7/13/2011)
Oddly enough, this isnt true and is something Microsoft dont really reveal.
It is actually 32767 concurrent and running connections as its based on an smallint value but is generally not mentioned due to connection pooling.

Which statements on this thread or in the article are not true? :ermm:

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 5

walia_jagwinder (7/13/2011)
is the 32767 users can login to sql server?

What does this return on your server?

SELECT @@MAX_CONNECTIONS ;

You can also use this:

EXEC sys.sp_configure

@configname = 'user connections' ;

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 6

opc.three (7/13/2011)
MysteryJimbo (7/13/2011)
Oddly enough, this isnt true and is something Microsoft dont really reveal.
It is actually 32767 concurrent and running connections as its based on an smallint value but is generally not mentioned due to connection pooling.
Which statements on this thread or in the article are not true? :ermm:

This one

The actual number of user connections allowed also depends on the version of SQL Server that is installed and the limitations of your applications and hardware.
To reconfigure SQL Server for fewer connections, use sp_configure

If you have a server of high enough spec, the limitation is SQL itself. I've seen SQL reject connections due to high concurrency.

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 7

MysteryJimbo (7/13/2011)
opc.three (7/13/2011)
MysteryJimbo (7/13/2011)
Oddly enough, this isnt true and is something Microsoft dont really reveal.
It is actually 32767 concurrent and running connections as its based on an smallint value but is generally not mentioned due to connection pooling.
Which statements on this thread or in the article are not true? :ermm:
This one
The actual number of user connections allowed also depends on the version of SQL Server that is installed and the limitations of your applications and hardware.
To reconfigure SQL Server for fewer connections, use sp_configure
If you have a server of high enough spec, the limitation is SQL itself. I've seen SQL reject connections due to high concurrency.

I still don't see how you could cite the thread or article as stating anything false. The article is about @@MAX_CONNECTIONS which is simply reporting the configured value of the server setting 'user connections'.

The article about 'user connections' explicitly shows the software-imposed max value http://technet.microsoft.com/en-us/library/ms187882.aspx:

Use the user connections option to specify the maximum number of simultaneous user connections allowed on Microsoft SQL Server. 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.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato