WebServer to host ASP.NET applications

[Aspiring .NET Programmer]

This is one of the fundamental questions I have. Would greatly
appreciate any response.

I have been using and still use IIS for hosting my ASP.NET
applications. As the size of the application grows and the number of
users accesing the application grows to lets say 100 or more, is IIS
still a good option or which are the other more powerful and scalable
options for servers available.

Thanks!
Sum

 

[Juan T. Llibre]

IIS can handle millions of users.

 

[George Ter-Saakov]

Well, if microsoft.com is using IIS i think you started to worry a little
early about IIS ability to handle 100 users

George.

 

[Aspiring .NET Programmer]

Thank you guys!...Would the hardware cofiguration of the machine on
which IIS is running have an affect on the performance? Will a more
powerful machine with bigger memory and processing power perform
faster. How do we determine whats good enough??


The following question may be a little out of scope for this group but
its valid for large asp.net web applications so here we go..

My app sometime referes to SQL Server tables that has around 2 million
records in them. Even a simple statement like "select column1 from
table1, table2 where table1.id= table2.id and table1.id=XYZ" over two
such large tables causes the application to slowdown drastically and
sometimes timeout since the result set was not fetched in time. Again,
willl a more powerful machine give better performance? FYI: The same
sql statement takes something like 2 mins in the Query Analyzer.

Thanks!
Sum

 

[Mark Rae]

Thank you guys!...Would the hardware cofiguration of the machine on
which IIS is running have an affect on the performance? Will a more
powerful machine with bigger memory and processing power perform
faster.

Generally speaking, yes, though bigger and faster hard disk(s) will also
help too...

How do we determine whats good enough??

There's really no easy answer to this one - however, this wouldn't be a bad
place to start:
http://www.microsoft.com/downloads/...5a-062a-439e-a67d-75a89aa36495&DisplayLang=en

My app sometime referes to SQL Server tables that has around 2 million
records in them. Even a simple statement like "select column1 from
table1, table2 where table1.id= table2.id and table1.id=XYZ" over two
such large tables causes the application to slowdown drastically and
sometimes timeout since the result set was not fetched in time. Again,
willl a more powerful machine give better performance? FYI: The same
sql statement takes something like 2 mins in the Query Analyzer.

This begs the obvious question: are your tables properly indexed? *Storing*
2 million records will not phase SQL Server one bit. However, if you're
trying to *fetch* 2 million records from your database to your webserver,
then you really need to rethink your application...

 

[Aspiring .NET Programmer]

Generally speaking, yes, though bigger and faster hard disk(s) will also
help too...


There's really no easy answer to this one - however, this wouldn't be a bad
place to start:http://www.microsoft.com/downloads/details.aspx?FamilyID=e2c0585a-062...


This begs the obvious question: are your tables properly indexed? *Storing*
2 million records will not phase SQL Server one bit. However, if you're
trying to *fetch* 2 million records from your database to your webserver,
then you really need to rethink your application...

Thanks for your reply! I will take a look at that tool you suggested.

There are two extremes of the resultset we expect from the tables.

1) Fetch just a few records out of the 2 millon records that satisfy a
certain criteria (where clause) after a join operation among large
tables and display in a DataGrid.

2) Get all the records from 2 tables with 2 million records each and
have some relationship associated with them without any where clause
and populate the same DataGrid.

Its basically a search module where the user is given 5 parameters to
fillin their search criteria. If the user want to just get all the
records he doesnt provide any search criteria and clicks on search.
This seach needs to access these huge tables.

In both cases there is obviously a join operation on 2 large tables.
It takes around 2-3 mins for such a query to run even in SQL Server
Query Analyzer or Enterprise Manager. How do we improve this in the
first place? If we just look at the first scenario for now, there isnt
a problem with loading large amount of data into the webserver since
we are only fetching a few(10 records for eg.) records and only those
would be loaded into the webserver.

Thanks for ur time.

Sum.

 

[Mark Rae]

Thanks for your reply! I will take a look at that tool you suggested.

It's not the most sophisticated stress-test tool available, but it's free,
and is made by the people who wrote the server software in the first
place...

2) Get all the records from 2 tables with 2 million records each and
have some relationship associated with them without any where clause
and populate the same DataGrid.

To my mind, that is utter lunacy on a web app... What on earth do yon need
to display 2 million records on a web page for...?

In both cases there is obviously a join operation on 2 large tables.
It takes around 2-3 mins for such a query to run even in SQL Server
Query Analyzer or Enterprise Manager.

Post your SQL...