Re: MSDE Web Connections Using ASP.net

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dan Brussee (dbrussee_at_nc.rr.com)
Date: 06/25/04


Date: Fri, 25 Jun 2004 22:40:38 GMT

This may not be true, but I heard that the "throttling" was basically
a mechanism to artificially slow the server down as it went over X
number of concurrent users... not that it would just stop working.

On Fri, 25 Jun 2004 22:53:51 +0100, "John Timney \(Microsoft MVP\)"
<timneyj@despammed.com> wrote:

>If its throttled to 8 then in theory your max connections would be 8
>sessions with an open connection, as thats the worst case you should plan
>for if each session is capable of opening a connection. However, using
>caching could allow thousands of concurrent users - it really depends on how
>often your pages need to actually hit the DB connection. Also, a
>disconnected read only connection added to the cache has little impact on
>your concurrency unless the data changes often and needs to be constantly
>refreshed.
>
>Regards
>
>John Timney
>Microsoft Regional Director
>Microsoft MVP
>
>
>"Martin Harran" <nospam@martinharran.com> wrote in message
>news:e2YAnqvWEHA.3200@TK2MSFTNGP09.phx.gbl...
>> MSDE is throttled for 8 concurrent operations. As ASP.net is designed
>around
>> disconnected recordsets, I'm wondering how busy a site using ASP.net would
>> have to get before the workload governor starts to have a noticeable
>effect.
>>
>> Anyone have any experience of this or guidelines?
>>
>> Martin Harran
>>
>>
>



Relevant Pages

  • Re: MSDE Web Connections Using ASP.net
    ... sessions with an open connection, as thats the worst case you should plan ... for if each session is capable of opening a connection. ... > MSDE is throttled for 8 concurrent operations. ... > disconnected recordsets, I'm wondering how busy a site using ASP.net would ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MSDE Web Connections Using ASP.net
    ... sessions with an open connection, as thats the worst case you should plan ... for if each session is capable of opening a connection. ... > MSDE is throttled for 8 concurrent operations. ... > disconnected recordsets, I'm wondering how busy a site using ASP.net would ...
    (microsoft.public.sqlserver.clients)
  • Re: MSDE Web Connections Using ASP.net
    ... sessions with an open connection, as thats the worst case you should plan ... for if each session is capable of opening a connection. ... > MSDE is throttled for 8 concurrent operations. ... > disconnected recordsets, I'm wondering how busy a site using ASP.net would ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Totally OT: ISP Q for London poms.
    ... >>I'm paying for a 512kbit service with Tiscali, ... > throttling all connections on TCP port 119 in which case no ... > For example, my ISP (Metronet), does provide a feed from ... > the service is limited to a 128kbit connection speed. ...
    (rec.sport.cricket)
  • Re: Plusnet - slightly confusing? Plus net Usenet throttling?!?
    ... >>I posted previously how I'm finding my connection being throttled. ... >> This one tells how much you can download before having your connection ... >> the amount of throttling increasing as you download more. ... The peak time for this is 4pm - midnight. ...
    (uk.telecom.broadband)