kevriley (12/11/2009)
No it's not because you ran it in the master db - it will report activity across all databases.It could be that nothing was actually running at that point. Try running over and over to see if you get anything.
Alternatively remove the line that ignores the current statement - then at least you should see yourself.
OK, I did as you suggested, and at first didn't see any activity. But it is Friday, not all of our users are here, and so I decided to get into one of our apps and run a Crystal Report there that I know is a hog. Sure enough, that SP started showing me the line being executed, what database, etc. Cool. I like it!
Kindest Regards, Rod Connect with me on LinkedIn.