Board index » delphi » Is there a limit to the number of connections for MSDE

2005-05-31 09:20:45 PM
delphi51
I recently replaced the Paradox engine with MSDE. Works like a charm.
Since every user requires a sever this is about the only way they could
afford a more powerful database. My application writes approximately 3
records per second to the database and creates>120 megs/day of data. I
also run analytical processes against the data. On occassion I have seen an
error as "MSDE out of resources" or words to that effect.
All the writes are on the main thread though one of the analysis (freg dist)
is on a worker thread since it demands so much. But I am judicial about
creating and releasing database connections where appropriate such as when
my report is completed.
Is there a limit to the number of simultaneous connections to MSDE?
Thanks
 

Larry Killen writes:
performance degradation, by design, after 5 concurrent users (I believe
users, not connections, i.e. each of the 5 users can have multiple
connections - but best to confirm).
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
"The purpose of morality is to teach you, not to suffer and die, but to
enjoy yourself and live." - Ayn Rand
 

Do not forget about 2GB limit per database - if you insert 120 MB/day, you
may reach this limit. 2GB is size of database, it is more than cumulative
size of records, so you have ~ 1 week before going too close to this limit.
//------------------------------------------
Regards,
Vassiliev V. V.
www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Larry Killen" <XXXX@XXXXX.COM>ÓÏÏÂÝÉ?ÓÏÏÂÝÉÌÁ ?ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅ? news:429c6483$XXXX@XXXXX.COM...

I am easily pushing the query limit in my reports and I will need to monitor
the growth rate closely.
Larry
 

Brian Bushay TeamB writes:
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
SpaceShipOne; GovernmentZero
 

Hi,
Regards,
Arno Brinkman
ABVisie
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
www.firebirdsql.org
www.firebirdsql.info
www.fingerbird.de/
www.comunidade-firebird.org/
Support list for Interbase and Firebird users :
XXXX@XXXXX.COM
Nederlandse firebird nieuwsgroep :
 

Actually I'd say less than you thought.
As a general rule 5 concurrent batches means up to 20 users connected
depending on the nature of the workload etc. Of course its also possible for
one user to hog the system.
The workload governor actually has a limit of 8 but the 5 is a planning fig
as the system maybe using some of the workload, especially if you are using
replication.
The complexity and confusion around the governor is the reason it has been
removed for SQL Server Express 2005.
-Euan
"Wayne Niddery [TeamB]" <XXXX@XXXXX.COM>writes

If you use DBCC CONCURRENCYVIOLATION you can find out whether you are close
or hitting the governor.
-Euan
"Larry Killen" <XXXX@XXXXX.COM>writes

Not really. I'd say this is less limiting. In my line of business in
vertical market applications, I could have 20 users connected and it would
be rare for 5 of them to be simultaneously running a query.
Craig, www.h3k.biz

Euan Garden writes:
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
Working for yourself is great because you get to work half days, and
you can choose any twelve hours you want.
 

Hello,
here is the link to Microsoft. That should answer the questions about the
MSDE.
www.microsoft.com/sql/msde/productinfo/features.asp
Regards
Karl-Heinz Reng
Reng-EDV
Germany
"Arno Brinkman" <bnewsgroups @ abvisie.nl>schrieb im Newsbeitrag

Hi,
Regards,
Arno Brinkman
ABVisie
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
www.firebirdsql.org
www.firebirdsql.info
www.fingerbird.de/
www.comunidade-firebird.org/
Support list for Interbase and Firebird users :
XXXX@XXXXX.COM
Nederlandse firebird nieuwsgroep :
 

Wayne Niddery [TeamB] schrieb:
download.microsoft.com/download/9/1/e/91e659f1-4ea2-43c5-b2a4-d48e4b8b120f/SQL_DataSheet_final.pdf
Heinrich