Executions/min and CPI ms/sec inside Activity Monitor is too high We have executions/min is too high, around 20,000 to 30,000 for a query. Does this means the query is executing 20,000 per minute? I don't think we have that much load on server that a single query runs 20,000 per minute.
Also, I am always confused with CPU ms/sec. Does this means total CPU used per second? If yes how come we have lot of queries with 1000+ CPU ms/sec as we have limited CPU on server.
One possible way to run a query very many times is to use a scalar user defined function as that will execute once per row in the query.
If you have multiple CPU cores each one can support 1000ms / second which is why total CPU appear strange and go over what seems possible