In small, simple environments the embedded databse is fine and adequate.
In busy environments with many thousands of clients, I recommend placing the SEPM database on a seperate server so that all of the storage, RAM, CPU, IO, etc of the SEPM can be devoted to service updates, policies, logs etc to its clients. Database tasks can be offloaded and handled by a dedicated, high-powered SQL server.