This post provides basic advice for SQL performance tuning, including enabling and viewing time statistics, interpreting query execution plans, staying updated on new features, and using tools like sp_whoisactive, Extended Events, and Query Store.
Table of contents
IntroductionMeasure the Query StatisticsLearn to Interpret Query Execution PlansFollow up on the Novelties of the SQL Server Query TuningLearn the Usage Details of the sp_whoisactiveLearn to Usage Details of the Extended EventsLearn to Usage Details of the Query StoreSummarySee moreSort: