Tracking running queries

Question

Post reply

Tracking running queries

richardmgreen1

SSChampion

Points: 10345
More actions
May 1, 2013 at 3:31 am

#272015

Hi all
In one of the daily emails (quite a while ago), there was a method for getting server performance and tracking what queries were running, etc.
I can't find the link any more, so if anyone has it could they send me a copy please?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Brian.cs Default port Points: 1407 More actions · Answer 1

Are you referring to dbWarden?

http://www.sqlservercentral.com/articles/Monitoring/98106/[/url]

richardmgreen1 SSChampion Points: 10345 More actions · Answer 2

It wasn't unfortunately.

I managed to dig out my old code, etc to track running queries.

This looks very useful as well so thanks for that.

Jason Wolfkill SSCrazy Eights Points: 9832 More actions · Answer 3

richardmgreen1 (5/2/2013)
It wasn't unfortunately.
I managed to dig out my old code, etc to track running queries.
This looks very useful as well so thanks for that.

Sounds like you may be thinking of Adam Machanic's Who Is Active stored procedure. Google will take you right to it.

Jason Wolfkill

richardmgreen1 SSChampion Points: 10345 More actions · Answer 4

richardmgreen1

SSChampion

Points: 10345

May 3, 2013 at 1:43 am

#1612093

Thanks for that, I'll have a look at that as well.

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

Yeah - sp_whoisactive is THE tool for monitoring current activity on a sql box. Here is a link to a 30-day blog post series he did on all the different things the sproc can do. AMAZINGLY flexible/powerful/useful, and FREE too!!

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/30/twenty-nine-days-of-activity-monitoring-a-month-of-activity-monitoring-part-30-of-30.aspx

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service