[Mullins02] Section 10.4. Summary and Review
来源:百度文库 编辑:神马文学网 时间:2024/04/29 01:39:15
Summary
Ifthe environment where the DBMS must operate is not performingefficiently, it is impossible for the DBMS, and indeed any databaseaccess, to perform efficiently. The DBA needs to understand every DBMSconfiguration value and the impact it can have on the overallperformance of the system. Furthermore, the DBA must control theintegration of the DBMS with the hardware on which the DBMS runs andany allied agent software.
Review
1: What is the single most important configurable component of a relational database management system? 2: How does the data cache (or buffer pool) improve the performance of database processing? 3: Describe how to determine the read efficiency of the data cache. 4: What components of the DBMS require system memory to control? 5: What three concurrency problems can negatively impact performance? 6: Why are certain database operations not logged? 7: A DBMS is comprised of multiple programs interacting with one another: True or False. 8: What are the three possible statuses of a page in the data cache? 9: What benefits can accrue by caching optimized SQL in memory? 10: What type of information is recorded on the database transaction log?Bonus Question
Q1: When a database operation is not logged, what precautions should the DBA take before and after the nonlogged operation? Why?Related Content
Sybase
From: Practical SQL Handbook, The: Using SQL Variants, Fourth Edition
Sybase ASE Monitoring
From: Configuring and Tuning Databases on the Solaris™ Platform
Monitoring and Tuning Sybase
From: Configuring and Tuning Databases on the Solaris™ Platform
Sybase Architecture
From: Configuring and Tuning Databases on the Solaris™ Platform
Creating Stored Procedures with Sybase
From: Adobe® ColdFusion® 8 Web Application Construction Kit, Volume 3: Advanced Application Development