Explain Issues For Database Performance?

1.	Explain Issues For Database Performance?
Answer» The installation of the database is an IMPORTANT issue since the better the installation, the better the performance could be. Memory usage is learning how the DBMS USES MAIN memory and then using that KNOWLEDGE to enable better performance. I/O is usually very intense in a DB, so understanding how users will use the data will help to prepare the database better. CPU usage and application tuning are also important considerations. The installation of the database is an important issue since the better the installation, the better the performance could be. Memory usage is learning how the DBMS uses main memory and then using that knowledge to enable better performance. I/O is usually very intense in a DB, so understanding how users will use the data will help to prepare the database better. CPU usage and application tuning are also important considerations.

Answer»

The installation of the database is an IMPORTANT issue since the better the installation, the better the performance could be. Memory usage is learning how the DBMS USES MAIN memory and then using that KNOWLEDGE to enable better performance. I/O is usually very intense in a DB, so understanding how users will use the data will help to prepare the database better. CPU usage and application tuning are also important considerations.

The installation of the database is an important issue since the better the installation, the better the performance could be. Memory usage is learning how the DBMS uses main memory and then using that knowledge to enable better performance. I/O is usually very intense in a DB, so understanding how users will use the data will help to prepare the database better. CPU usage and application tuning are also important considerations.

Discussion

No Comment Found

Related InterviewSolutions

What Is Lock Granularity?
In General, How Should The Boundaries Of A Transaction Be Defined?
Explain The Meaning Of The Expression Acid Transaction?
Explain The Necessity Of Defining Processing Rights And Responsibilities. How Are Such Responsibilities Enforced?
Explain How A Database Could Be Recovered Via Reprocessing. Why Is This Generally Not Feasible?
Define Rollback And Roll Forward?
Why Is It Important To Write To The Log Before Changing The Database Values?
Explain The Difference Between A Database Administrator And A Data Administrator?
What Is The Foreign Key?
What Is A Candidate Key?