Timeline for Executions/min and CPI ms/sec inside Activity Monitor is too high
Current License: CC BY-SA 4.0
5 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Mar 10, 2021 at 6:25 | history | bounty ended | Imran Qadir Baksh - Baloch | ||
Mar 7, 2021 at 15:12 | vote | accept | Imran Qadir Baksh - Baloch | ||
Mar 7, 2021 at 11:05 | comment | added | Stephen Morris - Mo64 | Yes which is 333 execs / sec - that seems entirely possible. To get to the bottom of why your server has a high number of executions you are going to need to run Query Store, Extended Events or a Trace. Probably the quickest and easiest way for you is to use Erik's SP which will create an extended events session and analyze the results for you erikdarling.com/sp_humanevents They've been 3 recs on my answer - so I'd like to know in what way it is deficient so I can add additional details and you then feel able to accept it - thanks | |
Feb 27, 2021 at 6:20 | comment | added | Imran Qadir Baksh - Baloch | executions/min means query is executing 20,000 times per minutes? | |
Feb 25, 2021 at 9:15 | history | answered | Stephen Morris - Mo64 | CC BY-SA 4.0 |