SLOW QUERY immediately tells us PMS is heavily bogged down waiting for the database.
There is either:
a. A great deal of media activity (adding / deleting / updating)
b. A great deal of I/O (regular disk I/O or memory swapping).
c. So much has happened over time that the database is simply fragmented into excess
Start with the easiest:
- Go to the Server name (left pane) -> Manage Server -> Optimize Database
- Give it a minute to finish.
- Is it more responsive?
- If not, Settings - Server - Troubleshooting - Download Logs
- Attach the ZIP file
