SQL SERVER - Database file size and Log file size

Why is the data execution so slow? Many ask this question when they discover that the online data execution is very slow, irrespective of a good internet speed. The answer to this question sometimes lies in the size of the database and its log file in particular.

The below query will show a brief detail about a database.

sp_helpdb 'master'

How to find Database File Size and Log File Size in SQL Server

The size of the log file sometimes, determines the performance of a database and if you have been allocated limited space for hosting a database driven website, then you must be very careful while managing your database.

Also Read: How to show Date and Time as Blank instead of 1900-01-01 in SQL Server


Log files consume lot of space when you perform bulk inserts, updates or deletes. Depending upon the size of your SQL command, the log file will consume space allocated to you. Therefore, it’s good if you can avoid using bulk updates on your database.

There is another script with which you can check the database properties. Run the below script on the local database.

SELECT database_id, DB_NAME(database_id) DatabaseName, 
    Name AS FileName, 
	physical_name AS FilePath, 
	(size*8)/1024.0 AS [FileSize (MB)]
FROM sys.master_files
WHERE DB_NAME(database_id) = 'master'

Note: Your service provider may not give you the permission to view the sys.master_files.

A Final Word

Before submitting and hosting a database driven website, plan your database properly to make sure it does not trouble you in the future.

Next - Learn about various Joins in SQL Server

Like this Article? Subscribe now, and get all the latest articles and tips, right in your inbox.

Enter your email id

Delivered by FeedBurner

Related Posts: