- Blog - http://blog.bennett-scharf.com -

Getting data file space usage

Posted By admin On 2. February 2009 @ 15:17 In T-SQL, SQL Server | No Comments

Here is a simple query to get space usage by data file:

 SELECT 
   a.FILEID, 
   [FILE_SIZE_MB] = CONVERT(decimal(12,2),ROUND(a.size/128.000,2)), 
   [SPACE_USED_MB] = CONVERT(decimal(12,2),ROUND(FILEPROPERTY(a.name,'SpaceUsed')/128.000,2)), 
   [FREE_SPACE_MB] = CONVERT(decimal(12,2),ROUND((a.size-FILEPROPERTY(a.name,'SpaceUsed'))/128.000,2)) , 
   NAME = LEFT(a.NAME,24), 
   FILENAME = LEFT(a.FILENAME,55) 
   FROM dbo.sysfiles a 

Article printed from Blog: http://blog.bennett-scharf.com

URL to article: http://blog.bennett-scharf.com/2009/02/02/getting-data-file-space-usage/

Click here to print.