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.
00:00 Performance issue in database
00:35 Business Logic
06:23 Data Design
07:48 Application design
10:38 Change Database structure (Indexes)
11:30 Tuning the SQL
11:55 What do mean by effective SQL
16:58 Access Path-Change the indexes
22:39 Instance tuning (RAM)
24:58 Tune the I/O-Physical storage
30:04 Tune resources-Locks
31:31 Tune the server
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
30 июл 2024
