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
Find Slow Queries With SQL DMVs
One of the immense highlights of SQL Server is the majority of the dynamic administration sees (DMVs) that are incorporated with it.
By taking a gander at this, I can duplicate that SQL inquiry and check whether there is some approach to enhance it, include a file, and so on.
Follow can disclose to you how often a question has been executed, to what extent it goes up against normal, and what exchanges are calling it.
APM arrangements gather this information by doing lightweight execution profiling against your application code at runtime.
You can look for particular inquiries to chase down potential issues.
