Scenario Based Database Comparison Testing for Migration Projects

Database Performance Bottleneck Analysis: Looking beyond the obvious

Conference Plenary – at STeP-IN SUMMIT 2011(February 2011)

Nilesh Dasharathi, Senior Test Lead and Neha Tiwari, Test Specialist, MindTree

In today’s environment applications are becoming large, complex & dynamic. At the same time performance and availability have gained prime importance from an end user’s perspective. Pertaining to this increased complexity & end user’s expectations requires dealing with several dimensions. For example the performance of an N-tier web based application depends on multiple factors such as network performance, web server performance and application design. Our experience with web application performance testing leads us to believe that in an overwhelming number of cases, the poor performance of a web application can be traced back to a badly performing database. This necessitates the need for a holistic approach to in-depth database performance bottleneck analysis to pinpoint the root cause for performance slowdown.

Testing an application for identifying Oracle Database bottlenecks

Paper Presentation – at STeP-IN SUMMIT 2007(January 2007)
Ramkumar S - Database Architect, ArisGlobal Software Pvt Ltd.

The database forms a core part of evey enterprise application and it is very important to make use of the database effectively and in an optimized manner. This paper will let you know how to identify bottlenecks in the Database that get built up without anyone noticing the same. Any enterprise application today has a database to store and retrieve data, and that isr the core component of the application. But what is happening in the application development world is that the database is given lesser importance and a lot of focus is given on the application architecture. This results in scalability issues which typically emerge when doing a performance test.