Why (still) use SQL Server Profiler?
Microsoft SQL Server Profiler is a tool to monitor and trace SQL statements sent to SQL Server. It is mostly superseded by Extended Events (XE), but there is still one use case where Profiler is my preferred choice: Quickly checking what actual SQL queries your data access abstraction layer generates. This includes ORM mapper such as NHibernate and Entity Framework (EF), but also Microsoft Access with ODBC linked SQL Server tables.
This topic is tightly linked to a text on ODBC linked table performance: https://codekabinett.com/rdumps.php?L...
On this page of the site you can watch the video online Why (still) use SQL Server Profiler? with a duration of hours minute second in good quality, which was uploaded by the user codekabinett.com/en 24 January 2021, share the link with friends and acquaintances, this video has already been watched 10,415 times on youtube and it was liked by 102 viewers. Enjoy your viewing!
