Posts Tagged ‘sqlbits’

Using Perfmon and Profiler

Tuesday, February 9th, 2010

At the SQLBits conference in Great Britain last fall, Brent Ozar gave a presentation called “Using Perfmon and Profiler.”  He covered:

  • Why Windows Task Manager is nothing more than a check-engine light
  • His performance tuning lifecycle
  • Why you need to capture baselines (and how to do it)
  • Several sample tuning scenarios

You can watch this 52-minute presentation free courtesy of SQLBits:

Get the Flash Player to see the wordTube Media Player.

If you liked this presentation, you can watch any of the SQLBits presentations at their web site, including:

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Tags:
Posted in Podcasts, SQL Server Performance Tuning | Comments Off

SQL Server Performance Tuning, Formula 1 Style

Tuesday, February 2nd, 2010

At the SQLBits conference in Great Britain last fall, Brent Ozar gave a presentation called “T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig.”  He covered:

  • 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

You can watch this 41-minute presentation free courtesy of SQLBits:

Get the Flash Player to see the wordTube Media Player.

If you liked this presentation, you can watch any of the SQLBits presentations at their web site, including:

Subscribing or Downloading the Podcast

If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:

You can also download this video to watch it later:

Tags:
Posted in Podcasts, SQL Server Performance Tuning | Comments Off