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.

[@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!

[@BrentOzarUnlimited]

Glad you like them!

[@IsmailShaikh-hw9ro]

Saving your playlist.. ❤️

[@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 ?

[@BrentOzarUnlimited]

Yep!

[@antoniamesesan9711]

great content!!!

[@BrentOzarUnlimited]

Thanks!

[@malcomreynolds4103]

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?

[@radaefilms3150]

Thank you sir

[@yashoswal5215]

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

[@BrentOzarUnlimited]

I don't have a video I can point you to at this time, no.

[@Kudrat560]

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

[@BrentOzarUnlimited]

Yes, watch the video. ;-)

[@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

[@BrentOzarUnlimited]

Sure, check out my Mastering Server Tuning workshop.