Yukon there is one scheduler per instance
system objects are owned by sys schema
Service is NOT a new component in Yukon
tables are now replaced by catalog Views in Yukon
Server service cannot be started with out resource database
data for all user databases is materialized in master database where as
metadata for system objects resides in resource database.
a server with 8 HT processors SQL Server will create 352 threads on startup.
looks at the ‘worker’ queue to determine how busy is the scheduler.
PLE is irrelevant in Yukon
bound queries will always be faster on 64-bit in Yukon
NUMA configuration if SQL Server runs out of memory on the node then SQL
Server will return ‘out of memory’ error
does not consider HT when deciding DOP
does statement level recompile for all batches
auto update stats is OFF by default
Key: 1.F, 2.T, 3.T, 4.F, 5T, 6.F, 7.T, 8.F,
9.F, 10.F, 11.F, 12.T, 13.T, 14.T