|
|
|
|
Connection limits to database by operating system
Can someone point me to documentation related to the number of connections a
database can have before there is a degradation in the connection?
I was told that if you have a database on a computer with a Windows 2000
operating system you can only have 5 connections to the database or the
connections will be slow or delayed to the point that the application using
the connection will not work. Because of this, the database should be on
Windows 2000 Server. This operating system allows more
Tue, 11 Jan 2005 06:33:07 -0800
=?Utf-8?B?R2xvcmlh?=
|
Re: Connection limits to database by operating system
The degradation in performance you are describing looks more
like and MSDE vs. SQL Server issue. MSDE is throttled for an
average resource usage of 5 concurrent batches. You can find
more information on this in SQL Server books online under
DBCC CONCURRENCYVIOLATION
-Sue
On Tue, 11 Jan 2005 06:33:07 -0800, Gloria
wrote:
>Can someone point me to documentation related to the number of connections a
>database can have before there is a degradation in the connection?
>
>I was told that if you have a database on a computer with a Windows 2000
>operating system you can only have 5 connections to the database or the
>connections will be slow or delayed to the point that the application using
>the connection will not work. Because of this, the database should be on
>Windows 2000 Server. This operating system allows more connections.
Wed, 12 Jan 2005 09:55:21 -0700
Sue Hoegemeier
|
|