At MIS2007 we had a database RAID discussion: RAID 5 or RAID 10 for databases from 5 GB to 5 TB. Almost everyone picked RAID 10, even though it costs more.
SQL SERVER – FIX : ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup
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.
TempDB is full and you see Event ID 17052 for the tempdb log? Here is what to check first and how to move TempDB from one drive to another.