Troubleshooting is virtually impossible if you don't have the information you need to actually track down a problem. For carrying out troubleshooting, data is everything. Without data and without the ability to see what is going on, the situation is practically hopeless.
In this chapter, you will be guided through the following topics:
Checking the overall database behavior
Checking for conflicts
Finding I/O bottlenecks
Inspecting system internals
Chasing down slow queries
External tools
Those topics will help you keep an eye on your system.