Currently viewing the tag: "tuning"
This is an excellent example of how you need to be flexible with your processes, even when you’re in the middle of a project.
We started a project to move a DB to a new set of disks. Since the [...]
This is going to be a short post, but an important one to demonstrate the importance of thinking about what you’re doing. I recently taught a backup tuning session at SQLSaturday 90 in OKC. You can see the session [...]
I had a nice production problem today that slowed everything down drastically. I’ll spare you the details of the user processes, but when looking in sys.sysprocesses, I noticed that the waitresource was ’2:%’. I also correlated this with the wait_type column [...]
Most of you know that you can set SQL to auto update stats. And I’m sure that most of you know that it invalidates stats at about 20%. What that means is that when about 20% of the data in the [...]
From time to time you run across something that demonstrates perfectly exactly what the industry needs. As I sit here at the PASS day-3 keynote I’m watching Dr. DeWitt talk about how the query optimizer finds query plans. This is a [...]
In my SQL Marklar blog today I discussed troubleshooting DB processes. And I’m not going to re-hash all of it here but I did want to tell you about a use case that describes perfectly what I was talking [...]
I just heard from a DBA at my last gig who was keeping me in the loop about things I had done while I was there.
He said that they had to take away the 2 1TB LUNs I had [...]
Hey everybody… it’s been a while since I’ve blogged, but that’s what starting a new gig will do to you. I’ve had so many new things to rant about here and I’m sure I’ll be getting to those in the future, [...]
While talking to a group of devs late last week the topic of deleting prod data came up. Since I’m the big MVP of the group they wanted to know what the official word from on-high is. The question is simple, [...]
A couple pieces of code came across my desk yesterday and they’re definitely the kind of thing you read about… if nowhere else, then here for sure. This was code that a dev sent me that is to be deployed next [...]
The best database career advice you’ve never heard!
Become a DBA. Become a BETTER DBA. Use the Roadmap.
The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!
Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)
Visit www.DBARoadmap.com for info, forums, and more!
SQL Cruise with me…
We'll be on the January 2013 cruise to the Bahamas, teaching and learning SQL and having a GRAND time after hours...all for the less money than a week of "normal" SQL training. Join us!
ITBookworm.com!- Reading: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan
- Repost: “Problems with my new book” by Grant Fritchey
- Announcing SQL Server 2012 Query Performance Tuning by Grant Fritchey
- Quick Review: Logitech Trackball
- Book Review: Microsoft SQL Server 2008 Internals, by Kalen DeLaney et al
