The most recent content from our members.
In DPA, I can see that my SQL Server's CPU utilization is riding about 25% during business hours. What is the easiest way for me to see which queries are using the most CPU? e.g. "This stored procedure is contributing to about 10% (2.5% overall) of the CPU usage." This seems to me to be different than monitoring wait stats…
I have a situation this morning where one of my Orion users is attempting to run a very ugly report that results in 100% CPU utilization of my monster SQL server. All I can tell is what the query is, and that it's being run from my web portal (additional web server). Is there a way to track an Orion user (AD user) and tie…
It looks like you're new here. Sign in or register to get started.