Profile MS Access

[Bala]

I would like to profile the Trace (Select, Inseert, Update and Delete) SQL
statements fired to a specifc MS Access 2000 database like the SQL Profiler
tool supplied with MS SQL Server. Is it possible to do this?

 

['69 Camaro]

Hi, Bala.

I would like to profile the Trace (Select, Inseert, Update and Delete) SQL
statements fired to a specifc MS Access 2000 database

You may be interested in Jet's ShowPlan, a query analysis tool. Please see
the following Web page for a link to the article, "Use Microsoft Jet's
ShowPlan to Write More Efficient Queries":

http://www.Access.QBuilt.com/html/articles.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.

 

[Bala]

Hi ,

Thanks for your reply... Your reply has shown me new ways to try for the
solution I am looking for. Jet's Show plan is printing the Query plan the Jet
Engine is going to use to execute the query. My primary objective is to
capture the queries which are fired to the database. If option for filtering
the database is available it will be great.

Is there any other option available, so that the ShowPlan.out file will
contain the Query itself or some other option to be set in the Jet Engine to
output the queries fired to the Database.

Thanks & Regards
Bala...

 

['69 Camaro]

Hi, Bala.

Is there any other option available, so that the ShowPlan.out file will
contain the Query itself or some other option to be set in the Jet Engine
to
output the queries fired to the Database.

I'm an Oracle DBA, so I use and build tools designed for Oracle, not Jet.
AFAIK, the only settings available for Jet's ShowPlan are the Windows
Registry settings, so you'll need to look at Jet's Registry Keys. Perhaps
someone else is more familiar with Jet's ShowPlan and has some tips to offer
you. I would suggest posting a new question in the Access Queries newsgroup
asking for those tips or advice on any third-party tools for query analysis.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

 

[Bala]

Thanks. I will post the same query in Access Queries news group also...