+ Post New Thread
Results 1 to 4 of 4
How do you do....it? Thread, Monitor SQL usage in Technical; Any one know of a way (free) to monitor what sql statements a program is sending to a sql server?...
  1. #1

    Join Date
    Feb 2007
    Location
    Lincolnshire
    Posts
    120
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Monitor SQL usage

    Any one know of a way (free) to monitor what sql statements a program is sending to a sql server?

  2. #2

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,850
    Thank Post
    110
    Thanked 598 Times in 514 Posts
    Blog Entries
    1
    Rep Power
    227

    Re: Monitor SQL usage

    Wireshark?

  3. #3
    JohnCondon's Avatar
    Join Date
    Apr 2007
    Location
    Bromcom
    Posts
    283
    Thank Post
    48
    Thanked 65 Times in 42 Posts
    Rep Power
    27

    Re: Monitor SQL usage

    MSSQL Profiler is built into the Full release of SQL. This can be used to montior any and all SQL requests coming into a database.
    As a component that may already be part of your install it could be considered "free".
    Only operational flaw with it in your scenario is if you are trying to track the input from one particular application as Profiler logs "everything" coming into the SQL server.

    Hope that helps

  4. #4

    Join Date
    Feb 2007
    Location
    Lincolnshire
    Posts
    120
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Monitor SQL usage

    Thanks guys



SHARE:
+ Post New Thread

Similar Threads

  1. cpu usage 100%!!
    By marky2027 in forum Hardware
    Replies: 12
    Last Post: 22nd November 2007, 05:51 PM
  2. Port Usage
    By Craig_W in forum Wireless Networks
    Replies: 4
    Last Post: 14th May 2007, 09:11 AM
  3. NIC Usage
    By techyphil in forum Windows
    Replies: 8
    Last Post: 23rd April 2007, 09:45 PM
  4. Windows 98 Usage
    By linuxgirlie in forum Windows
    Replies: 20
    Last Post: 6th February 2007, 11:08 AM
  5. Print usage
    By CyberNerd in forum How do you do....it?
    Replies: 3
    Last Post: 15th March 2006, 03:52 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •