Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    7

    Unanswered: Is ther any tool similar like SQL Profiler for SQL server available for Sybase 7?

    Hello,

    my application is using sybase 7 database.I have to improve my application performance, for the same i would like to see what are all the queries that is getting fired from my application. Is ther any tool similar like SQL Profiler for SQL server available for Sybase 7.Please advice me.

    Thanks & Regards,
    Sathesh.M

  2. #2
    Join Date
    Jun 2004
    Posts
    115
    Hi

    For that if you are on 12.5 and above you should use something like MDA tables

    http://www.sypron.nl/mda.html

    I am not sure what to do if you are below 12.5.

    regards
    Hrishy

  3. #3
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    60
    I'm using Anywhere 9, those profile is available.
    Why not download Developer edition and evaluate first before migrate ?

    SQLCentral

    select database -> right click -> Profiling -> Start Profiling

    Can show how many times trigger is executed and how long does it takes


    Step Debugger also available

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Yes.. there is a debugger available in SQL 9 that can do similar as SQL profiler.

Posting Permissions

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