July 9, 2010 at 9:04 pm
I need help understanding why the data space of my big table BTABLE as reported by its Storage Property differs very significantly from
the sum of its 6 datafiles on two SAN disks. The table is in its own filegroup, has 6 datafiles.
BTABLE:
Storage Property [Data Space]: 143 GB
Sum of 6 ndf datafiles for this table : 213 GB [files autogrowth : 1GB]
Index Space: 0.5 MB [ I just loaded data from Oracle, no idx created yet]
the table does not have full-text index created.
Thanks,
Sergei Z
July 9, 2010 at 9:34 pm
Where are you getting the 143GB number from? Have you included the free space that exists in each of the 6 files?
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
Ramblings of a DBA (My SQL Server Blog)[/url]
Subscribe to my blog
July 9, 2010 at 10:01 pm
Tara Kizer (7/9/2010)
Where are you getting the 143GB number from? Have you included the free space that exists in each of the 6 files?
Thank you for your response. I'm getting 143 GB from the table's Properties>Data Space.
Autogrowth set up for all 6 datafiles is 1GB, so I assumed that free space in the 6 data files cannot be larger than 6 GB. In fact , for the whole database [which now has only one table BTABLE] the free space , from DB's properties, = 4 GB.
Still cannot get why the difference between the size reported by the table properties and the files' combined size is 70 GB.
Sergei Z
July 10, 2010 at 1:20 am
Edit: VOID
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply