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 8 years, 3 months ago by Andrew Jackson.

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

Author

Posts
January 20, 2016 at 4:28 am #1052 Score: 0

Lincoln Burrows
Moderator

Karma: 16 pts

Is there any method or way to determine the free space in SQL Server Database ?

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 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.