search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.13k stars 281 forks source link

Empty Results Set from sp_WhoIsActive #105

Closed Susja closed 1 year ago

Susja commented 1 year ago

Sorry Folks if this is not a right place to ask this question. I copy/paste this stored procedure from https://github.com/amachanic/sp_whoisactive to my client.

I ran this stored procedure against my SQL server but get 'empty' Results Set. I don't have any errors. This is the message: Started executing query at Line 1 Warning: The join order has been enforced because a local join hint is used. Warning: Null value is eliminated by an aggregate or other SET operation. Total execution time: 00:00:00.228

Where should I look to check the culprit? Thanks

erikdarlingdata commented 1 year ago

That’s just because no queries were running when you executed the procedure.