Results 1 to 4 of 4

Thread: Profiler

  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: Profiler

    Are there any SQL Profiler's in Pervasive SQL 2000 or v8? I'd love to see a profiler like MS SQL2000 has.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    You can use the Query Plan Viewer. I don't know how it compares to Profiler but it does give the query plan used by the Pervasive engine and shows whether (and which) indexes were used. For more information see: http://www.sys-con.com/tango/archive...ary/index.html
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Jan 2004
    Posts
    6
    Originally posted by mirtheil
    You can use the Query Plan Viewer. I don't know how it compares to Profiler but it does give the query plan used by the Pervasive engine and shows whether (and which) indexes were used. For more information see: http://www.sys-con.com/tango/archive...ary/index.html
    Thanks for the reply but I was looking for something else. MS SQL's PROFILER is used to see which SQL cluases are going on on the server. With the profiler I can see which SELECTs is my program running, when it run them, how long did they run etc..

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    In that case, you might look at http://www.pervasive.com/ComponentZo...+%2F+Utilities which is a tool from Pervasive's web site that times queries.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

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