OS + SQL Server binaries on same drive?

  • When installing SQL server to the same drive as your OS, be very diligent in making sure that EVERY file that SQL server can cause to grow is moved off the system drive onto a drive other than the system.  We recently had an issue where SQL Server / SSIS was installed to the system drive.  We have a sizeable SSIS ETL that runs on this machine.  The ETL process filed up the SSISDB data files (default System drive install) and crashed the machine.  Had we been able to get to a command prompt, we could've resuscitated SQL server in under an hour. As it stood, it took much longer to get the machine back.  

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply