Great explanation! I accidentally shrunk the log file on one of my Production servers as I was trying to shrink it on my sandbox server actually and didn't realize I was connected to the wrong server. Oops. I've only had to shrink that Production server's log file once when someone decided to do a massive delete + insert instead of just updating the data which blew up the log file size to WAY bigger than normal and WAY bigger than the data file. Tripled the size of the backups too.
@totanlj18
Жыл бұрын
Thanks God you do only a Shrink on that server!
@user-xp5sk8ts3q
2 жыл бұрын
Thanks for the interesting story about the architecture of hard drives.
@kennethgardzinski
2 жыл бұрын
Good information as usual. Thank you 😊.
@clasmir5281
3 жыл бұрын
Great content! Almost done with this bag of popcorn!
@samdani870
3 жыл бұрын
Much clear on shrink. Can you make a video of lock, block, and deadlock with a bunch of real examples please.
@BrentOzarUnlimited
3 жыл бұрын
Sure, I have - check out my Mastering Index Tuning and Mastering Query Tuning classes where we spend about 3 hours in total on blocking and deadlocking. To learn more, go to BrentOzar.com and click Training at the top.
@Vibestr
7 ай бұрын
Hello Brent Thank you for the explanation. It helped me understand why shrinking paired w/ rebuilding indexes is a fruitless cause. Is the shrinking that you describe an example of notruncate because i was reading a truncate shrink doesn't move any files over but simply drops ("deallocates") the space at the end (and henceforth it is much more faster process)? Would using a truncate shrink be good since it doesn't reshuffle the database and perhaps there would be no need to perform a defrag? Or is having that extra unused allocated space not such a bad thing since it can make future inserts easier?
@avanthasiriwardana
2 жыл бұрын
perfecto :)
@paulntumbong9568
Жыл бұрын
Good analysis sir, what script can you use to know what exactly is causing the log file growing big
@TheBrentOzar
Жыл бұрын
Thanks! I cover that in my How I Use the First Responder Kit class.
@lirusme2461
5 ай бұрын
How about tempdb datafile that continue growth because of verrion store? how to identification what transaction process and query that running?
Пікірлер: 13