Client websites can degrade significantly over time due to backend neglect even when the front end is well-maintained. Common culprits include runaway database queries, unresolved plugin conflicts, and bot traffic overwhelming the server. Left unaddressed, these issues manifest as 502 errors, slow load times, and poor Ahrefs health scores.
This article documents the diagnostic approach, fix methodology, and client communication strategy developed during a systematic audit of Asymmetric-managed WordPress sites.
Evidence: Crazy Lenny's Ahrefs score improved from 89 → 100 after fixes. Doodla improved from ~40 → 80. Multiple other sites were found scoring in the teens (Digital Arms B2B: 11, Three Gates: 16).
Use as a high-level triage metric. Prioritize sites scoring below 80. Target 80+ for all managed sites before polishing individual issues.
Reveals the number of active database queries per page load. A healthy site should run in the range of 50–100 queries. Scores of 600+ indicate a serious problem — typically caused by plugin conflicts, unoptimized queries, or bot-driven traffic spikes.
Check the Insights → Performance and Errors panels. Thousands of logged errors indicate systemic backend problems, not one-off issues.
Review traffic logs for bot attack patterns. Days with abnormally high request volumes are a strong signal that bot blocking rules need to be updated.
Symptom: Server overwhelmed, 502 errors, high query counts, slow response times.
Fix: Update Cloudflare firewall rules to block known bot signatures and suspicious traffic patterns. This alone can dramatically reduce query load and error rates.
Symptom: High query counts even without bot traffic; Query Monitor shows database errors.
Fix: Run a database optimization (repair tables, clear transients, remove post revisions). Identify and deactivate plugins generating excessive queries.
Symptom: Errors in Query Monitor tied to specific plugin hooks; unexplained slowdowns after plugin updates.
Fix: Audit active plugins. Deactivate and test in isolation. Remove or replace plugins that generate persistent errors.
Symptom: WP Engine shows low cache hit rates, meaning most requests are hitting PHP/database rather than serving cached responses.
Fix: Ensure caching is properly configured at the WP Engine level. Verify Cloudflare caching rules are not bypassing the origin cache unnecessarily.
Work from the bottom up by Ahrefs score:
When reporting these fixes to clients, frame them as proactive maintenance, not as corrections to past neglect. This avoids prompting the question "why was it broken in the first place?"
Recommended framing:
"We've been doing some deep maintenance on your website — optimizing the database, updating our bot-blocking rules, and auditing plugins. Your Ahrefs health score is now [X], and your query load is running cleanly."
Avoid:
"We found a bunch of errors and your site was getting hammered by bots and had 600 database queries running at once."
The good-news lead (score improvement, clean query monitor) is the right anchor. Clients like Steve at Crazy Lenny's may not push back, but clients at [1] or Flynn would likely escalate if framed as a failure.