Right after the DBA says “Uh oh,” they call in the consultants. You wouldn’t believe some of the stuff I’ve seen, but here’s the worst of it: some of these things are probably happening in your environment right now. If you’re a production DBA of any experience level, do yourself a favor and look for these common mistakes before they call in the consultants.
In this 30-minute video, we’ll discuss heaps, fill factor, maintenance plans, over-indexing, and the Database Tuning Advisor’s stupidity so you can learn what you’re doing wrong before your boss has to hear it from the outsider:
The links we discuss in the video:
- Finding Heaps with sp_BlitzIndex™
- Ola Hallengren’s Maintenance Scripts
- Indexing for Deletes
- Unique Indexes and the Index DMVs
Enjoyed this video? Check out our upcoming webcasts.