Sir V Lance
Getting the hang of it
Especially since it is known how fragile the DB is in BI, adding complexity to your layout increases the risk of DB corruption.
Thanks wittaj.
As I mentioned to Mike A. - I am a little confused about what the BI database is. It seems like it is recommended to have it live on the C:\ drive with BI, yet you are saying it is fragile and can be corrupted. How likely is this? If/when it becomes corrupted, what is the recovery process? Does it mess up the C:\ drive bad enough to require a refresh of Windows, or just a reinstall of BI? It seems like the primary goal is to preserve the OS boot drive integrity and consider the secondary storage drive somewhat "expendable" since that's where all the heavy writing occurs. Although I'm sure losing that drive and all the stored video is not going to be a day of puppy dogs and roses either. Does the database see a lot of write cycles too, and should I be concerned using a NVMe SSD for the OS and BI drive? Seems like there is less concern now about having the Windows page file live on a SSD than there was in the past - perhaps because of the recent reliability increase in the technologies.