Why is the database getting overloaded?

Your database server is going nuts with CPU alarms. Applications that use it are working, but are slow. How do you find out what’s wrong with it? Good answer

Check process to check it comes from the db process and not some rogue process – use top
Might look at netstat on the database port
Looks at open database conns vs available conns example commands here
Runs some database commands like “SHOW FULL PROCESSLIST;”
Might turn on query logging
Might look at timing data logging in the database clients