Engine
Review (True/False)
(answers
at bottom)
- In
Yukon there is one scheduler per instance
- All
system objects are owned by sys schema
- Metadata
Service is NOT a new component in Yukon
- System
tables are now replaced by catalog Views in Yukon
- SQL
Server service cannot be started with out resource database
- System
data for all user databases is materialized in master database where as
metadata for system objects resides in resource database.
- On
a server with 8 HT processors SQL Server will create 352 threads on startup.
- Optimizer
looks at the ‘worker’ queue to determine how busy is the scheduler.
- Measuring
PLE is irrelevant in Yukon
- Processor
bound queries will always be faster on 64-bit in Yukon
- Under
NUMA configuration if SQL Server runs out of memory on the node then SQL
Server will return ‘out of memory’ error
- Optimizer
does not consider HT when deciding DOP
- Yukon
does statement level recompile for all batches
- Async
auto update stats is OFF by default
Answer
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