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...

• #science_technology
• #sql_server
• #access
• #odbc
• #orm
• #entity_framework
• #nhibernate
• #profiler
• #prepared_statement
• #sql
• #statement
• #performance
• #sql_statement