2

During installation, is it ok to choose different Drives (say D and E) for Installation shared feature directory and Instance root directory or they should be on the same drive, or should any of them be on the OS drive (usually C)?

UPDATE: OR, what in fact is the best practice?

  • I suppose if it wasn't OK to do it then Microsoft wouldn't have provided those options in the installer. If you're asking what's best practice, that's a different question. – joeqwerty Aug 9 '17 at 21:27
  • @joeqwerty Good comment. I've added an UPDATE – nam Aug 9 '17 at 22:28
0

It depends on your server, how much disk space you have, how fast your disks are on the different drives, etc. Most people prefer to not have some features on the drive with the operating system and the pagefile. Back in the day, poorly behaved SQL databases would happily overwrite the operating system if they grew too large, as a colleague discovered back around SQL Server 7. I've been nervous about databases on the system drive ever since.

Anyway, I think this answer from dba.stackexchange.com might prove useful to you, but I don't think the world will end if you do or don't split the shared features and instance directories onto different drives. It depends a lot on your hardware, how you're using SQL Server, etc.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.