SA: Tracing Query Performance with SQL Server Profiler, by Philipp Steifel - Access with SQL Server
For the most part, using Extended Events is the recommended way to do profiling on your queries and SQL statements, but if you just want to do an ad hoc session on your development server, SQL Server Profiler is easier to use, according to Philipp Steifel.
Tracing Query Performance with SQL Server Profiler
by Philipp Steifel ([email protected])
http://www.codekabinett.com
9 February 2021
YouTube video: Why (still) use SQL Server Profiler?
• Why (still) use SQL Server Profiler?
article:
Microsoft Access - ODBC Linked Tables – Mechanisms and Performance
by Philipp Stiefel
https://codekabinett.com/rdumps.php?L...
If you link SS tables to Access with ODBC and you have a query with a few tables, maybe it is 2 seconds to execute. Oddly, if you add another table, the time might go up to 10 minutes! So something is going very wrong. The core problem is the Access database engine, according to Philipp, not the driver. Access ends up breaking the query up into smaller parts, which you can see when you use the profiler.
Phil often uses the original SQL Server driver to get past distribution issues. Juan says that he turns queries into SQL Server views for better performance, and likes to always use the newest driver.
Juan also discusses the online SQL Converter, issues with Windows 10, and mentioned lambda expressions in Excel. Ben Sacherich shares a link to learn and try regular expressions. Klaus Oberdalhoff talks about using Power Shell to put data in SQL Server.
AccessUserGroups.org
Access with SQL Server chapter lead by Juan Soto
2nd Tuesday @ 6:30 pm Central time CT -- join us!
online SQL Converter
https://accessusergroups.org/sql-conv...
2:30 Windows 10 - How to turn off automatic updates from Juan 'at the beach'
2:37 article about Windows 10 update disaster
— Microsoft confirms app crashes and blue screens of death, By Tom Pritchard February 08, 2021
"Windows 10 updates strike again, but fortunately a fix is imminent"
https://www.tomsguide.com/news/window...
2:47 article about How to stop automatic updates on Windows 10
https://www.windowscentral.com/how-st...
"Do you want to disable automatic updates on Windows 10? If so, in this guide, we share three ways to stop this behavior and decide when to install them."
3:19 introduce Philipp Steifel
25:49 SQL Server Profiler -- you will have this if you installed the SQL Server client components, and you need a high level priviledge account to do it.
27:55 Extended Events don't need excessive permissions
29:15 filter down to the things you want to see
32:40 if you want to use Profiler, there is one thing you should do first -- go to Properties, Events Selection
33:16 Column Filters in the lower right corner to filter the LoginName to be Like northwind%
36:34 clear all trace data and run the Order Summary query
39:39 CPU load, Reads, and Duration (milliseconds) tell you how expensive the query is
40:44 one of the reasons that using Profiler instead of extended events is discouraged is because there is quite a big performance drop on the server
41:45 Invoice Data query has 6 tables. It runs fairly quickly, but the query is split up in lots of different queries.
44:42 huge drawback with pass-through queries is that they're read-only.
53:20 query only the data that you need
55:55 Excel using a new programming language in their product - define functions without using VBA -- not sure what the link was in the chat, but am guessing it was about Lambda
58:30 question for Klaus about how to use Power Shell to put data in SQL Server
link from Ben Sacherich to learn and experiment with regular expressions:
https://regex101.com/
Announcing LAMBDA: Turn Excel formulas into custom functions
https://techcommunity.microsoft.com/t...
SUBSCRIBE for MORE videos! ► https://bit.ly/AUGYoutube
REGISTER here ► https://bit.ly/AUGSQL to our virtual chapter!
✓ Join our online Access User Groups with free membership. Monthly webinars on the latest topics: MS Access, MS Access with SQL Server, etc.
► Facebook ◄
/ accessusergroups
/ msaccesslatinoamerica
/ accessespana
/ augpowerapps
/ auglunchtime
/ augeasterntime
/ accesswithsqlserver
► Twitter ◄
/ accessusergroup
/ augespana
/ msaccesslatino