Performance is an often used and at times misused term in IT industry. Though it is the most important criteria for an application; it is very difficult to quantify it. Also, performance is a relative term. What may be good performance for one application may be considered very poor for another. Often many factors play a role in performance of an application. As a performance tuning expert, the areas wherein i can help are -
- Performance Benchmarking - Benchmarking an application's performance is the first step in performance tuning. Before actually making changes, it is very important to first know the current capabilities of the application. It is important to know and document the response times of application transactions and queries, the memory utilization of its sessions, the disk usages, system throughput and host of other factors.
- Identification of bottlenecks - Whether it is the whole application itself or a particular module of the application, poor performance could be because of host of factors ranging from poorly performing resources, wrong tool, database, bad architecture and design or bad code or a combination of these. Identifying the right source of bottleneck is important.
- Implementing solutions - After identifying the bottlenecks, it is important to find the right solution. A solution that is long lasting and the one that doesn't break the existing functionalities.
- Database Performance Tuning - I specialize in databases. Also, many a times databases are often the bottlenecks. And the bottlenecks could be a poorly written code, an embedded sql , bad database design (logical and physical), wrong database settings and/or filesystem and memory management part of the database.
