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!”
Tag: Performance
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”