Comprehensive Database Assessment

Our Comprehensive Database Assessment Service is available when your organization requires a thorough review of your database environment. This could be because you want the database to function at its peak and you want to ensure that everything has been done to make it perform at its best. Or you could want an assessment because the users are unhappy with the performance of the database. Whatever the reason, we can review the database environment and provide recommendations to improve it.

Common reasons for wanting an evaluation include:

The response time of the database queries is unsatisfactory
The reports are running slow
The batch jobs are taking longer than the available window
The database is not stable; it crashes or slows down over time
Evaluation to see if the database setup can be improved
Assessment of backup and recovery procedures (recoverability)

Our Comprehensive Database Assessment Service provides a thorough evaluation of the database for stability, availability, recoverability and responsiveness. It involves a visit by one of our consultants to your database where we collect performance data using our proprietary tools. We collect information on server environment, database layout and configuration, analyze the important schemas, quantify the database activity and identify bottlenecks. We perform trend analysis, analyze the setup for availability and recoverability and then we analyze the collected information and write a report with specific recommendations for improvement.

Our Database Consultants have a lot of experience in analyzing databases with an eye to improving performance and we have yet to encounter a database that could not be improved. The Comprehensive Database Assessment Service is offered as a standard package at a fixed price. For custom assessments we charge by the hour, so you only pay for what you need. For details and pricing please contact us.

Call today for a sample Comprehensive Database Assessment Report!

I have worked with DTA for over four years. We began working together at the point where our customer base was beginning to grow and our home-grown data warehouse was suffering scalability issues. DTA helped guide us towards a more scalable solution that is still in use today at over 100 customers, many of whom have multi-terabyte data warehouses. When it came time to design our new data warehouse, we worked closely together with DTA to specify, design, and implement a highly scalable Oracle Enterprise Edition data warehouse. DTA has been involved in many customer support issues. They always work extremely well with engineering and customers to perform root cause analysis. They are unbiased, thorough, and their Oracle knowledge is superb. If you are looking for a DBA or someone to work more closely with you as an implementation partner, I recommend DTA without hesitation. You won't be disappointed. I look forward to working with DTA again in the future.

Mark Sexton
formerly Director
Application Software Development of Arbor Networks.