Рет қаралды 3,737
By watching this you will be able to answer the below
1) Why do we need to turn on Trace flag 1117 & 1118?
2) Do we need to enable 1117 & 1118 even on the latest Versions?
3)What are the different types of contentions inside Tempdb?
4) What is PFS/GAM/SGAM contention?
5) What is Metadata contention?
6) From which Versions of SQL can we avoid SGAM contention(not completely though)?
7)From which Versions of SQL can we avoid PFS contention(not completely though)?
8)From which Versions of SQL can we avoid GAM contention(not completely though)?
9) What are the differences between Object Allocation contention & Metadata contention?
10) Can we overcome Metadata contention if So how?
11) What are the algorithmic changes that were made on the recent versions of SQL Server?