nabeelmoeen
asked on
Monitor queries executing on Pervasive SQL at run time
Hi,
I have an application whihc uses Pervasive SQL as a backend.
Is there any tool for Pervasive similar to Microsoft's Profiler for MS SQL server?
i would like to monitor the queries being executed behind the application?
can this be achieved using Audit master?
So far that i have checked .. i think that Audit Master only displays modifications made to the database, not the retrievals or the queries being used.
Regards,
Nabeel Moeen
I have an application whihc uses Pervasive SQL as a backend.
Is there any tool for Pervasive similar to Microsoft's Profiler for MS SQL server?
i would like to monitor the queries being executed behind the application?
can this be achieved using Audit master?
So far that i have checked .. i think that Audit Master only displays modifications made to the database, not the retrievals or the queries being used.
Regards,
Nabeel Moeen
ASKER
i'm assuming you mean executin sQL directly from the App as opposed to Stored procedures?
i guess it does for generating reports, as there arent any sp's in the database.
And what i want to determine is the tables its accessing to fetch the data.
i guess it does for generating reports, as there arent any sp's in the database.
And what i want to determine is the tables its accessing to fetch the data.
ASKER
and the queries used to fetch the data.
I'll take a look at the pdf. btw, the first page mentions its for Pervasive 2000 ... would it work with version 8.x even if this is THE tool =)
I'll take a look at the pdf. btw, the first page mentions its for Pervasive 2000 ... would it work with version 8.x even if this is THE tool =)
The QPV applies to all versions of PSQL (2000, v8, and v9). The QPV monitors all SQL queries executed at the engine. This means standard SQL and Stored Procedures.
THe application may not use SQL. It may use the Btrieve API. If it does, the QPV will NOT help.
To determine which interface the application uses, call the vendor of the application.
THe application may not use SQL. It may use the Btrieve API. If it does, the QPV will NOT help.
To determine which interface the application uses, call the vendor of the application.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanx for the help mirthell,
i got the QPV working, though it just displayed the top level query
it might be that the application is using Btrieve APIs :(
i got the QPV working, though it just displayed the top level query
it might be that the application is using Btrieve APIs :(
ASKER
Great help Bill
Saw your solution a bit late though
i'll definitely give it a shot
Saw your solution a bit late though
i'll definitely give it a shot
ASKER
Bill, whats the default location of the trace file?
The default location is "C:\PVSW\BIN\MKDE.TRA". It's configurable in the PCC under Debugging (I think).
AuditMaster only tracks changes.
The Pervasive Monitor will give you general information about the database.
On thing to consider is that most PSQL applications don't use SQL and so the QPV won't help. Does the application use SQL?