SQL Server Performance

Knowing queries/sp executed by any application

Discussion in 'Third Party Tools' started by Hover, Dec 21, 2005.

  1. Hover New Member

    Is there is any method or free tool (apart from SQL Profiler) available by which I can get what all stored procedures/queries are executed by an application when it is running.
    I dont have the source code of the application as it is a third party application.
  2. Luis Martin Moderator

    What you see using Profiler is what you will see with other software.
    Anyway, with Spotlight from Quest you can see what SP and Queries are in cache. With Diagnostic Manager, from Idera, you can get sp and queries not in cache but the longest ones.
    Nothing new, respect to Profiler.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. Luis Martin Moderator

    I've moved to relevant forum.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page