In order to save licensing costs I'm evaluating whether I can get away with Standard Edition for a VLDB. I'll outline the scenario:
- Here, "VLDB" means 5TB.
- The size is expected to be stable over time.
- Almost all data would be in a single table.
- The query and DML pattern is a key-value type of scenario. There are only single-row accesses by primary key.
I wonder what I would need Enterprise Edition for. I would not derive any benefits from partitioning because I don't want to switch partitions or place them on different storage. Data compression could save us maybe 50% but we use cheap storage. The saving would be insignificant compared to the expensive license.
For HA I don't see why I couldn't go with the deprecated but still working Mirroring. That's not ideal but Enterprise Edition is a high price to pay for unclear benefit.
Still, it makes me nervous to use Standard Edition here because it is not what's generally recommended and it seems vaguely risky. Looking for some advice on this situation. Thanks!