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

• oraculum

  SSCrazy

  Points: 2981

  More actions

  August 18, 2009 at 8:25 am

  #1040917

  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

  August 18, 2009 at 8:30 am

  #1040923

  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

  August 18, 2009 at 8:56 am

  #1040937

  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