The Basics of SQL Server Profiler
by Brent Ozar
SQL Server’s Profiler utility helps you trace slow queries to find performance bottlenecks. In this ten minute video, Brent explains the basics of how to get started tracing your server with Profiler.
The scripts and related links for this podcast are:
- SQL Server Profiler – the wiki article here about how to use Profiler.
- Writing a Performance Report – how to use Profiler and Perfmon to write a management report for SQL Server.
- Index Performance Tuning Scripts – sample scripts that show you how to find missing indexes, indexes that aren’t being used, and more.
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:
- MP4 (Apple) Video Feed
- WMV (Microsoft) Video Feed
- MP3 Audio-Only Feed
- Zune One-Click Subscribe for Video
- Zune One-Click Subscribe for MP3
You can also download this video to watch it later:
Share this post with friends
