Change sql server connections from 32767 to 60000 or more

Is that possible ?
BOL states that max user connections is 32767. Is that hard coded with SQL ?
Or can I increase that to 60000 and have SQL open 60000 connections.
Yes you may ask, why do I need and i understand that it all depends on
capacity.
But my question is fairly simple and assuming load,etc are all taken account
of, i want to open say 60,000 connections and if i specify 60,000 as max
user connections using sp_configure, will it work ?The largest SQL Server systems in the world do not use that many connections
and I am sure you won't either. That does not mean you can't have more than
32K users connected. The key is to use connection pooling. With proper use
of connection pooling you can service many more users than you have actual
connections since rarely are they all actually busy at the same time.
--
Andrew J. Kelly SQL MVP
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:eBpYCy96FHA.4036@.TK2MSFTNGP11.phx.gbl...
> Is that possible ?
> BOL states that max user connections is 32767. Is that hard coded with SQL
> ? Or can I increase that to 60000 and have SQL open 60000 connections.
> Yes you may ask, why do I need and i understand that it all depends on
> capacity.
> But my question is fairly simple and assuming load,etc are all taken
> account of, i want to open say 60,000 connections and if i specify 60,000
> as max user connections using sp_configure, will it work ?
>|||I understand all of that Andrew and was only curious to know if I can have
more than 32767 connections and if so, can i increase it using sp_configure
?
Also, where can i read more about connection pooling
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uwFzKf$6FHA.3588@.TK2MSFTNGP15.phx.gbl...
> The largest SQL Server systems in the world do not use that many
> connections and I am sure you won't either. That does not mean you can't
> have more than 32K users connected. The key is to use connection pooling.
> With proper use of connection pooling you can service many more users than
> you have actual connections since rarely are they all actually busy at the
> same time.
> --
> Andrew J. Kelly SQL MVP
>
> "Hassan" <hassanboy@.hotmail.com> wrote in message
> news:eBpYCy96FHA.4036@.TK2MSFTNGP11.phx.gbl...
>> Is that possible ?
>> BOL states that max user connections is 32767. Is that hard coded with
>> SQL ? Or can I increase that to 60000 and have SQL open 60000
>> connections.
>> Yes you may ask, why do I need and i understand that it all depends on
>> capacity.
>> But my question is fairly simple and assuming load,etc are all taken
>> account of, i want to open say 60,000 connections and if i specify 60,000
>> as max user connections using sp_configure, will it work ?
>>
>|||In general when the specifications in BooksOnLine states that something is
the Maximum you can be pretty sure you can not exceed that<g>. As for
Connection Pooling I would do a Google search and be sure to specify what
type of drivers you are using to connect.
Andrew J. Kelly SQL MVP
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:eLDIS0A7FHA.2176@.TK2MSFTNGP14.phx.gbl...
>I understand all of that Andrew and was only curious to know if I can have
>more than 32767 connections and if so, can i increase it using sp_configure
>?
> Also, where can i read more about connection pooling
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uwFzKf$6FHA.3588@.TK2MSFTNGP15.phx.gbl...
>> The largest SQL Server systems in the world do not use that many
>> connections and I am sure you won't either. That does not mean you can't
>> have more than 32K users connected. The key is to use connection
>> pooling. With proper use of connection pooling you can service many more
>> users than you have actual connections since rarely are they all actually
>> busy at the same time.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Hassan" <hassanboy@.hotmail.com> wrote in message
>> news:eBpYCy96FHA.4036@.TK2MSFTNGP11.phx.gbl...
>> Is that possible ?
>> BOL states that max user connections is 32767. Is that hard coded with
>> SQL ? Or can I increase that to 60000 and have SQL open 60000
>> connections.
>> Yes you may ask, why do I need and i understand that it all depends on
>> capacity.
>> But my question is fairly simple and assuming load,etc are all taken
>> account of, i want to open say 60,000 connections and if i specify
>> 60,000 as max user connections using sp_configure, will it work ?
>>
>>
>