Techniques for profiling slow queries, analyzing wait events, tracking lock hierarchies, and capturing system-level traces to isolate transient performance spikes.