Product has been added to your cart.

T-SQL Performance Tuning for Race Car Drivers

T-SQL Performance Tuning for Race Car Drivers

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

http://www.vimeo.com/10728045

6 Comments.

  • Oliver Holloway
    March 11, 2010 11:28 am

    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.

  • Joel Saldana
    March 3, 2011 9:45 pm

    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?

  • Chris Adkin
    January 11, 2012 5:56 pm

    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 ?

    • Brent Ozar
      January 11, 2012 5:58 pm

      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.

  • Schuyler Bain
    October 5, 2012 9:05 am

    The web address for scripts mentioned on the video is re-routing me to the address below, and I don’t see the scripts there.

    Are they (index read/write ratio script) still available?

    https://www.brentozar.com/sql-server-training-videos/how-make-sql-queries-run-faster/

    Thanks!!