Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Server Performance Tuning
First Section
Basics:- Query plan, Logical operators and Logical reads. (11:47)
Point 1:- Unique keys improve table scan performance. (5:12)
Point 2:- Choose Table scan for small & Seek scan for large records. (8:57)
Point 3:- Use Covering index to reduce RID (Row Identifier) lookup. (8:54)
Point 4:- Keep index size as small as possible. (7:00)
Point 5:- Use numeric as compared to text data type. (2:42)
Point 6:- Use indexed view for aggregated SQL Queries. (10:12)
Point 7:- Database Engine tuning advisor is your best friend. (13:06)
Part 1 - Profiler, Tuning advisor, Clustered/Non-clustered indexes,DBCC command & Reading SQL Plan, OLTP & OLAP. (71:24)
Part 2 - Estimated vs Actual plan/rows, SQL Plan revised, Table/Index scan, Indexes seek, Physical/Logical opertn, Execution mode, columnstore, Rebinds, Rewinds, Nested loop, Hash/Merge join. (61:58)
Part 3 - Interleaved Execution, Fragmentation, Performance counters, Page splits and Unused Indexes. (52:30)
Part 4 - Extended events, RID lookup and Covering indexes. (57:58)
Part 5 - Indexed views, Page splits & unused indexes, Dead locks, Query store Parameter sniffing Statistics. (53:24)
Part 6 - Inline vs Stored procedure SQL, Cache miss, Cache hit, Parameter sniffing and Query store. (52:26)
Part 7 - Partitioning, Wait stats, Resource Governor and Inmemory Tables. (53:00)
Point 5:- Use numeric as compared to text data type.
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock