Post reply

Simple Client Side SQL Capture Utility

  • May 6, 2005 at 9:42 am

    #166758

    Hello All,

    I am new to the SQL server world so forgive me if I am asking things that are pretty basic. 

    I came from an oracle environment in which they used a Database Management tool called TOAD (Tool for Oracle Application Development) in this tool there was a really neat utility that captured all of the SQL traffic between the applications running on a client work station and any Oracle databases it was connected to.  It was really light weight and simple but worked great for analyzing the SQL that a particular work station was sending to any oracle database it was connected to.  I know SQL server has tools on the server side to capture this information but they use server resources and appear to require a lot more effort to single out traffic from a particular user. 

    I was wondering if any one was aware of a client side SQL capture utility similar to the one I used in my former oracle environment.

    Thanks in advance for taking time to think about my question.

     

  • May 6, 2005 at 10:01 am

    #557397

    you can use the SQL Profiler. or even the sp_monitor ...

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • May 6, 2005 at 10:46 am

    #557417

    SQL Profiler runs on the server side correct? 

    I am really looking for something that runs on the client side.  I am trying to avoid the drag on Server resources as well has having to figure out how to shift through all of the other information you get with profiler.

  • May 6, 2005 at 10:52 am

    #557419

    Profiler does run on the server. If you specify filters, you can narrow the results down to a login, machine, application, etc. It's really easy to do from the Profiler when you are setting up a trace. It really doesn't put much of a strain on the db server as long as you narrow your trace by using filters.

    Also, check out DBCC INPUTBUFFER in SQL Server Books Online.

    I don't know if there is a stand alone utility that runs on the client that will capture this information, but there is a version of TOAD for SQL Server (not as fully featured as the one for Oracle, or so I've heard - haven't used it myself).

  • May 6, 2005 at 12:17 pm

    #557439

    I did check out TOAD for SQL Server but they only have their SQL monitor tool for Oracle or MySQL.

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

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