Solved

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

Posted on 2010-11-15
5
302 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now