First chance at a new job to do some much needed index maintenance on a system.
2-node cluster, W2K12R2, 512GB RAM, 64 logical cores, Fusion-IO, NetApp
SQL Server 2012 Ent SP1
4 filegroups spread across 91 files.
4 of the 91 files were added 3 days ago to the filegroup called C below.
The 4 new files all show ONLINE in state_desc of sys.master_files
Very heavy CRUD operations 24/7- no complaints or tickets from NOC.
sp_whoisactive does not show any blocking or anything out of the ordinary.
RDP into active node and server shows plenty of disk space is available.
No major entries in SQL log file except the error(s) below.
No entries in msdb.dbo.suspect_pages
Other defrag operations on other small tables has worked fine.
When trying to defragment a 14MB table using reorganize against the CI, I receive the following and can reproduce the problem:
Error: 1105, Severity: 17, State: 2
Could not allocate space for object 'A' in database 'B' because the 'C' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the file group.
Any ideas? Thanks! --Todd