Every software product has its gotchas. SQL Server has some settings which sound like a great idea but can cause major problems for performance and availability when used improperly. In this 30 minute video, Kendra Little takes you on a tour of SQL Server’s most dangerous settings, from priority boost to lightweight pooling. She’ll explain why you need to be cautious and how you can check if your SQL Servers are configured safely.
Looking for the links discussed in the video? Scroll on down the page…
Hungry to Learn Even More?
Dig into these links from the video.
Read the fine print on Priority Boost in Books Online here.
CPU Affinity Mask and I/O Affinity Mask
Check out Bob Dorr’s explanation of the problems with using CPU and I/O Affinity Masking here.
LightWeight Pooling, aka Fiber Mode
Read “The Perils of Fiber Mode” by Ken Henderson here.
For more videos like this: