[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2010-11-15
5
Medium Priority
?
332 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

649 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