Sample Header Ad - 728x90

Activity Monitor duplicates in recent expensive query

0 votes
1 answer
130 views
I have this strange issue on one of my DB (SQL Server 2016) in which the activity monitor display duplicates entries in recent expensive query. enter image description here In the picture above you can see a snapshot (only two lines) of the Activity Monitor, that display two indentical query (same query text, same execution plan, same target DB) as it was two distinct queries instead of grouping them and incrementing the field execution/min. What is happening here? it's just an Activity Monitor glitch or should i start to check what's wrong in my DB. I am afraid that the same ORM query (executed two times by differnt request) is not recognized by DB as the same query, and istead it's considered as two different queries, that will degrading performance.
Asked by Skary (368 rep)
Jul 3, 2023, 12:46 PM
Last activity: Sep 18, 2023, 10:21 PM