Home Forums SQL Server 2014 Development - SQL Server 2014 Best way to find how much of my partition filegroup contains data? RE: Best way to find how much of my partition filegroup contains data?

  • October 9, 2015 at 9:52 am

    #1832586

    This maybe?

    SELECT

    b.groupname AS 'File Group',

    Name,

    [Filename],

    CONVERT (Decimal(15,2),ROUND(a.Size/128.000,2))

    [Currently Allocated Space (MB)],

    CONVERT (Decimal(15,2),

    ROUND(FILEPROPERTY(a.Name,'SpaceUsed')/128.000,2))

    AS [Space Used (MB)],

    CONVERT (Decimal(15,2),

    ROUND((a.Size-FILEPROPERTY(a.Name,'SpaceUsed'))/128.000,2))

    AS [Available Space (MB)]

    FROM dbo.sysfiles a (NOLOCK)

    JOIN sysfilegroups b (NOLOCK) ON a.groupid = b.groupid

    ORDER BY b.groupname

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]