Can SQL Server Profiler Be Used Anytime?

profilersql server

I want to run SQL Profiler for Long running queries in SQL server 2016. what is the best practice, without effecting the SQL performance in less time and more productive?

Best Answer

I highly recommend you use Extended Event instead of SQL Profiler trace. Extended Events can be more targeted (regarding what you collect) and less impact on server resource (Measuring “Observer Overhead” of SQL Trace vs. Extended Events). Few resources below which should give you a good start.

  1. SQL SERVER – Introduction to Extended Events – Finding Long Running Queries
  2. Finding One Problem Query With Extended Events
  3. Three Ways to Identify Long Running Queries - PASS
Related Question