amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.17k stars 289 forks source link

Strange values for Reads and CPU for fast requests #22

Closed rrg92 closed 2 years ago

rrg92 commented 4 years ago

Hey Guys!

Look at this case using sp__whoisactive v11.34 (happens v11.00 also)

image

I guess the numbers showing in reads and CPU are very high... This environment is not able to read 200+ millions of pages in 180ms... 1.5TB in less than 1 second...

This seems a problem in whoisactive when multiple requests run in the same session very fast (complete in some milliseconds).

The environment is a Hyper-V with Windows Server 2019

amachanic commented 4 years ago

This just means that your I/O system is very well tuned!

Seriously, though, can you comment out line 2907, which should be:

AND s.last_request_end_time <= sp.last_request_end_time

... and let me know if that helps? This line seems to be causing some similar issues and I have a hunch it's related to this.

amachanic commented 2 years ago

@rrg92 Been a while. What did you end up doing here? Can you still reproduce this today? If so can you try the test I mentioned above? Either way, please advise on the current status.

rrg92 commented 2 years ago

Hi Adam, sorry for the delay and thank your answer. I can't reproduce this again. We can close this issue and I will try to reproduce the issue in the future. If I see the problem I will try the fix you mentioned and reopen it. Ok for you?