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
- Ola Hallengren’s Maintenance Scripts
- Indexing for Deletes
- Unique Indexes and the Index DMVs
Enjoyed this video? Check out our upcoming webcasts.
Brent Ozar
Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.
Follow Me:
Some eye opening stuff in there, great video!
Do you have the poll results so that I can compare against the rest of the community.
Thanks
Thanks for the video. Took some notes and added a few scripts to my library.
Would of been great if the poll votes were included in the video.
Hi Brent,
Where would you recommend to put the SP’s for Ola.Hallengreens indexOptimise scripts as the default is master. I’m pretty sure in a blitzscript by yourself before you recmommended not to put SP in master database’s. Would msdb be the perfect place?
Cathal – I’m fine with utility stored procs in master. My sp_blitz goes there too.
Great! so much to check, right now I’m deploying and testing the maintenance solution you recommended… thanks!