what's the fastest way to capture top 5 most intesive running SQL and actulally make a PRACTICAL recommendation that what we have to do with thse?
Printable View
what's the fastest way to capture top 5 most intesive running SQL and actulally make a PRACTICAL recommendation that what we have to do with thse?
Define "intensive". I/O intense, CPU intense, Latch Intense, etc.
Simple, measure the metric that you say is "intense" and tune the query. If your query is using lots of CPU, figure out how to reduce it. If it's causing a lot of I/O, reduce it.