Yes, you can tune your SQL Server backups!
Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of Continue reading “Sean’s Famous Backup Tuning class!”
Category: Optimization
Server Properties
Have you ever wanted to be able to view instance-level stats or change certain values without having to use the GUI? Here I’ll show Continue reading “Server Properties”
Fix AutoShrink in Powershell
Here I show you how to turn off AutoShrink on a DB and then how to make sure it’s turned off on all your DBs.
Waits and Queues
Thomas LaRock from Confio came to give us this really good talk on waits and queues. And as an added bonus, the entire PASS Continue reading “Waits and Queues”
Find query timeouts in Profiler
I like this video. This is a simple example of how you can track down queries that are timing out. Be careful though. Continue reading “Find query timeouts in Profiler”
Database Performance
Paul and Kim Tripp from SQLSkills.com came to teach us their award-winning presentation on DB performance.
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. Here, we walk through developing a Continue reading “Correlate Lock Timeouts with Statements”
Beginning Execution Plans
Here’s a level zero introduction to tuning queries. I go over execution plans, sp_help, and clustered primary key indexes.
Setup Server-Side Trace
server side traces, the benefits, and how to set up, edit, run, and stop a server side trace.
Compression Basics
I’m going over the basics of how to implement data compression here. I’m not really touching on where and why you’d want to do Continue reading “Compression Basics”
Windows Performance Monitoring: Part 1
This is a nice video that discusses the basics of performance monitoring in windows. This is actually a live class that I taught to Continue reading “Windows Performance Monitoring: Part 1”
Windows Performance Monitoring: Part 2
This is the continuation of the live presentation I did a couple weeks ago. This one covers disk counters, memory architecture, and counters.
Moving DB Files
Moving database files is easy, but misunderstood. Here I’ll show you how to move user DB files using 2 methods.
Interpreting Disk Queues
Disk queues are a mystery for the majority of DBAs. They may know that they need to look at them, but they have no Continue reading “Interpreting Disk Queues”
Hack-attak a damaged DB
What do you do if you have a set of data and log files you can’t attach because the log is damaged? Here I show Continue reading “Hack-attak a damaged DB”