Introduction
- PRE REQUISTES TO SQL SERVER PERFORMANCE TUNING PART 2
- DOWNLOADING THE APPLICATIONS
- CREATING VM AND INSTALLING WINDOWS 2016 OS
- INSTALLING SQL 2017
- INSTALLING SQL 2017 PART 2
- SQL SERVER VERSION COMPARISON
- PERFMOM
- PERFORMANCE COUNTERS
- SAVING PERMON COUNTERS
- DATA COLLECTION SET
- DATA COLLECTION SET PART 2
- ADDING ADVENTUREWORKS 2017
- ANALYSIS OF METRICS
- BASELINE CPU
- SQL PROFILER
- LIMIT PROFILER DATA
- PERFMON AND PROFILER
- EXTENDED EVENTS PART 1
- EXTENDED EVENTS PART 2
- EXTENDED EVENTS SESSION SCRIPT
- FIND LONGEST RUNNING QUERY
- DMVS
- SETTING UP QUERY STORE
- QUERY STORE
- QUERY STORE PART 2
- FORCED PLAN
- FORCED PLAN PART 2
- INDEXING AND FRAGMETATION
- SQL AGENT JOB FOR INDEX AND OLA
- SQL AGENT JOB FOR INDEX AND OLA PART 2
- DTA INDEXING AND QUERY STORE
- SOLVING RECOMPILATION
- SOLVING COMPILATION PART 2
- RESOVLING PAGE SPLITS PART 1
- RESOVLING PAGE SPLITS PART 2
- VIEWING PAGE SPLITS VIA EXTENDED EVENTS
- RESOLVING BLOCKING ISSUES
- TEMPDB PERFORMANCE
- TEMPDB PERFORMANCE PART 2
- DATABASE BACKUPS
- WAIT STATS
