Debunking The Myths About Shrinking Databases: What Every DBA Should Know

Опубликовано: 19 Октябрь 2024
на канале: sqlfeatures
68
like

#DatabaseManagement #ShrinkingMyths #DBAInsights #ShrinkingDatabase

Dive into the truth about database shrinking in this eye-opening video. We're debunking common myths and exploring smarter ways to manage database space. Perfect for DBAs and IT professionals who want to optimize their database performance with informed decisions.

Github: https://github.com/hedaprakash

Blog: https://www.sqlfeatures.com/


Introduction: (0:00)
Meet Our Experts : (0:51)
Real-World Scenario - Reindexing Job (1:17)
Real-World Scenario - Archive Job (2:11)
Real-World Scenario - Performance Issue (3:24)
Real-World Scenario - Large Transaction (5:14)
Real-World Scenario - Quarter End Activity (6:54)
Real-World Scenario - Planned Archives (8:24)
Scenario explanation and answers - (9:57)
Reflection - Reindexing Job (10:28)
Reflection - Archive Job (11:24)
Reflection - Performance Issue (12:20)
Reflection - Large Transaction (13:32)
Reflection - Quarter End Activity (15:16)
Reflection - Planned Archives (16:32)
Understanding the Implications of Shrinking Databases - (17:42)
Concluding Thoughts and Future Strategies - (18:13)
Outro and Invitation for Feedback - (18:48)