Optimization

Optimization

Server Properties

Have you ever wanted to be able to view instance-level stats or change certain values without having to use...

Watch video

Fix AutoShrink in Powershell

Here I show you how to turn off AutoShrink on a DB and then how to make sure it’s...

Watch video

Waits and Queues

Thomas LaRock from Confio came to give us this really good talk on waits and queues. And as an...

Watch video

Find query timeouts in Profiler

I like this video. This is a simple example of how you can track down queries that are timing...

Watch video

Database Performance

Paul and Kim Tripp from SQLSkills.com came to teach us their award-winning presentation on DB performance.

Watch video

Correlate Lock Timeouts with Statements

I’ve been getting lock timeouts on one of my systems, so I captured the timeouts in a profiler trace....

Watch video

Beginning Execution Plans

Here’s a level zero introduction to tuning queries. I go over execution plans, sp_help, and clustered primary key indexes.

Watch video

Setup Server-Side Trace

server side traces, the benefits, and how to set up, edit, run, and stop a server side trace.

Watch video

Compression Basics

I’m going over the basics of how to implement data compression here. I’m not really touching on where and...

Watch video

Windows Performance Monitoring: Part 2

This is the continuation of the live presentation I did a couple weeks ago. This one covers disk counters,...

Watch video