473,887 Members | 2,253 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can you have 50 simultaneous web users with a MSDE, ASP.NET/ADO.NET backend...?

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 users in
any way?
Nov 19 '05
12 2330
Thanks for this excellent informative post.

"Juan T. Llibre" <no***********@ nowhere.com> wrote in message
news:eN******** ******@TK2MSFTN GP10.phx.gbl...
Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition
and MSDE 2000 allow 32,767 connections to an instance of the database
engine.

There is no limit for the number of connections that can be executing operations at the same time. The only effect of the workload governor is that it starts slowing down the database engine when more than eight operations are actively running at the same time.

Once it has been activated, the workload governor limits performance by stalling a user connection for a few milliseconds each time the connection requests a logical read or write on any of the pages in the data files of a database.
(The governor does not affect log files.)

The database engine waits before every data page reference as long as there are more than eight active concurrent operations. When the number of active operations is eight or lower, the database engine does not wait before scheduling any reads or writes.

50 simultaneous users does *not* equal 50 simultaneous connections.

Users do *not* request database operations at all times they are connected.
Some time is spent reading the results, too, which downlevels
the number of connections being accessed simultaneously.

A few milliseconds delay for an MSDE read/write operation is negligible,
and *no* read/write operation will be denied.

In any case, performance will be better for an MSDE database
than for an Access database when users are approximately 50.


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"Paul Clement" <Us************ ***********@sws pectrum.com> wrote in message
news:3l******** *************** *********@4ax.c om...
On Wed, 13 Jul 2005 08:22:40 -0400, "Dan V." <da**@yah.com > wrote:

¤ 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 users in ¤ any way?
¤

As Bob mentioned in one of his posts you may want to keep in mind the that MSDE has a Workload
Governor that will throttle connections when there are more than eight concurrent operations. This
could perceptibly affect performance when using MSDE.
Paul
~~~~
Microsoft MVP (Visual Basic)


Nov 19 '05 #11
Good point, Scott !
Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"Scott Allen" <sc***@nospam.o detocode.com> wrote in message
news:g0******** *************** *********@4ax.c om...
Hi Dan:

In addition to the other good advice, I'll point out the moving to
MSDE now will put you in an easier position to move to SQL 2005
Express when it ships. There is no workload governor in 2005 and the
feature set compared to Access is even greater.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Wed, 13 Jul 2005 08:22:40 -0400, "Dan V." <da**@yah.com > wrote:
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 users in
any way?

Nov 19 '05 #12
That's another clincher!
Now I'm curious as to the increased feature set...:) I'll find out
eventually.

"Scott Allen" <sc***@nospam.o detocode.com> wrote in message
news:g0******** *************** *********@4ax.c om...
Hi Dan:

In addition to the other good advice, I'll point out the moving to
MSDE now will put you in an easier position to move to SQL 2005
Express when it ships. There is no workload governor in 2005 and the
feature set compared to Access is even greater.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Wed, 13 Jul 2005 08:22:40 -0400, "Dan V." <da**@yah.com > wrote:
Since an ASP.NET/ADO.NET website is run on the server by a single "asp_networker process", therefore doesn't that mean that even 50 simultaneous humanusers of the website would appear to the database backend as a single user.Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) databasebackend on our ASP.NET/ADO.NET website to an MSDE backend be an advantageouschange to make while NOT limiting the number of simultaneous web users in
any way?

Nov 19 '05 #13

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

Similar topics

4
17629
by: Tim Morrison | last post by:
SQL Server 2000 - MSDE 2000 Is there a way to get the number of current users logged into a SQL 2000 Server (also MSDE)? Cant be distinct users as most users are logged into the database using the same login. -- Tim Morrison -------------------------------------------------------------------------------- Vehicle Web Studio - The easiest way to create and maintain your vehicle related website.
3
6128
by: *no spam* | last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing Database) This asks for the name of the .adp file to create and then launches into the Data Link Properties dialog box (so far so good) I select my MSDE server from the drop-down, enter the sa account & passwd, attach a database file and try to...
1
1566
by: Mitch Olson | last post by:
Hi our company is just about to embark on developing a PIM-type application and would like to use .NET (VB6 is our distant option 2). The question we are currently investigating is whether the minimum machine requirements (processor speed & memory) will rule out too much of our target market (the universe of Windows users, well at least W98+ users). Our primary question is what is the minimum specification of a machine to run a...
5
3510
by: Robin Tucker | last post by:
I'm looking for a simple way of telling (inside a stored procedure) if I'm currently using MSDE or a full SQL server. Ideally, there is some pre-defined environment variable that won't cause me too much overhead. The reason I'm doing this is because my system "rolls over" databases when it reaches the 2Gb limit with MSDE, but obviously I want to avoid this overhead if the user installs onto a full SQL server instance. Thanks
8
3818
by: Stephen Corey | last post by:
I'm writing an app that basically just appends text to a text file on a Win2K Server. They fill out a form, click a button, and 1 line is appended to the file. Multiple people will run this app at the same time, and all will write to the same file. If I do an immediate flush() on the file after writing the line, is there still a risk that 2 simultaneous writes will collide? If so, what's the best way to handle this type of file write? ...
4
1576
by: Anthony P. Mancini | last post by:
Does anyone know how to make the MSDE do SQL authentication ? It appears to authenticate using Windows at all times. Thanks, Anthony
1
2303
by: Mark | last post by:
What's the best way to simulate 30 simultaneous web users without: 1. Asking our 30 favorite friends to participate 2. Opening 30 different browsers manually on my desktop. Thanks in advance. Mark
1
10066
by: Simon | last post by:
Is there HTTP connection limit of 2 simultaneous connections in webservices? For example what hapens if you use webservices form ASP.NET web application? Presumably ASP.NET is webservices client to some remote server. Does that mean that the requests would be compete over those 2 connections? Is there a workaround for this? RFC 2068 8.1.4 Practical Considerations Clients that use persistent connections SHOULD limit the number of
1
2229
by: accyboy1981 | last post by:
Hi, I currently looking into creating a website that is database driven in asp.net 2.0 and using C#. In creating this website there could be a maximum of 350 simulataneous accessing the website/database. My question is in using ASP.NET and SQL Server 2005 can they handle 350 simultaneous users? If not what is an alternative? Thanks in advance
0
9957
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9799
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11173
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
9593
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
7143
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5810
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6011
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4239
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3245
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.