?
Solved

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

Posted on 2010-11-15
5
Medium Priority
?
325 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 10

Accepted Solution

by:
wls3 earned 1500 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 1500 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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

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…
Lync server 2013 or Skype for business Backup Service Error ID 4049 – After File Share Migration
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

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