Connections

Hello everyone,
I am configuring the connection pooling for my web application.
We are using Sql Server 2000 as backend.
I need to specify initial connection poolsize and maximum connectionpoolsize.
My question is how many connections can we make simultaneously to SQL server
2000.
Experts if u can give me an optimal configuration for this it will be really
helpful
ThanksWe have left the max worker threads as the default 255 in the sql server 2000.
But we expect 300 to 500 users to connect to the application,
can we increase the max worker threads to 500
and specify the initial connection poolsize as 500 in the conection pool of
the application.
Any help would be greatly appreciated.
Thanks
"Toby" wrote:
> Hello everyone,
> I am configuring the connection pooling for my web application.
> We are using Sql Server 2000 as backend.
> I need to specify initial connection poolsize and maximum connectionpoolsize.
> My question is how many connections can we make simultaneously to SQL server
> 2000.
> Experts if u can give me an optimal configuration for this it will be really
> helpful
> Thanks|||Unless you have 500 simultaneous, persistent, user connections (win9x
clients), there is no need to increase the max worker threads. Sqlserver is
designed to handle thousand of connections with 255 max worker threads fine.
Long story short, your users connect to sqlserver via a web application
(running on IIS?). There isn't a need to increase the #.
--
-oj
"Toby" <Toby@.discussions.microsoft.com> wrote in message
news:81AE8280-C6F3-4082-8047-AD1953FF13F6@.microsoft.com...
> We have left the max worker threads as the default 255 in the sql server
> 2000.
> But we expect 300 to 500 users to connect to the application,
> can we increase the max worker threads to 500
> and specify the initial connection poolsize as 500 in the conection pool
> of
> the application.
> Any help would be greatly appreciated.
> Thanks
> "Toby" wrote:
>> Hello everyone,
>> I am configuring the connection pooling for my web application.
>> We are using Sql Server 2000 as backend.
>> I need to specify initial connection poolsize and maximum
>> connectionpoolsize.
>> My question is how many connections can we make simultaneously to SQL
>> server
>> 2000.
>> Experts if u can give me an optimal configuration for this it will be
>> really
>> helpful
>> Thanks