If application works with a database, query execution time should be taken into consideration.
But I decided to share my own experience in the field with the focus on SQL Server query optimization tips.
Depending on a specific case, this task can have varying starting conditions:
You already know what query runs slowly;
You only know that your entire system has generally poor performance that requires some tuning.
You can run SQL Server Profiler from SQL Server Management Studio: go to Tools > SQL Server Profiler
SQL execution tuning is an unending battle.
Find Slow Queries With SQL DMVs
One of the enormous features of SQL Server is most of the dynamic organization sees (DMVs) that are fused with it.
SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
Right when - 1 THEN DATALENGTH(qt.TEXT)
Demand BY qs.total_logical_reads DESC - real examines