473,747 Members | 2,862 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSDE Web Connections Using ASP.net

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
Nov 18 '05 #1
4 1233
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" <no****@martinh arran.com> wrote in message
news:e2******** ******@TK2MSFTN GP09.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

Nov 18 '05 #2
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\)"
<ti*****@despam med.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" <no****@martinh arran.com> wrote in message
news:e2******* *******@TK2MSFT NGP09.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


Nov 18 '05 #3

"Dan Brussee" <db******@nc.rr .com> wrote in message
news:ce******** *************** *********@4ax.c om...
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.


It's not actually the number of concurrent user, it's concurrent operations.
From
http://msdn.microsoft.com/library/de...2000webapp.asp

<quote>
Understanding the Workload Governor
All versions of SQL Server 2000 (including MSDE 2000) support up to 32,767
connections per instance ...[snip] ... More importantly for your application
designs, MSDE 2000 employs what is known as a concurrent Workload Governor.
The effect of the governor is to slow certain operations down by stalling
user connections for a few milliseconds whenever there are more than eight
concurrent operations. Some system-generated events in the database engine
count against this eight-operation limit, so the governor may kick in even
when your application code requests fewer than eight operations. The key is
concurrent operations, such as executing a query. This is not the same as
concurrent users. In most applications, there is a certain amount of user
"think time," where a live connection to the server exists, but the user is
not actually performing a task that accesses the database. The actual number
of concurrent users can be much higher.
</quote>

I'm just wondering what this means in practice.

Martin Harran
Nov 18 '05 #4

"Dan Brussee" <db******@nc.rr .com> wrote in message
news:ce******** *************** *********@4ax.c om...
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.


It's not actually the number of concurrent user, it's concurrent operations.
From
http://msdn.microsoft.com/library/de...2000webapp.asp

<quote>
Understanding the Workload Governor
All versions of SQL Server 2000 (including MSDE 2000) support up to 32,767
connections per instance ...[snip] ... More importantly for your application
designs, MSDE 2000 employs what is known as a concurrent Workload Governor.
The effect of the governor is to slow certain operations down by stalling
user connections for a few milliseconds whenever there are more than eight
concurrent operations. Some system-generated events in the database engine
count against this eight-operation limit, so the governor may kick in even
when your application code requests fewer than eight operations. The key is
concurrent operations, such as executing a query. This is not the same as
concurrent users. In most applications, there is a certain amount of user
"think time," where a live connection to the server exists, but the user is
not actually performing a task that accesses the database. The actual number
of concurrent users can be much higher.
</quote>

I'm just wondering what this means in practice.

Martin Harran
Nov 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
8432
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows 2000. One of them is full SQL Server, another is msde. When transaction log is full in full SQL Server error 9002 severity 17 state 2 is logged in sql server log and in Windows Application log. My alert firing my job. All is fine. But when...
10
3854
by: noname | last post by:
MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install time. Install log shows installation successful.. Control Panel> Admin Tools> Services section shows SQL server instance running.
2
1504
by: Mark | last post by:
Hi - I have a rather unreliable host just now - but they offer .net, sql server and SSL for a reasonable price. Problem is, the domain is hosted on a shared server - and it keeps going down apparantly because of code which is less than clean, on some peoples sites. (ie. not closing connections etc). I am considering moving to a decicated server - but at this point in time, cannot afford a full SQL Server licence for it - however, the...
1
1983
by: Markus Graf | last post by:
Hi all I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation was not the problem, but if i would connect with a client like dbamgr2k or the MS Enterprise client, the client hangs up. If i try a nonlocal server, it hangs too. What's the problem? Markus
41
2445
by: NB | last post by:
Hi I have been developing on MS Access / Jet / VBA platform for about 2 years. The current project I am working on for a small business is built on Access 2002. It has about 53 tables in 2 backend MDB files, 125 queries, 109 forms & subforms, 43 reports & subreports, 20 code modules and some macros. The size of the backend is now at a modest size of about 4MB (down
6
1946
by: jmev7 | last post by:
I have heard of security issues with IIS while on a T1 line or on a cable modem, etc. I learned of a "break in" at a state office, and it was traced to an "open door" while using IIS. Due to that break in, research was done which resulted in the consensus that MSDE applications were also vulnerable. Any thoughts one this? Does anyone know if running if at home could cause an open door to exist through which others might "make themselves at...
12
2314
by: Dan V. | last post by:
Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net worker process", therefore doesn't that mean that even 50 simultaneous human users of the website would appear to the database backend as a single user. Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) database backend on our ASP.NET/ADO.NET website to an MSDE backend be an advantageous change to make while NOT limiting the number of simultaneous web...
3
1341
by: David Lozzi | last post by:
Howdy! I have a question for all you smarties... I have a ASP.Net application running on Windows 2000 Professional and MSDE, same box. While running the application, users will randomly receive a too many connections error or even a simple Page cannot be displayed. I know some of the limitations of MSDE and have managed to fudge my way around them, but what about Win2kPro IIS? I'm thinking it won't let me a host an active application on...
5
2080
by: Tony Johansson | last post by:
Hello! Visual Studio 2005 includes a copy of SQL Express which is a lightweight desktop engine version of SQL Server 2005. Now to my question what is MSDE(Desktop Engine) is that the same as SQL Express ? //Tony
0
9522
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9354
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9307
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9223
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8233
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4860
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3296
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2771
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2203
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.