As a DBA, how to manage and maintain an enterprise-class database management system.

Data | Databases as a qualified DBA (database administrator), you need to have a profound knowledge of computer software and hardware, especially the technology within the DBMS. Also have the ability to analyze and solve problems. Give an example. The database application system of an enterprise has been running for a period of time, due to the accumulation of data, there is a significant lag in data access and processing, please analyze the possible causes and take appropriate measures to solve the problem. This is a typical operation analysis and performance adjustment problems, the system after running for some time, the increase of data will affect the system response speed, and all aspects of the business will be fully expanded, concurrent transactions will reach a certain number. The question should be considered in the following ways:
1, the hard drive to organize, reduce the number of fragmented database files (for Windows system).

2, the large data table to be indexed, the table associated with the view of the associated items indexed.

3, according to the transaction monitoring data, determine whether there are frequent deadlock-prone transactions, the transaction procedures to modify.

4, the data file and transaction log file capacity expansion, to increase the remaining space.

5, the various parameters of the DBMS are adjusted accordingly.

6, export the historical data no longer used.

7. If the above measures still cannot increase the response to the allowable level, consider increasing memory and switching to a high-speed hard drive, or even replacing the entire database server hardware.