Solved

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

Posted on 2010-11-15
5
309 Views
Last Modified: 2012-05-10

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
Comment
Question by:OCUBE
  • 3
  • 2
5 Comments
 
LVL 10

Accepted Solution

by:
wls3 earned 500 total points
ID: 34141793
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
 

Author Comment

by:OCUBE
ID: 34141848

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
 
LVL 10

Assisted Solution

by:wls3
wls3 earned 500 total points
ID: 34141986
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
 

Author Comment

by:OCUBE
ID: 34306994

Ok, let me go through this links and update you.
0
 

Author Closing Comment

by:OCUBE
ID: 34530414
Thanks
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Shredding xml into an oracle 11g Database 2 45
how to trim oracle sql sentence in unix 17 53
Use of Exception to end a Loop 3 32
SSL Certificate for IIS7 Site 2 20
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question