Lastly, DBAs would be responsible for running queries themselves to track performance over time using ANALYZE TABLE. This would keep statistics for the optimizer current and flag any areas where changes or additions had affected performance levels. Without this insight, SREs can leave indexes in place that are either no longer needed at best, or that affect performance negatively at worst.
Planning Ahead
There are also lessons that need to be new zealand whatsapp number data re-learned on the operational side of databases. For example, there is an old saying that a DBA was only ever as good as their last backup. While you may hope that you never need to recover data after an issue, having a working and fully tested backup for any critical file is essential. In the world of databases, many SREs now rely on their cloud provider to run this for them.
While you can point to what your Service Level Agreement states around a backup and restore process, this may not accurately portray how quickly you can get back up and running after a problem. Firstly, this SLA is dependent on your backup being good and your being able to fully recover from it. Until you have actually loaded up a backup and started using that data again, you can’t be sure that you have fully protected your operations.