[dba-SQLServer]MSDE User Throttle

Arthur

Its not users at all but threads of operation. Rusell Simclair the TE on a
book says he was working on a production system with up to 300 users. Havnt
seen it but I take his word for it.

Its not affected by the language either. Its built into the db engine.

5 PCs wiht all actually doing something on the engine should show how this
works. I posted a URL on this some time ago but cant find it now. Maybe
someone has it.


Martin


----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "dba-SQLServer" <dba-SQLServer at databaseadvisors.com>
Sent: Tuesday, December 23, 2003 9:42 AM
Subject: [dba-SQLServer]MSDE User Throttle


> Information on this topic seems to be particularly mushy. IIRC, MSDE is
> supposed to work exactly the same way as SQL 2K up to a certain number
> of users, which I believe was specified as 5. I have personally seen it
> work just fine in test circumstances with 10 users. I recall reading a
> post either here or maybe on one of the other SQL lists I belong to that
> a developer had a working MSDE install with 50+ users, and no
> performance degradation.
>
> Has anyone here got any real-world experience with going beyond the
> alleged user limit in a production system, or even in a test system?
>
> Another question: how would ADO.NET affect the throttle? For those who
> don't know, ADO.NET is a significant departure from standard ADO,
> notably in its use of disconnected recordsets.... The implication being
> that your period of connection is very brief. So would 50 users using
> ADO.NET cause the throttle to kick in?
>
> Does anyone know of any actual benchmark tests that demonstrate the MSDE
> throttle's effect? I am no longer in a position to set up such a test
> using 25-50 computers; would a test using 5 computers with several
> instances of some app or other (Access, QA, whatever) be valid?
>
> Arthur
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>