We had an error regarding tempdb. Looks like there is enough space, but when I checked there are 9 data files in the primary file group. Primary datafile is 512 MB and has no autogrowth, while the others have same initial size, but have autogrowth by 128 MB and restricted growth to 2 GB each. The log file is restricted to 10 GB growth. Please let me know suggestions on what can be done.
Error message below
tempdb Could not allocate space for object 'dbo.SORT temporary run storage: xxxxx' in database 'tempdb' because the 'PRIMARY' 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 filegroup.