473,836 Members | 1,464 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Scalability problem With .Net and Sqlserver

I need Technical Support

I finished a Great project using .Net and SQL Server and .Net Mobile

My Business case is to implement this Program to accept about 1
Million concurrent users

So I designed the project as master Node that has all administration
project and about 10 client Nodes

Those subscribers will login and I configured the replication at
Server that can publish any change to the Nodes

And I tried this technique and every thing is perfect.

NOW I am at final test

I want to proof that my project at every Node is scalable up to 100
000 concurrent users

My problem is

1- I have not Any Test tool to generate this Huge connections

2- I do not Know How to configure the tool to let me got
reasonable Result

3- I do not know if My Environment is suitable for real test or

4- Finally I do not know where is the hole at my program that
made a bottle neck in this project

The Problem in detail

I tried to Download ANTS program and tried it but unfortunately
it gave me only 5 client to test I do not know if it possible to
increase this value at another test program or not?

I tried to using Microsoft Test Center but I do not know How to
configure the parameter

for Example the Only parameter that gave me is No of client and No of

No of client is very limited to 2000 and you can specify huge no of

but I still do not understand is it possible that 100 000 concurrent
users login at same time ?

is the network latency and bandwidth is it a huge bottle neck that
will permit the concurrent user to login in different time

I think that the average no of request depend on the bandwidth of
channel that established between client and server

So I think that the MTC generate concurrent connection and per
connection try to do it several time

Real Test

I tried with 2000 concurrent user and 1000 Iteration

at NT2003 Server with MS SQL Server 1 G.B RAM and 3GHz

and the result was very very strange

the program at first connection establish a pool with minimum
20 and max is 100 {I do not know is it suitable for my project or

I see the performance monitor and I found that the connection begin
with 20 connections and increase linearly up to 1000 connections

and the result of the test is fail and the error was different and I
could not understand the result

after that I tied manually to run the application at I could
not I found the curser is busy and no reply

in the program it was configured that after the db connection time out
it reply with error it never happen

I wait more than 2 minutes and still busy

So I assumed that problem happen in db I restart SQL Server and I
found that still problem exist the site too busy and nothing happen

after that I restart the IIS and nothing Happen

this result very strange because it means the Server feel a very high
traffic contention at his resource but this resource is not DB or IIS

So what type of this resource??


Is this problem because .Net with every hit Create many object
and leave it to Garbage collection to release and the connection was
very fast so it makes a problem before triggering the garbage

is this problem because I did not use the COM+ for pooling
?{but I read an article at .NET help called that no need to use COM+
at pooling because

..NET with SQLClient is automatically use the pooling and He advises to
do not complicate program with using this technique use it only with
..net with OLEDB like oracle or any db Actually I tried this manually
and it was work but with few no of connections and observing NT
Performance monitor with SQL server connections}

Actually I have no clue How to pin the COM+ to OS and dose I need to
special tool or I can do it using .NET?

Is this problem is due to limitation of SQL Server and Windows
2003 Server as Development tool limitation Actually this server was
completely installed with toolkit that shipped with .NET enterprise
this toolkit have SQL Server2000 and windows 2003 windows 2000 and
exchange server and ecommerce,…

So is it for Development purpose did not support a huge connection??

Note: I tried to limit the IIS for only 1000 concurrent connections
and I found the MTC still send connection and it was more than 1000
connection and still work without error ? SO I have doubt of the

is the problem that I load a lot of information from web.config with
each connection to program like get the db connection?

I NEED IF IT Possible

1-Good test program with the minimum configuration to reach my target
100 000 concurrent users

2-Article about the bottle neck at any project with .NET and SQL
Server and .Net Mobile Controls that may be cause a problem?

3-If is Microsoft Test Center is good How Can I configure this test to
reach my target 100 000 concurrent user

And how can I test it?

3- Finally I will write the source code of the main 3 Part

the Source Code

connection to database

public Message Connect()


UTIL util=new UTIL(session);

if(myConnection !=null)if(myCon nection.State== System.Data.Con nectionState.Op en)


return new
Message(true,"I s Already opened",0);




myConnection = new SqlConnection() ;

if(util.Connect ionString.Trim( )==String.Empty )util.Connectio nString=UTIL.Us erApp.GetFromUs erPart("DATABAS ENAME");

if(util.Content DataConnectionS tring.Trim()==S tring.Empty)uti l.ContentDataCo nnectionString= UTIL.UserApp.Ge tFromUserPart(" CONTENTDATABASE NAME");

myConnection.Co nnectionString =
util.Connection String;

if( myConnection.St ate.ToString(). ToUpper()
!="OPEN" ) myConnection.Op en();

return new Message(true,"" ,0);


catch(Exception ex)


return new Message(false,e x.Message,-1);



Retrieve data From db

public Message Retreive(string sql,DataSet dataResult)


long val;




SqlDataAdapter myDataAdapt=new
SqlDataAdapter( sql,myConnectio n);

if(dataResult!= null)dataResult .Clear();

myDataAdapt.Fil l(dataResult,"m yData");


val=(long)dataR esult.Tables["myData"].Rows.Count;


return new Message(true,"" ,val);


catch(Exception e)



return new Message(false,e .Message,-1);


Jul 20 '05 #1
0 2028

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

Similar topics

by: Wenning Qiu | last post by:
I am researching issues related to emdedding Python in C++ for a project. My project will be running on an SMP box and requires scalability. However, my test shows that Python threading has very poor performance in terms of scaling. In fact it doesn't scale at all. I wrote a simple test program to complete given number of iterations of a simple loop. The total number of iterations can be divided evenly among a number of threads. My...
by: Arpan | last post by:
What does the term "scalability of an application" mean? Thanks, Arpan
by: Khaled D Elmeleegy | last post by:
--=_alternative 004FC1E080256D75_= Content-Type: text/plain; charset="us-ascii" I am studying the scalability of MYSQL on SMPs on Linux. I am wondering if any one has performed scalability studies. If so, I would be interested in a pointer to the results; if not, I am curious if there is interest in MYSQL's scalability. Pointers to benchmarks used to study MYSQL would also
by: tharma | last post by:
I was wondering if some one provides some information about scalability and performance of ASP vs JSP. Scalability of JSP vs. ASP (which one is better?) Performance of JSP vs. ASP (which has better performance?) I have been looking for graphs, and charts that compare JSP vs. ASP (scalability and performance) but I couldn't find any. If anyone knows any link which has scalability of performance graph of ASP vs. JSP,
by: Duffey, Kevin | last post by:
We are looking for information regarding any capabilities of PostgreSQL in regards to scalability. Ideally we want to be able to scale in both directions. What sort of solutions are out there for either or both directions of scalability? Specifically, open-source solutions would be most in need, but commercial applications are fine as well. Thank you. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system...
by: ppateel | last post by:
Hi, First I would like to apologize for cross posting in three groups as I did not know which one would be the appropriate group. If some one points me to the correct one I will use that in the future. I am trying to findout the scalabilty of an user written extended store procedure. I have created a dll using a C program (modified/plagarized from some of the examples) . The main function of this extended SP is to act as a passthru to...
by: Jenniflower | last post by:
Hi Gurus, Our system is using SqlServer 2005 on XP.( On my machine,only this application access SQLServer.) The sqlserver memory is configured to 128MB (Min)~512 MB(Max) After our system get started, sqlserver takes about 100M memory. After the system runs for a while, the memory used by sqlserver goes up to 512MB. Then we exit our application and expect the memory usage of SqlServer could be dropped down to the min value....
by: Gordowey | last post by:
Hi all, I would like to ear your opinion about the best approach for and ASP.net with high workload traffic (High number of visitors) using SQL DB Consider the following scenario: - Website with 10.000 visitors/day. (and can grows faster. High Scalability is one of teh requirements) - Single W2k3 server (no farm), - ASP.net 1.1 (or ASP.net 2.0) web site - SQL 2000 (or 2005)
by: Tim Mitchell | last post by:
Hi All, I work on a desktop application that has been developed using python and GTK (see www.leapfrog3d.com). We have around 150k lines of python code (and 200k+ lines of C). We also have a new project manager with a C# background who has deep concerns about the scalability of python as our code base continues to grow and we are looking at introducing more products. I am looking for examples of other people like us (who write...
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...
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,...
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...
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...
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();...
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...
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
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
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.