How to optimize the longest running SQL queries?

You can run SQL Server Profiler from SQL Server Management Studio: go to Tools > SQL Server Profiler Using Profiler, you can set filters to choose the longest running queries. For this, we need to perform the following steps: Create a new trace file and go to the Events Selection in a Trace Properties window.
For More Information Please Refer:

You May Also Like to Read: