SQL SERVER - Database file size and Log file size

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

sp_helpdb 'master'

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

Remember

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

Related Posts: