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