Max. number od users in SQL server - Microsoft SQL Server

Goran

How many users can access to SQL server at the same time with web aplication
written in C# 2005? What if my database is 1GB and 1000 people access at 1
second - some simple query. My web hosting acc will be
http://www.webhost4life.com or something simmilar!

Dec 19 '06 #1

Subscribe Reply

1990

Yves. L.

Hi,
The # of concurrent connection a SQL server handles depends on the
settings of the server.

However if you plan to have a 1000 concurrent users (and 1000 open
connection at a time) you should probably
- implement caching from start in your app.
- check this with your web hosting facility.

YvesL
Goran wrote:

How many users can access to SQL server at the same time with web aplication
written in C# 2005? What if my database is 1GB and 1000 people access at 1
second - some simple query. My web hosting acc will be
http://www.webhost4life.com or something simmilar!

Dec 19 '06 #2

clintonG

I've hosted websites at WH4L for several years myself noting I have yet to
deploy any applications that really generate significant demand. However, be
it WH4L or any other hosting provider there is no known way I have ever
heard of to test the performance of a hosting provider's shared hosting
services other than deploy the application and then test and measure
performance repeatedly.

When it becomes apparent your applications are generating significant demand
for resources it is then time to move from shared hosting to your own
server. A 1GB database with 1,000 users is virtually meaningless. SQL Server
can handle just about anything you can throw at it.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee. com
URL http://clintongallagher.metromilwaukee.com/
MAP http://wikimapia.org/#y=43038073&x=-...8&z=17&l=0&m=h

"Goran" <gz****@gmail.c omwrote in message
news:em******** **@sunce.iskon. hr...

How many users can access to SQL server at the same time with web
aplication written in C# 2005? What if my database is 1GB and 1000 people
access at 1 second - some simple query. My web hosting acc will be
http://www.webhost4life.com or something simmilar!

Dec 19 '06 #3

Similar topics

17626

Getting Number of Logged On Users to Server

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.

Microsoft SQL Server

7732

Sequence Number generator on the server

by: Kamran K | last post by:

Hello I have created a client server application using C#. Existing application is using random number on client side to generate sequence numbers that are then assigned to transactions. This results in duplicate sequence numbers across multiple users. Solution to this problem is to generate the sequence number on the server. Since this is not an ASP app, I cannot use Global.asax Application object to keep track of begin application.

C# / C Sharp

1313

Only a small number of users were able to access our ASP.NET application during a demonstration - why?

by: Rod | last post by:

Today and tomorrow we're demonstrating our ASP.NET application to the external business customers who will be using it (this is what would best be called a B2B application). I've set things up so that the users automatically go against our test server for the database. We'll "go live" next week Monday. For some reason, while demonstrating the app, it was causing lots of errors for users. It became apparent that the issue was one...

ASP.NET

14892

Number of Concurrent Users?

by: ADezii | last post by:

Can someone please tell me the MAXIMUM number of concurrent users that Access 2003 allows for a Front/Back End architecture? I am placing all data on a departmental server and intend to customize individual Front Ends on what will probably be several hundred Clients. I had heard that the MAXIMUM number of current users is 255 but I must be absolutely sure before I continue developement. (Oracle or SQL Server are not viable options since...

Microsoft Access / VBA

2195

Auto Number mysql

by: Simon | last post by:

I had an access database that i use as an ordering system. I have a form for entering customer details. When i add a new customer on the form the customer number is an auto number that appears when i type in the details. I have just moved over to mysql server with access as the front end. I have setup the sql tables with the customer number as autonumber. When i go into the form and add a new customer it does not generate the

Microsoft Access / VBA

2443

Monitoring number of smtp bytes sent through python e-mail socket

by: William Connery | last post by:

Hi, I have a small python program with e-mail capabilities that I have pieced together from code snippets found on the internet. The program uses the smtplib module to successfully send an e-mail with an attachment. I want to give users an indication of the percentage of the e-mail that has already been sent so as to avoid frustration when dealing with large attachments or a slow smtp server. But the smtplib module doesn't seem to...

Python

108014

How to check if a textbox contains a number

by: Frinavale | last post by:

Filtering user input is extremely important for web programming. If input is left unfiltered users can input malicious code that can cripple your website. This article will explain how to make sure that the user only submits a number to your .NET web application and also demonstrate how to add JavaScript to your ASPX pages. Upon popular demand, I have added a section that also covers how to use a validator control to check if a text box...

ASP.NET

1604

Number of Users in Network Environment

by: BradHodge | last post by:

Reading a post regarding network security on a linked database, I saw this post by PDog on number of users in a network Environment... I am about to put a very small database (2200 kb back-end) out on the network. I am expecting 75-100 users in the system at any one time. The database is largely Read-Only (with the exception a few record changes made daily). I have had it in use by ~20 users continuously for the last 6 months, and have...

Microsoft Access / VBA

3748

Counting number of users logged in

by: Mike P | last post by:

What would be the best way of counting the number of users who are currently logged on to a website? I am making the users login against a database of valid users. Would the best way be to add a bool field to the table and set each user to 1 if they are logged in, and 0 if they are not logged in? *** Sent via Developersdex http://www.developersdex.com ***

ASP.NET

8649

How to control number of users in a database?

by: kai | last post by:

Hi, I use VB 2008 as front end, SQL Server 2005/2008 as back end, I want control number of cucurrent users log on to the database, I am trying to use a stored procedure, but it did not work. Is this possible? Please help. Thanks Kai

Microsoft SQL Server

9568

What is ONU?

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...

General

9398

Changing the language in Windows 10

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,...

Windows Server

10007

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

9951

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

8831

AI Job Threat for Devs

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...

Career Advice

6649

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

3924

transfer the data from one system to another through ip address

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

C# / C Sharp

3531

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2805

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General