Performance Tuning
Generally speaking, there are no surefire methods for obtaining optimal performance from a database system. However, there are guidelines that can assist administrators in implementing successful performance-tuning strategies.
Hardware Considerations
If you notice that your database system is consistently running at high CPU loads or that an excessive amount of hard-disk paging is occurring, it might be necessary to upgrade your hardware.
These are the four biggest hardware issues related to database performance:
RAM. Not enough RAM will result in the database constantly having to swap memory to hard disk. This expensive and time-consuming operation always incurs a performance hit.
Hard disk. Slow hard drives and controllers ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access