In the previous chapter, you learned a lot about advanced SQL and ways to see SQL in a different light. However, database work does not only consist of hacking up fancy SQL. Sometimes, it is also about keeping things running in a professional manner. To do that, it is highly important to keep an eye on system statistics, log files, and so on. Monitoring is the key to running databases professionally.
In this chapter, you will learn these topics:
- Collecting runtime statistics
- Creating log files
- Gathering important information
- Making sense of a database statistics