• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

Tracing an web application built on ASP.NET/ IIS / ORACLE technology.


We have built an web application based ASP.NET, IIS(web server), Oracle (database).

Now if we wanted to check the performance of this web application, what is the best
approach:

 Enable tracing from the asp.net application ?
 
               Vs.

 Enable tracing at the database level (oracle) ?


Which method is suggested ? and what are best tools to start with.
0
OCUBE
Asked:
OCUBE
  • 3
  • 2
2 Solutions
 
wls3Commented:
Where is the emphasis of your applications?  Is it on the presentation level (graphics, controls, page loads) or it is on data retreival (stored procs, queries, datasets, etc)?  Automated web testing across all facets of your application will cover the entire breadth of user-case scenarios if you plan properly.  With this in mind, you can test each aspect of the application.  Obviously, you would want to have a SQL developer working on the queries (assuming you are using stored procs which are fastest).  The presentation side, however, is purely an ASP.NET/IIS question. The ASP.NET side can be handled by trace being enabled on the application.  If you are curious as to the server itself, start looking at perf mon stats to determine where your bottlenecks might be.  If you have never worked with key statistics, check out Ultra-fast ASP.NET by Richard Kiessig.  He does a superb job covering everything you could imagine to help pinpoint/isolate/resolve issues for enterprise-level applications.  Here is list of tools to work with for testing:

http://www.opensourcetesting.org/performance.php

I have worked with JMeter and the old WSAT platform before.  Many of these focus more on unit testing than application performance as a whole, but, there is also a version of Visual Studio that allows you to run application tests against sites.  It is vbscript based and doesn't always handle AJAX well, but, can cover a lot of the basics.
0
 
OCUBEAuthor Commented:

Are there any free web testing tools ? which would tell me if the bottle necks are in
ASP.NET coding (or) IIS setup configuration (or) Database queries (or) network bandwidth ?
0
 
wls3Commented:
There are a few automated things, but, when you get to the point of performance testing, which is still a relatively new field, there is no free ride yet.  Much of what you are looking do must take into consideration so many factors it's more of an art than a science:

IIS
http://wiki.asp.net/page.aspx/81/iis-optimization/
http://www.iis.net/community/default.aspx?tabid=34&g=6&i=1716

ASP.NET

http://msdn.microsoft.com/en-us/library/ff647787.aspx
http://www.codeproject.com/KB/aspnet/AspDotNetOptimization.aspx
http://www.beansoftware.com/ASP.NET-Tutorials/SessionState-Data-Optimization.aspx

Oracle
http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm
0
 
OCUBEAuthor Commented:

Ok, let me go through this links and update you.
0
 
OCUBEAuthor Commented:
Thanks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now