We have a TFS installation on a machine that is close to going out of support life and we're planning on migrating to a new machine in a couple of months. However in the meantime we are getting really low on disk space and (for whatever reason) w开发者_如何学Ce can't add more disk space. This has me wondering if there is a tool that would show us how the DB is using the disk space which might help us identify some stuff we could delete/destroy to temporarily give us some more free space.
sp_helpdb 'database' will show your mdf and ldf file sizes. xp_fixeddrives will show free space. May not be exactly what you are seeking but it is a starting point.
精彩评论