Our Database Performance Analysis Service....Why You Need It
"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." -Curt Triplett
Again, we have experience and references for performance analysis on ANY database and for ANY application
The Reasons...
Loss Of Profit
Loss Of Revenue
Hardware Longevity
Overhead Costs
Millions of dollars in needless costs
Hardware
Primarily CPU, Memory and DASD
Database Server
Application Server
Web Server
Software
Database license fees (CPU based)
Software license fees (CPU based)
Overtime to employees for slower processes, if paid hourly
New or existing customers will go somewhere else due to performance issues
Our performance service will significantly extend the life of your current hardware (CPU, Memory, DASD)
Primarily for non-revenue generating applications (HR, Payroll, Benefits, etc.)
If these types of processes run long, that means more expense for applications that are already not generating revenue
Wasting human time for processes to finish
The Questions...
Don't I already pay a DBA to do performance tuning?
We don't just have developed software, we buy a lot of purchased software. How can you tune if we don't own the code?
What am I getting for my money?
Performance issues can be anywhere in the system, why do you focus on the database so heavily?
Generally, DBA’s are overtaxed and don’t have the time to be proactive about performance. And sometimes, a little mentoring can go a long way.
We can focus on non-code related tuning (indexing, statistics, etc.)
Often the vendor will incorporate our recommendations into their base code
We can still often “change the code” without touching the code with techniques that focus on changing the execution of the SQL and not the code
"Overall Performance Analysis"
These reports show the bang-for-the-buck performance opportunities in your system
"Individual Performance Recommendation"
These documents clearly present a solution with before/after performance metrics and the supporting rationale. Great for learning!
Reports that follow up in the production environment to confirm expected gains on recommendations
We can help establish a true application performance process in your shop
Defining roles/responsibilities
Ensuring the right tools are in place
Ensuring the right processes are in place
Industry reports show that over 80% of application performance issues are directly related to SQL at the database layer
Things To Think About...
What has been your recent cost history over the past couple years for expenditures to which you may have grown acclimated?
What are your upcoming costs or expenditures due to scaling or performance issues
What are your mission critical applications and functions?
Are there recurring performance problems regardless if analysis has been performed?
Are there runtimes on batch processes that frequently breach their allotted time window?
Are your end users completely satisified with the performance of all mission critical processes?
What is your proactive performance strategy?
Hardware purchases (CPU, Memory, DASD)
Database license fee escalations, due to increased CPU needs
Software license fee escalations, due to increased CPU needs
What if you could defer or eliminate that upcoming expenditure?
Furthermore, what are the top 10% most critical functions in those applications? Have you done everything you can for optimized performance?
If no, is there a pattern of hardware purchases to mitigate scaling or performance issues?
Are those processes extending the time windows of other processes? Is the system overly taxed when those processes execute?
Or....have they just acclimated to inefficient performance?
Any proactive production monitoring, reporting and alerting?
Any benchmark or system test phase to catch performance issues before production?
Any development or design phase activity to correct performance issues in their infancy?
