In your own words, write a definition of performance tuning. Once you have done
ID: 3560264 • Letter: I
Question
In your own words, write a definition of performance tuning. Once you have done so, answer the following questions: What is the difference between SQL performance tuning and DBMS performance tuning? Your book states, "No amount of fine tuning will make a poorly designed database perform as well as a well-designed database." What does this mean in your own words? What is a query processing bottleneck and what are the five components that typically cause bottlenecks?
Give me a fresh answer to each question and not one that has been recycled. I will paraphrase and elaborate. I need this within two hours.
Explanation / Answer
Database tuning aims to maximize use of system resources to perform work as efficiently and rapidly as possible. Most systems are designed to manage their use of system resources, but there is still much room to improve their efficiency by customizing their settings and configuration for the database and the DBMS.
DBMS tuning refers to tuning of the DBMS and the configuration of the memory and processing resources of the computer running the DBMS. This is typically done through configuring the DBMS, but the resources involved are shared with the host system.
Tuning the DBMS can involve setting the recovery interval (time needed to restore the state of data to a particular point in time), assigning parallelism (the breaking up of work from a single query into tasks assigned to different processing resources), and network protocols used to communicate with database consumers
1. Process as Much Data as Possible Inside the Database
Most serious performance problems in DBMS applications come from moving raw data around needlessly, whether it is across the network or just in and out of cache in the DBMS. A good method for minimizing this waste is to put your logic where the data is