To Be Embedded or Not To Be???
I'm upgrading the current SEP 11 to SEP 12.1.2 supporting about 1500 clients. The SEPM will be built on a VM with Win2008 R2 as the OS. Now I know by reading that the embedded DB can support up to 5000 clients, but I'm not feeling comfortable suggesting the embedded. Reason 1, I installed SEPM w/ embedded DBin my test environment, and I'm having a bit of a struggle accessing the DB through the SQL Client Tools I installed. Reason 2... The current SEPM DB is embedded on the SAME VM (don't know which genius thought of that). If that VM gets corrupted, the whole SEPM is crashed.
So if I make the recommendation to a separate SQL Server, the impact of the DB should be minimal and much more secure.
Suggestions? Recommendations? Solution. Thanks!!!