Monitor Queries

[ewest305]

In MS SQL SERVER, there is SQL PROFILER which has the capability to
monitor queries sent to SQL SERVER instance.

Does ACCESS have something similar (either intrinsically or not) ?

I need to monitor some queries to an ACCESS database (97 version but
can convert to later if need be).

Any ideas appreciated. Thanks.
E

 

[Albert D. Kallal]

It is not clear if you are looking to interactive enter sql, or do you want
to display the query plan (the strategy, and if things like table scans vs
indexes are being used?).

There is a registry entry you can set, and when a JET query is run, the
query plan, and optimizations used can be viewed.
(they are appended to a log file..so, don't forget to turn this feature
off...as that file will get huge..and slow things down).

I can 't find a link, but the use showplan is mentioned in the performance
white paper here

http://support.microsoft.com/default.aspx?scid=kb;en-us;162701

 

[ewest305]

Yes, that must be the term for it because i know ive seen it somewhere
before (strategy, or execution plan).

Knowing that, I am off in the right direction with the provided
link/white paper.
Thanks for the help, Albert.
E