|
DB Performance Analysis
Objectives:
Perhaps the single most critical success factor for any application is optimal performance. No amount of time and money invested in an application really means anything if it doesn't perform well. Optimal SQL performance can easily eliminate costly hardware upgrades, reduce wasted man-hours for processes to finish, and generate more revenue for your company.
Depending on the architecture, there may be several layers of potential performance bottlenecks (database server, application server, web server, network, etc). However, primary performance inefficiencies usually exist at the database server layer. Furthermore, industry reports show that over 80% of database server related performance issues are directly related to SQL. No matter how well an operating system or database is tuned, the application simply will not run well or pass performance Service Level Agreements without optimized SQL and the careful implementation of various SQL tuning tactics (SQL coding techniques, indexes, statistic strategies, partitioning, parallelism, etc.).
Our SQL Performance Services:
DBG Software offers 2 SQL performance analysis options (reactive or proactive modes) on any database platform. In a reactive mode where you’d like us to analyze a process or environment, we will perform a no cost upfront analysis to confirm you have an SQL performance issue that has a big "bang for the buck" potential. We will be swift in our diagnosis and resolution of the performance issue, and we’ll ensure any interested staff receives thorough knowledge transfer of performance solution rationale.
Our proactive service is the best way to stay ahead of the curve on identifying performance opportunities before your business users or resources experience an issue. For only a few hours a month, this proactive service is a very inexpensive way to immune your end user experience and resources from performance degradation in the volatile SQL performance space. When you think about all the factors that make SQL performance unstable (changing data volumes and distributions, system load, Optimizer changes, etc.), having a proactive SQL performance strategy is critical.
Why Us?:
We have industry recognized database/SQL performance analysts, with focused Optimizer behavior research on various databases (DB2, Oracle, SQL Server, Teradata, Informix, Sybase, etc.). Industry recognized indeed. Our staff not only performs database/SQL tuning for our clients, we have made several Optimizer tuning recommendations directly to IBM and Oracle; which were implemented into their database products. Database Administrators that truly understand Optimizer behavior and know how to analyze SQL access paths for optimum efficiency are extremely rare; this is the added value we provide over other "SQL experts". And if you want references, we have plenty.
ROI, Business Value, IT Governance:
With an effective SQL performance strategy, all of the most attractive of industry fueled IT initiatives are addressed like return on investment, added business value and incorporating company wide SQL standards into an IT Governance process. And most importantly, your tangible benefits of SQL performance are immediate. Utilizing DBG Software for SQL performance analysis provides you with the opportunity to witness the instantaneous and dramatic impact of SQL performance tuning. Although our guaranteed reduction in elapsed time is 50%, we typically achieve reductions of 95% or higher. Why pay 6 or 7 figures for a hardware upgrade, when you can pay a few thousand to correct the performance issue? Why lose business to new or existing customers due to poorly performing applications?
When we say 95% reductions, that’s exactly what you'll get. Although we can provide you with almost countless examples of "before and after" comparisons of execution times, here are just a few:
• A core SQL for a 50,000 user on-line application originally taking 2.5 minutes, reduced to 0.1 second
• A daily ERP financials report originally taking 3.5 hours, reduced to 8 seconds
• A data warehouse report originally taking 20 hours, reduced to 43 seconds
Although these timing improvements seem surreal, they are very common occurrences to an SQL/Optimizer savvy performance analyst.
We here at DBG Software hope you'll consider our "nothing to lose" guarantee and experience the immediate tangible benefits of SQL performance tuning.
|