MSSQL 2000 Developer Edition limit of connection ?

Dear All,
I've been searching the MSDN web for the MSSQL 2000 Developer connection
limit.
However, could not find any authentic documentation that says MSSQL 2000
Developer
connection information.
With MSSQL 2000 Developer Edition, do we have any limitation of connection
direct to
database? We do have user connecting to this database through http/asp, and
plus user connecting direct to database by 1433. However those users connect
direct to database by
1433 getting low performance, slow, sometimes got disconnection from the
MSSQL 2000
Developer Edition that we have.
Our server is single Xeon enabled hyperthreading 2 logical map to 1 physical
(this is another
factor for slow performance), this server has MSSQL 2000 Developer Edition
installed.
Thanks for any input,
JHJ.H wrote:
> Dear All,
> I've been searching the MSDN web for the MSSQL 2000 Developer connection
> limit.
> However, could not find any authentic documentation that says MSSQL 2000
> Developer
> connection information.
> With MSSQL 2000 Developer Edition, do we have any limitation of connection
> direct to
> database? We do have user connecting to this database through http/asp, and
> plus user connecting direct to database by 1433. However those users connect
> direct to database by
> 1433 getting low performance, slow, sometimes got disconnection from the
> MSSQL 2000
> Developer Edition that we have.
> Our server is single Xeon enabled hyperthreading 2 logical map to 1 physical
> (this is another
> factor for slow performance), this server has MSSQL 2000 Developer Edition
> installed.
> Thanks for any input,
> JH
There is no connection limit specific to Dev Edition.
Make sure that you enable only 1 logical processor per physical
processor in SQL Server.
Note that Developer Edition is licensed for development and testing use
only.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi David,
Is there any explaination why it is fast on clients that access from
HTTP/ASAP page and
slown performance/disconnection on client accessig database through ODBC
1433?
Thanks for any input,
JH
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1150828951.963023.188820@.g10g2000cwb.googlegroups.com...
> J.H wrote:
> > Dear All,
> >
> > I've been searching the MSDN web for the MSSQL 2000 Developer connection
> > limit.
> > However, could not find any authentic documentation that says MSSQL 2000
> > Developer
> > connection information.
> >
> > With MSSQL 2000 Developer Edition, do we have any limitation of
connection
> > direct to
> > database? We do have user connecting to this database through http/asp,
and
> > plus user connecting direct to database by 1433. However those users
connect
> > direct to database by
> > 1433 getting low performance, slow, sometimes got disconnection from the
> > MSSQL 2000
> > Developer Edition that we have.
> >
> > Our server is single Xeon enabled hyperthreading 2 logical map to 1
physical
> > (this is another
> > factor for slow performance), this server has MSSQL 2000 Developer
Edition
> > installed.
> >
> > Thanks for any input,
> > JH
> There is no connection limit specific to Dev Edition.
> Make sure that you enable only 1 logical processor per physical
> processor in SQL Server.
> Note that Developer Edition is licensed for development and testing use
> only.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>