Comments
yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Computing
Conference & Expo
November 2-4, 2009 NYC
Register Today and SAVE !..

2008 West
DIAMOND SPONSOR:
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
PLATINUM SPONSORS:
Red Hat
The Opening of Virtualization
GOLD SPONSORS:
Appsense
User Environment Management – The Third Layer of the Desktop
Cordys
Cloud Computing for Business Agility
EMC
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Intel
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Sensedia
Return on Assests: Bringing Visibility to your SOA Strategy
Symantec
Managing Hybrid Endpoint Environments
VMWare
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
PLATINUM SPONSORS:
Appcelerator
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
GOLD SPONSORS:
ICEsoft
How Can AJAX Improve Homeland Security?
Isomorphic
Beyond Widgets: What a RIA Platform Should Offer
Oracle
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
In many cases, the end of the year gives you time to step back and take stock of the last 12 months. This is when many of us take a hard look at what worked and what did not, complete performance reviews, and formulate plans for the coming year. For me, it is all of those things plus a time when I u...
SYS-CON.TV
Application Performance & Architectural Problems You Can Find in an Hour
A step-by-step guide

When we get engaged with prospects that are interested in our performance management solution we walk them through a Proof of Concept. We let them install dynaTrace on their own prior to the actual POC. During the POC we ask them to exercise typical use cases on their application that show performance problems. We walk them through the different analysis options and add the findings to a final POC Presentation. In this blog I want to share some screenshots and findings of a typical Proof of Concept recently done in a heterogeneous .NET/Java Environment.

Out-of-the-Box Result Presentation
The screenshots are taken from the final POC Presentation that my colleague Francis pulled together after analyzing a one hour recorded dynaTrace Session with an Out-Of-The-Box dynaTrace Configuration.

1. Get a general performance overview of the application – where are my hotspots?

Different ways to get a high-level performance view of the capture data

Different ways to get a high-level performance view of the capture data

Read more on identifying Hotspots

2. What is going on between my application servers?

Transactional Flow Diagram allows us to drill into more details

Transactional Flow Diagram allows us to drill into more details

Read more on Tracing Distributed Applications

3. Sequence Diagram for individual transactions

Sequence Diagram giving us a high level performance overview of a slow running transaction

Sequence Diagram giving us a high level performance overview of a slow running transaction

The Sequence Diagram can also be used to see how tiers interact, where our bottlenecks are and where exceptions are thrown

The Sequence Diagram can also be used to see how tiers interact, where our bottlenecks are and where exceptions are thrown

More on analyzing architectural problems

4. Analyzing Database Activity

Analyze Database Activity per Transaction. Identify problems where SQL Statements are called multiple times with the same parameters

Analyze Database Activity per Transaction. Identify problems where SQL Statements are called multiple times with the same parameters

Analyzing slow SQL Query on WebLogic:

Several individual DB Queries had an execution time of > 4 seconds

Several individual DB Queries had an execution time of > 4 seconds

Read more database related blog entries.

5. Identifying slow Remoting calls

Identify slow remoting calls including full call context and the ability to trace into the server-side implementation of this call

Identify slow remoting calls including full call context and the ability to trace into the server-side implementation of this call

Read more remoting related blog entriesInspecting asynchronous MessagesdynaTrace can follow asynchronous messages through your SOA infrastructure

6. Analyzing hidden exceptions

dynaTrace captures exceptions including full call stack. Drilling to the actual PurePath (Trace) gives more input on the actual call context

dynaTrace captures exceptions including full call stack. Drilling to the actual PurePath (Trace) gives more input on the actual call context

More exceptions caught on WebLogic:

Many internal exceptions that never made it to the application code indicating XML Format issues

Many internal exceptions that never made it to the application code indicating XML Format issues

7. Runtime Suspension (Garbage Collection) Impact Analysis

Identify the impact of Garbage Collection on response times of individual transactions

Identify the impact of Garbage Collection on response times of individual transactions

Read a blog post on the cost of exceptions

8. Details on Web Service Calls from .NET to Java

Details on Web Service Invocations such as input parameters, transfered bytes or the impact of the GC on the execution time

Details on Web Service Invocations such as input parameters, transferred bytes or the impact of the GC on the execution time

9. Lookup Source Code from your own or foreign code

Found a problematic method? Directly lookup the decompiled Java/.NET Code

Found a problematic method? Directly lookup the decompiled Java/.NET Code

Conclusion
As you can see – it is easy to get an overview of the performance hotspots. The typical problems that we always find are things like too many database statements, hidden exceptions or long-running remoting calls. Read my blog about the Top 10 Server-Side Performance Problems that we often find with our dynaTrace Installations.

Related reading:

  1. Top 10 Client-Side Performance Problems in Web 2.0 Inspired by the Top 10 Performance Problems post which focuses...
  2. Troubleshooting response time problems – why you cannot trust your system metrics // Production Monitoring is about ensuring the stability and health...
  3. Application Performance Monitoring in production – A Step-by-Step Guide – Part 1 // Setting up Application Performance Monitoring is a big task,...
  4. Top 10 Performance Problems taken from Zappos, Monster, Thomson and Co For a recent edition of the Swiss Computerworld Magazine we...
  5. Top 3 Performance Problems in Custom Microsoft CRM Applications After spending a lot of time focusing on Client-Side Web...

 

 

About Andreas Grabner
Andreas Grabner has been helping companies improve their application performance for 15+ years. He is a regular contributor within Web Performance and DevOps communities and a prolific speaker at user groups and conferences around the world. Reach him at @grabnerandi

SOA World Latest Stories
In his session at 20th Cloud Expo, Mike Johnston, an infrastructure engineer at Supergiant.io, discussed how to use Kubernetes to set up a SaaS infrastructure for your business. Mike Johnston is an infrastructure engineer at Supergiant.io with over 12 years of experience designing, dep...
SYS-CON Events announced today that DatacenterDynamics has been named “Media Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY. DatacenterDynamics is a brand of DCD Group, a global B2B media and publ...
Most DevOps journeys involve several phases of maturity. Research shows that the inflection point where organizations begin to see maximum value is when they implement tight integration deploying their code to their infrastructure. Success at this level is the last barrier to at-will d...
DevOpsSummit New York 2018, colocated with CloudEXPO | DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City. Digital Transformation (DX) is a major focus with the introduction of DXWorldEXPO within the program. Successful transformation requires a laser focus ...
"We do one of the best file systems in the world. We learned how to deal with Big Data many years ago and we implemented this knowledge into our software," explained Jakub Ratajczak, Business Development Manager at MooseFS, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8...
Adding public cloud resources to an existing application can be a daunting process. The tools that you currently use to manage the software and hardware outside the cloud aren’t always the best tools to efficiently grow into the cloud. All of the major configuration management tools ha...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021


SYS-CON Featured Whitepapers
ADS BY GOOGLE