Database Size Calculation in SQL Server


This is a sample calculation and dont provide the proof log file size calculation
use DatabaseName
GO
EXEC sp_spaceused
Reserved=Data + Index + Unused(All values in KB)
230540328=64265016+164723400+1551912

Reserved =230 GB
DatabaseSize=Reserverd + LogFileSize(Values in GB)
280=           230     +   50
----Free space calculation
1551,912/64,265,016 =  2%

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server