SQLBits 2020
Performance Mythbusters
Fast-paced session where Paul debunks a slew of myths and misconceptions around SQL Server performance!
It's amazing how many myths and misconceptions have sprung up and persisted over the years about SQL Server. After 20 years helping people out on forums, newsgroups, and customer engagements, Paul's heard it all – especially related to performance. Are temporary tables always a good idea for performance? Does using SSDs mean no fragmentation issues and no performance problems? Will adding memory always improve server performance? These are just a few of many, many myths that Paul will debunk in this fast-paced session focused on what really helps SQL Server performance.
Speakers
Paul Randal's previous sessions
Introduction to Perf Troubleshooting Using Wait Statistics
Learn what wait statistics are and how to use them to identify performance bottlenecks.
Performance Mythbusters
Fast-paced session where Paul debunks a slew of myths and misconceptions around SQL Server performance!
Building a Better Backup Strategy
Learn how backup and restore work and how to put together an effective backup strategy.