Even when you follow best practices, you are still bound to run into query performance problems. When you do, do you know the best way to troubleshoot them?
In this presentation, Mike will describe and demonstrate several tools you can use to troubleshoot query performance for both Access and SQL Server backend databases. Those tools include JetShowPlan, ODBC Trace SQL Mode, SQL Server Profiler, and even a couple of truly low-level utilities that probably don’t come to mind when you think of query troubleshooting.
Mike runs Grandjean & Braverman, Inc., specializing in Microsoft Access and SQL Server software solutions for government, banking, and insurance clients. He writes daily articles about advanced Access and VBA topics at nolongerset.com, where he’s published over 500 articles since 2020. Mike is the most recently awarded Access MVP, earning the award in November 2021.