Times are tough even for the best drivers: Helio Castroneves is dancing for money and Danica Patrick is doing ads for what appears to be an adult services company. Maybe it’s time to switch careers, and Brent has just the thing. Use your hard-earned knowledge of high speeds, million-dollar hardware and surviving disastrous crashes to become a SQL Server performance tuner!
In this one-hour video recorded at the SQLBits 2009 conference, Brent will show you:
- Why Colin Chapman would check for indexes before adding new ones
- The importance of well-tested safety gear to performance tuning
- Why not monitoring your servers is like overdriving your headlights
- Just like races are lost in the pits, uptime records are lost during maintenance windows
Great talk, thanks. The racing analogy was apt.
Missed the explanation about why we need to get away from SSMS/Excel. Maybe I didn’t understand that slide?
Nice point about passive server licensing.
[...] approach for finding performance problems. You can find videos of his SQL Performance speech at http://www.brentozar.com/sql-server-training-videos/t-sql-performance-tuning-for-race-car-drivers/ . He is also an MVP and recently got his Microsoft Certified Master(MCM) Certification which is [...]
Hello, I tried running the query “indexs_not_in_use” you have listed on your site. It completes successfully but does not return any rows. I know for sure that I have many indexes in my database. Any suggestions on what I am doing wrong?
Joel – sorry, no, I’m not sure what you’re doing wrong.
Your comment about more virtual cores working against you because the hyper-visor has to wait for each one to become available before scheduling threads, does this still stand for the latest versions of the VM Ware / Hyper V hyper visors ?
Coscheduling penalties have been reduced a lot in vSphere 4.1/5, but that doesn’t mean it’s still okay to allocate lots of vCPUs. I explain why in my 4-hour VMware training sessions. For Hyper-V, it’s still a little murky – we haven’t gotten the new Windows 8 hypervisor yet, so we can’t tell.