> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Troubleshooting Query Performance
- URL: https://nolongerset.com/troubleshooting-query-performance/
- Published: 2022-03-18T00:00:00.000Z
- Updated: 2026-05-08T12:59:01.000Z
- Description: A recording of the presentation, a list of resources, and further reading for my presentation on Troubleshooting Query Performance.
- Author: Mike Wolfe
- Tags: Presentations, #Import 2026-05-20 02:59

## Presentation Video

George Young has [posted a video](https://www.youtube.com/watch?v=xjc%5FLk1hTjg) of the presentation to the Denver Area Access User Group's YouTube page: 

## Slide Deck

[TroubleshootingQueryPerformance.pdf](https://assets.nolongerset.com/2022/TroubleshootingQueryPerformance.pdf)

## Further Reading

Over the past year and a half, I've written several articles related to troubleshooting query performance in Access. Let me know in the comments if there are any topics you would like to see covered more in-depth.

### Overview

[Tuning Access Query PerformanceThe four best tools/techniques for tuning Access query performance: JetShowPlan, Process Monitor, TraceSQLMode, and SQL Profiler.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/tuning-fork-1906404_1920.jpg)](https://nolongerset.com/tuning-access-query-performance/)

### Jet Show Plan

[JetShowPlan: A PrimerYou may be familiar with JetShowPlan, but I guarantee you’ve never read an article about it quite like this one.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/military-raptor-582888_1920.jpg)](https://nolongerset.com/jetshowplan-a-primer/)

[Signal vs. Noise: ShowPlan.out EditionReading showplan.out files can be intimidating for new and experienced Access developers alike. This simple rule will help get you started.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/bible-2866584_1920.jpg)](https://nolongerset.com/signal-vs-noise-showplan-out-edition/)

[JetShowPlan ManagerThe quickest and easiest way to get started analyzing Microsoft Access query performance is with IslaDogs’ JetShowPlan Manager application.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/aircraft-carrier-79466_1920.jpg)](https://nolongerset.com/jet-showplan-manager/)

[3 Ways to Find Showplan.outFinding Jet ShowPlan’s showplan.out file can be deceptively difficult. Here are three approaches to make it easy. At least one is guaranteed to work.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/02/Finding-Showplan.jpg)](https://nolongerset.com/finding-showplan-out/)

### ODBC Trace SQL Mode

[Making Sense of SQLOUT.TXTYou’ve enabled ODBC Trace SQL Mode and created a sqlout.txt file. But do you know what to do with it now? Let’s explore.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/Making-Sense-of-sqlout.txt.png)](https://nolongerset.com/making-sense-of-sqlout-txt/)

[Toggle ODBC TraceSQLMode with an AutoHotKey ScriptTraditional methods of enabling and disabling ODBC TraceSQLMode are a pain in the neck. This AutoHotKey script makes it as easy as pushing a button.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/button-4203036_1920.jpg)](https://nolongerset.com/toggle-odbc-tracesqlmode-with-ahk/)

[3 Ways to Find sqlout.txtFinding ODBC TraceSQLMode’s sqlout.txt file can be deceptively difficult. Here are three approaches to make it easy. At least one is guaranteed to work.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/Finding-Sqlout.txt.jpg)](https://nolongerset.com/finding-sqlout-txt/)

### XEvent Profiler

[How Access Reads Data From SQL ServerHow does Microsoft Access pull data from SQL Server? You’ll be amazed when we pull back the curtain to expose how Access interacts with SQL Server.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/02/data-2899900_1920.jpg)](https://nolongerset.com/how-access-reads-data-from-sql-server/)

[Playing Telephone with SQL ServerYou won’t believe how Access and SQL Server actually talk to each other. You’re going to need to see this for yourself.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/01/telephone-450639_1920.jpg)](https://nolongerset.com/playing-telephone-with-sql-server/)

### ProcMon

[Using ProcMon to Troubleshoot Registry CallsFinding the correct registry keys for JetShowPlan and ODBC TraceSqlMode can be tricky. Let ProcMon take the guesswork out of the process.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/02/needle-1419606_1920.jpg)](https://nolongerset.com/procmon-troubleshoot-registry-calls/)

[DISTINCT vs. GROUP BY: Microsoft Access Speed TestThe GROUP BY and DISTINCT clauses can both be used to generate identical results. But which one is faster in Access? And--more importantly--why?![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/burst-4712794_1920.jpg)](https://nolongerset.com/distinct-vs-group-by-jet-speed-test/)

### WireShark

[Troubleshooting Access Hanging When Switching to Design ViewHow I used two low-level tools--ProcMon and WireShark--to figure out why Access was taking forever to switch to design view in forms and reports.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/shark-3197585_1920.jpg)](https://nolongerset.com/troubleshoot-access-hanging/)

---

### Past Presentations

If you enjoyed this presentation, you may want to check out some of my past presentations. Each of these has accompanying videos of the presentation available on YouTube (links to YouTube included in articles below):

[Advanced Combo Box TechniquesA list of resources and further reading to support my presentation on Advanced Combo Box Techniques.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/06/AdvancedComboBoxTechniques.jpg)](https://nolongerset.com/combo/)

[ArrowKeyNav PresentationA list of resources and further reading to support my presentation on Navigating Continuous Forms using WithEvents.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/05/ArrowKeyNav-Talk.png)](https://nolongerset.com/arrowkeynav/)

[DevCon 2021Links and resources from my talk today at Access DevCon Vienna 2021, twinBASIC: The New Kid on the Block.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/04/2021-04-20-17_18_00-GBM18-TwinBasic-DevCon2021.pptx---PowerPoint.png)](https://nolongerset.com/devcon-2021/)

### Future Presentations

I'll also be presenting at the following upcoming events:

[Access DevCon Vienna 2022Mark your calendars and register for Access DevCon Vienna! The event will be held virtually via MS Teams on April 28 and 29, 2022, from 10 AM - 4 PM EDT.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/building-4403839_1920.jpg)](https://nolongerset.com/access-devcon-vienna-2022/)

[Access Europe – Mike Wolfe (Building Ribbon Interfaces in Code) – Europe – AccessUserGroups.org![](https://accessusergroups.org/europe/wp-content/themes/access-user-groups/img/apple-touch-icon.png)![](https://accessusergroups.org/wp-content/uploads/2014/08/web-enable-Access.jpg)](https://accessusergroups.org/europe/event/access-europe-2022-07-06/)

***UPDATE*** *\[2022-03-18\]: Added link to a recording of the presentation on YouTube (thanks for the quick turnaround George!).*