Sql server database file space used

Privacy policy. Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.

Is the qualified or nonqualified name of the table, indexed view, or queue for which space usage information is requested. Quotation marks are required only if a qualified object name is specified. If a fully qualified object name including a database name is provided, the database name must be the name of the current database. If objname is not specified, results are returned for the whole database. When objname is not specified, the statement is run on the whole database; otherwise, the statement is run on objname.

Values can be true or false. For a stretched table or database, the mode parameter lets you include or exclude the remote portion of the object.

For more info, see Stretch Database. The oneresultset argument can have the following values:. The default value is 0, that is, by default if the parameter is omitted the XTP columns are not included in the resultset. If objname is omitted and the value of oneresultset is 0, the following result sets are returned to provide current database size information. If objname is omitted and the value of oneresultset is 1, the following single result set is returned to provide current database size information.

This can happen for several reasons, mostly around data skew, including:. In addition, any partition could have individual files that are different sizes or have a different percentage full , due to issues highlighted in the first two examples. We can see where the existing query can help, and where it can fall short.

First, we can create the filegroups where our partitions will be distributed:. And then an additional file to create some artificial skew in the Part4 filegroup:. Now if we run the query "get filegroup files" again with the relevant filegroups we show these results:.

In the meantime, read on for related tips and other resources:. Related Articles. The units are returned as divisors to convert the values to GB. Then the converted values are used to compute the day-over-day difference, which are the growth factors I need. The space available divided by the daily growth rate will tell me how many days until the database next tries to autogrow:.

The free space on the file system divided by the autogrow amount tells me how many more times the database can grow automatically:. Since the database can continues growing until the last expansion is completely filled. Now I need to make sure that that SAN order is moving along to meet that time!

This article showed some DMVs that can help, along with a little math! FROM sys. CASE df. ELSE 'Other'. WHEN 0. THEN 'File is fixed size and will not grow. Improve this question. BradC BradC 9, 7 7 gold badges 43 43 silver badges 79 79 bronze badges. Add a comment. Active Oldest Votes. TYPE desc, A. Improve this answer. Oreo 1, 7 7 silver badges 20 20 bronze badges. Bruce Bruce 6 6 silver badges 8 8 bronze badges.

I suggest instead of the edits and additions to the SQL I provided those with other versions post their own answers.