Have you ever thought of logging the slow queries into a textfile? I assume that they are mostly search-queries over all forums, but logging them would help a lot.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
