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!”
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!”
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”
Paul and Kim Tripp from SQLSkills.com came to teach us their award-winning presentation on DB performance.
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”
Here’s a level zero introduction to tuning queries. I go over execution plans, sp_help, and clustered primary key indexes.
server side traces, the benefits, and how to set up, edit, run, and stop a server side trace.
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”
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”
This is the continuation of the live presentation I did a couple weeks ago. This one covers disk counters, memory architecture, and counters.
Moving database files is easy, but misunderstood. Here I’ll show you how to move user DB files using 2 methods.
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”