I'm working in SQL Server 2008 R2 and have created a query that gathers and sums the total of data files and log files' sizes. However, I can't find how much actual disk space a single block of SQL data takes up on the disk so I can convert it into something more meaningful.
Here is the script:
DECLARE @DataSize INT DECLARE @LogSize INT SELECT @DataSize = SUM(size) from sys.database_files where type_desc = 'Rows' SELECT @LogSize = SUM(size) from sys.database_files where type_desc = 'Log' PRINT @DataSize PRINT @LogSize
How large is one block of space? Would it be easy to convert those two integer variables into something more meaningful for a sysadmin?