[MS_AccessPros] Re: Profiler for Access

 

Art

Your reg key is set to "ON" right now, right?

Did you run a search for files named *.out?

Bill

--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> I installed the new files and compacted my database and ran a query and I still don't get any output.
>
>
>
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
>
>
>
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Thursday, February 23, 2012 12:27 PM
> Subject: RE: [MS_AccessPros] Re: Profiler for Access
>
>
>
>  
>
> Art â€" I uploaded a 2010 version of the reg files. Run the “on” reg file. Open an Access db and compact it. Then run a query. The showplan.out file will be in your default database folder.
>
> Be sure to run the OFF reg file when you are done. The ShowPlan takes a lot of resources just as the tracer does.
>
> Regards,
>
> Bill
>
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art Lorenzini
> Sent: Wednesday, February 22, 2012 3:25 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Profiler for Access
>
> Yes I did.
> The key reads as follows in the registry editor:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Debug
>
> and the key is
> JETSHOWPLAN REG_SZ ON
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
> ________________________________
> From: John Viescas <john@... <mailto:john%40viescas.com> >
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Wednesday, February 22, 2012 5:18 PM
> Subject: RE: [MS_AccessPros] Re: Profiler for Access
>
> Art-
>
> Did you add the value JETSHOWPLAN and set it to "ON"? You do this in the Registry (Regedit.exe), not in any file.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Waco, TX)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Art Lorenzini
> Sent: Wednesday, February 22, 2012 4:59 PM
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: Re: [MS_AccessPros] Re: Profiler for Access
>
> Yes I added this key to the showplanon file:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Office\14.0\Access Connectivity Engine\Engines\Debug
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
> ________________________________
> From: John Viescas <john@... <mailto:john%40viescas.com> >
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Wednesday, February 22, 2012 12:23 PM
> Subject: RE: [MS_AccessPros] Re: Profiler for Access
>
> Art-
>
> You have to add the key.
>
> See also:
>
> http://www.techrepublic.com/article/use-microsoft-jets-showplan-to-write-more-efficient-queries/5064388
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Waco, TX)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Art Lorenzini
> Sent: Wednesday, February 22, 2012 12:17 PM
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: Re: [MS_AccessPros] Re: Profiler for Access
>
> This key does not exist:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Office\14.0\Access Connectivity Engine\Engines\Debug
>
> I only have:
> Common
> MSOExamples
> Outlook
> Registration
> User Settings
>
> Under HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Office\14.0
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
> ________________________________
> From: John Viescas <john@... <mailto:john%40viescas.com> >
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Wednesday, February 22, 2012 12:11 PM
> Subject: RE: [MS_AccessPros] Re: Profiler for Access
>
> Probably not. That writes a new key to:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\JET\4.0\Engines\Debug
>
> JETSHOWPLAN text value = "ON"
>
> You could try adding that key to:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Office\14.0\Access Connectivity Engine\Engines\Debug
>
> .. for Access 2010. For 2007, it would be in Office\12.0
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Waco, TX)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Art Lorenzini
> Sent: Wednesday, February 22, 2012 11:30 AM
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: Re: [MS_AccessPros] Re: Profiler for Access
>
> There is no text file being generated. Does it work with 2010?
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
> ________________________________
> From: John Viescas <john@... <mailto:john%40viescas.com> >
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Wednesday, February 22, 2012 11:24 AM
> Subject: RE: [MS_AccessPros] Re: Profiler for Access
>
> Art-
>
> It generates a text file in the folder where you have the database.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Waco, TX)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Art Lorenzini
> Sent: Wednesday, February 22, 2012 10:50 AM
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: Re: [MS_AccessPros] Re: Profiler for Access
>
> I installed it and double clicked on the ON and it looked like its turned on but it is not doing anything. Does it have to be in the folder where the DB resides?
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
> ________________________________
> From: Bill Mosca <wrmosca@... <mailto:wrmosca%40comcast.net> >
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Wednesday, February 22, 2012 9:25 AM
> Subject: [MS_AccessPros] Re: Profiler for Access
>
> Art
>
> Kinda, sorta. There is a logger that you can turn on/off thay will give you a trace. We have the .reg file in our files folder. It's called ShowPlanRegFiles.zip.
>
> Be sure to turn it off when you don't need it as it can be a big drag on performance just like the profiler is in SQLS.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , "Art" <dbalorenzini@> wrote:
> >
> > I know there is a profiler for SQL Server which captures TSQL commands being issued to a database. Is there something like that for Access 2010?
> >
> > Thanks,
> >
> > Art Lorenzini
> > Sioux Falls, SD
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (19)

Recent Activity:

• New Members 11
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___