Senior DBA Class - Index Maintenance for Enterprise Environments

You’ve learned over time that maintenance plans are the wrong way to go, and you’ve implemented index maintenance scripts from Ola Hallengren, the MidnightDBAs, or Michelle Ufford. However, you’re not really sure exactly what you’re fixing, or if it’s the least invasive way to improve performance. Learn the difference between internal and external fragmentation, see how fill factor destroys performance, and discover a simple set of parameters that can keep everybody happy.

[YvdB]

One skill that every IT-person should have: check how long ago an video was posted. 🙂

[Pugipas]

Thnx for sharing! I would just add that setting MAX DOP in the DBCC CHECKDB or index maintenance (OLA) command is necessary only if your server MAX DOP setting is not good enough (like sharepoint) because OLA script takes global MAX DOP settings if you didn't explicitly specify differently in the command.

[diegombt]

You have an awesome content! Muchas gracias Brent!

[jamiestrick]

I am moving over to SQLServer from the SYBASE world. In many cases we used non clustered indexes as our PK and clustered indexes to reduce contention for the last page. In current MS SQL is best practice to clustered on the PK ?

[malcomreynolds]

lol I just built some new SQL servers just after we added a few hundred TB of SSD allowing us to get rid of our spinners and I set up every log drive in its own volume not even thinking about it.

On index re-orgs - does SQL 2017 and 19 update statistics now?

[yashoswal]

Thanks Brent, any recommendations on running Ola Hallengren index maintenance scripts for VLDBs on daily basis

[oldcmputer]

Where can I read / understand more about your comment on things change and having data / log files on separate drives doesn't make much sense anymore. I'd like to dig into that rabbit hole more if you can link me that specific video - Thanks

[Kudrat]

Hi Brent, We see in our Database, tables are getting fragmented frequently.. any lead and direction for such behavior ?