SQL Server Performance: Evaluation of Various Features (Linchi Shea)

Before you use a new feature with SQL Server, you naturally would wonder about its performance implications. Will it improve or degrade performance, and by how much? You can search on the web for answers, or you can come to this session where we'll discuss a variety of test results that may help you handle such features as hyperthreading, hardware NUMA, disk fragmentation, log file fragmentation, parallelism, SQL audit/trace, snapshot isolation levels, SQLCLR Try/Catch blocks, and many more.