SQL server Profiler can be used any time? 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?
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.


SQL SERVER – Introduction to Extended Events – Finding Long Running Queries
Finding One Problem Query With Extended Events
Three Ways to Identify Long Running Queries - PASS