Performance monitoring and Tuning
- The DBA should monitor the database for any issues such as slowing down of database processes and correct these issues when they occur. Hardware capacity, operating system configuration and database configuration all can contribute to the slowing down of the processes running on the server.
- Database layout and disk drives, database indexing methods used, and the query methods used can contribute to the processes running slowly on the database server. The DBA should use the best monitoring tools to monitor all these activities and tune these activities just in case a database slows down.
Description
November 29, 2018