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

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


[quoted text, click to view]