From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Identify available space on data volumes - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Identify available space on data volumes
- [Instructor] Sometimes database files can grow in size pretty dramatically. Knowing how much room is available on your hard drives is often an overlooked, but important resource management task that should be reviewed regularly. It's a good thing that sequel server has a few tools that will make reviewing this information easy and fast. The first one I want to do is take a look at SYS.master_files. This will give us some general information about all the files used on every database in our instance. Of particular interest right now, we have the database ID column and the file ID, the name of the file as well as its file path on disc in the physical name column, and if I scroll over to the right we'll find a column for size. Now this size is being reported in eight kilobyte pages, which is not a typical way that you would see size represented, so don't let that number throw you. We can filter this view down to just the columns of interest by selecting just the name, database ID, file…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.