Results 1 to 4 of 4

Thread: SQL trace

  1. #1
    Join Date
    Oct 2004
    Posts
    21

    Unanswered: SQL trace

    Hi,

    I'm new to Sybase and this question has possible been asked more than once.

    But is there really not an easy was to trace what SQL requests that is sent to the ASE server from a GUI?
    We are trying to support a SW (using ASE12.5) that we have not designed our self. So without source code or table diagrams is it hard to know what is going on in that application.

    Thanks,
    Hans

  2. #2
    Join Date
    Aug 2004
    Posts
    42
    We use a 3rd party tool for this. There are several out there. We use one called iWatch from ExactSolutions. It's not cheap. If you have a large installation, though, it can pay for itself pretty quickly -- either in performance tuning opportunities found (the main reason we use it) or in figuring out what is really happening.

  3. #3
    Join Date
    Oct 2004
    Posts
    21
    Thanks Tad,

    Do you know where I can find info about tools like this? Do you also know if there is any trial software of this kind?

    Hans

  4. #4
    Join Date
    Feb 2005
    Location
    Omaha, NE
    Posts
    83

    Look into Auditing

    Look into Auditing in ASE. There is a whole section of the manuals dedicated to this topic. It's freely available option for your ASE installation. Just need to create disk space for the devices of sybsecurity database, and then manage what you want to audit.

    http://manuals.sybase.com

Posting Permissions

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