How Can I Check Free Space in My SQL Server Database?

Lincoln Burrows ~ Modified: January 20th, 2016 ~ ~ 1 Minute Reading

This topic has 2 replies, 3 voices, and was last updated 9 years, 2 months ago by Andrew Jackson.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
January 22, 2016 at 12:25 pm #1057 Score: 0
Stephen West
Moderator

Karma: 4 pts
you can try DBCC SQLPERF to determine the free space of your SQL Database.
```
USE master 
GO 
DBCC SQLPERF(logspace)
```
January 29, 2016 at 12:23 pm #1067 Score: 0
Andrew Jackson
Moderator

Karma: 1 pt
You can also use FILEPROPERTY to check for free space in a SQL Server database
```
USE AdventureWorks 
GO 

SELECT DB_NAME() AS DbName, 
name AS FileName, 
size/128.0 AS CurrentSizeMB,  
size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB 
FROM sys.database_files;
```
This will show how much space is used by SQL Server database and then you can calculate free space
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.