Error 1101, could not allocate a new page because of insufficient disk space in filegroup. Free up hard disk space and turn on AUTOGROW for the filegroups.
SQL SERVER – Raid Configuration – RAID 10
Which RAID do I use for my SQL Servers? RAID 10. It gives great read and write performance, while RAID 5 pays a write penalty for parity.
SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.
When TempDB is Full, I investigate capacity and usage before moving its files. A move requires a planned restart.