Friday, March 30, 2012

MSSQL 2000 Developer connection limit & boolean 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,
JHHi,
there is no connection limit to SQL Server Dev Edition as there is none
for all the editions, this one for SQL Server MSDE isn=B4t actually a
limitation, its a trotteling of the engine, as the query governour will
keep track of the concurrent *queries* not connections.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi,
there is no connection limit to SQL Server Dev Edition as there is none
for all the editions, this one for SQL Server MSDE isn=B4t actually a
limitation, its a trotteling of the engine, as the query governour will
keep track of the concurrent *queries* not connections.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

No comments:

Post a Comment