Search


	Podcast:		voiceofthedba's podcast
	Episode:		Reserved Space
	Category:		Technology
	Duration:		00:07:21
	Publish Date:		2019-01-29 20:00:00
	Description:		Many of us that work with SQL Server are familiar with the idea of reserving space that our system might need later. This is normal operation in SQL Server, where we pre-allocate space to data and log files, knowing that SQL Server will manage and use this space over time. This can often be a strange concept for newcomers to the platform, who expect our database behaves like a text file, only using the space it needs for data. Choosing the amount of space to reserve is an art that many of us both struggle to articulate and explain to newcomers. It's also a problem that we often solve by guessing high and implementing monitoring. Lots of people worry about storage, even in this era of TB sized drives. I ran across an article noting that Windows is reserving 7GB of space for updates, which makes sense to me. I've had a few updates for smaller devices, like mobiles, fail because of space. I think the idea of having some space reserved for temp storage and then using that for updates is a good one. I also recognize that I'm in a different place than others. Most of my devices have plenty of free space. Well, not my phone, but that's a separate issue. Read the rest of Reserved Space
	Total Play:		0