July 13, 2011 at 6:39 am
Hi all,
My question is how many users can login at a time using in sql server 2008?
July 13, 2011 at 9:24 am
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
July 13, 2011 at 10:19 am
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.
July 13, 2011 at 10:49 am
is the 32767 users can login to sql server?
July 13, 2011 at 10:53 am
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
July 13, 2011 at 10:54 am
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
July 13, 2011 at 3:25 pm
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.
July 13, 2011 at 3:37 pm
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
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply