Sunday, June 28, 2020

SQL Server Performance Tuning and Query Optimization guidelines

  • SET STATISTICS IO
  • SET STATISTICS TIME 
  • Parser                                                                                                                 
  • Biding
  • Execution Plan Generation
  • OPtimization
  • Components of the Execution Plan 
  • Ageing of the Execution Plan 
  • Analysing the Execution Plan Cache 
  • Execution Plan Reuse 
  • AdHoc Workload 
  • Optimize for an AdHoc Workload 
  • Froced Parmeterization 
  • Benefites of Stored Procedures 
  • sp_executesql 
  • Parameter Sniffing 
  • Query Plan Hash and Query Hash
  • Execution Plan Cache Recommendations
  • Actual Vs. Estimated Execution Plans 

If there is any other better option,
Please share it here or mail to me arkaa4@gmail.com

Thank You,
Arka Gupta.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)