MSSQL Profiler Equivalent For Pervasive 2000i or V8 1

[ej00]

Does anyone know if there is a tool like MS SQL Server's Profiler that will allow me to monitor the SQL statements being issued against a Pervasive database? I have both 2000i and 8 of Pervasive if there is a tool with either of those versions. Basically, I want to see what tables and fields are being selected from and updated with an application I am running. Thanks for any help.

 

[TomKane]

Pervasive monitor is a bit like that but it doesn't have as much functionality. If you're accessing your data through odbc you could try setting the odbc trace on.

 

[ej00]

The app does use ODBC. I have tried tracing through the ODBC administrator however nothing gets logged against the Pervasive database. I did not see anything in the Pervasive monitor utility that showed the actual SQL and the query plan viewer (w3sqlqpv.exe) does not seem to do anything. Is there something I am doing wrong or a setup issue with either of these three options?

 

[mirtheil]

Here's a link that describes the Query Plan Viewer: http://www.sys-con.com/tango/archives/0102/sneary/index.html


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician