Monitoring Active Queries

Question

Post reply

Monitoring Active Queries

Dervey

SSC Veteran

Points: 217
More actions
August 18, 2009 at 7:59 am

#134873

Hi,
I am looking for an application/tool which will sit on my PC and show me the currently running active SQL queries on a database I choose.
The scenario is that I am running some bespoke software, and I want to watch how it interacts with the database when I interact with part of the software.
Anyone seen anything which caters for this? I am loathed to use the Activity Monitor in SSMS.
Thanks in advance
Paul

Viewing 4 posts - 1 through 3 (of 3 total)

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

oraculum SSCrazy Points: 2981 More actions · Answer 1

There are many products out there, why are you loathed to use activity monitor?

..combined with SQL 2005 DMV's and SQL Profiler this will give you a good overview.

also http://www.sqlservercentral.com/articles/DMV/64425/

I use Idera Diagnostic Manager and have trialed Idera Compliance Manager - maybe a trial of some software will give you what you need, Idera offer 14 days trial of their products.

Oraculum

Dervey SSC Veteran Points: 217 More actions · Answer 2

Hi There,

Thanks for your reply. I will check these solutions.

I am loathed to use the activity monitor as it only seems to show the last query sent by the software, which could be something like SET LOCK_LIMIT 0, whereas I want to see the SQL being passed to generate some reports, etc.

Thanks again.

Paul

oraculum SSCrazy Points: 2981 More actions · Answer 3

I think then DMV and Profiler would give you all the information you need.

If you use standard template in Profiler and select some events like;

Stored Procedures:

RPC:Completed

SP:Completed

SP:StmtStarting

TSQL:

Exec Prepared SQL

SQL:StmtCompleted

Plus any other items you wish to monitor.

Filters:

Your login name/your application name/ host name

Database Name/ID

This will given you a full interaction of sql to the database.

Oraculum