After a long time, I am going to write a theoretical topic which adds some different knowledge in our DBA career. I hope it will help our viewers to have deep knowledge about the database. Today I am going to explain about benchmarking in the database. Being a part of IT we have little idea about benchmarking. This concept you in IT at a different level.
What is Benchmarking?
Benchmarking is the process of comparing and measuring your organization against others, anywhere in the world, to gain information on philosophies, practices, and measures that will help your organization take action to improve its performance.
Components of Benchmarking are mention below:-
- Control logic
When a database becomes huge, query performance can suffer. With the help of benchmarking, we can solve the following issues.
- Transactions per unit time.
- Response time, the scalability.
- Support for concurrency.
With help of Oracle Performance Tuning and Benchmarking Oracle corporation provides there customers consistent, optimal performance of Oracle Databases by proactively identifying and addressing issues before they become critical.
Performance Tuning and Benchmarking Process
- Baseline Performance Assessment
As per customer’s requirements database and application profile, performance expectations to set service expectation, outcome and success criteria. Monitor the customer database for a period of time (up to 7 days) and collect relevant data for the performance assessment. Analyze results and upload reports and recommendations to the Oracle Advanced Support Portal
- Performance Metrics
Based on the assessment, identify metrics (up to 15 metrics) that represent customer pain points. Discuss and Finalize metrics with the customer. Set threshold and monitoring for the metrics. Trending reports with daily, weekly, monthly, quarterly views available on the Oracle Advanced Support Portal.Metrics can be reviewed every quarter and changed as needed
- Quarterly Performance Assessments
Quarterly Performance assessments to proactively identify and address issues. Review the metrics for consistency and threshold accuracy and change it as needed. Analyze results and upload reports and recommendations to the Oracle Advanced Support Portal
- Tuning Days
3 tuning days/quarter to help with issues that arise. The connected model ensures any issues can be resolved faster because diagnostic data is available right away reports/recommendations to the Oracle Advanced Support
- PRESENT/WEB CONFERENCE
Web conference between you and Oracle to review reports and recommendations
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp