Endpoint Protection

I want to know can sepm with embeded database handle 2000 clients ?will the performance of sepm increase if we use sql database. currently we are using 1000 clients with embeded database.some times i find sepm consolea bit slow is it due to embeded database .
can I use oracle database instead of sql ?

 

I want to know can sepm with embeded database handle 2000 clients ?

---YES. It can handle upto 5000 clients. For more than a total of 5000 endpoints, it is recommended to use MS-SQL for the SEPM database

will the performance of sepm increase if we use sql database. currently we are using 1000 clients with embeded database.some times i find sepm consolea bit slow is it due to embeded database .
---as far as database is concerned i dont think changing fron Embedded to SQL will make much of a diffrence.

can I use oracle database instead of sql ?

---Oracle is not supported


Microsoft SQL Server requirements for Symantec Endpoint Security 11.0 and Symantec Network Access Control 11.0

http://service1.symantec.com/support/ent-security.nsf/854fa02b4f5013678825731a007d06af/216db2f2828c1274ca25737b0040d3e5?OpenDocument

embedded db can handle 5000 clients , however it has its own limitataion in size. SQL is better in any case.

Thanks for the information.

while viewing logs and reports in sepm console will sql database perform better.

I have been using both , but never seen any diffrence

I have been using both , but never seen any diffrence

I dont think so, or i can say that i have never seen such a diffrence. In the console while pulling up the data it doesnot matter what is the db at the back end. what matters is the amount of data being pulled and how much resources you have on the server.

The ONLY advantage that we have with SQL is the you can go into SQL server Management Studio and create custom reports at your will and also a ease of database adminstration , nothing more than that.

Ultimately it comes down to available RAM, and where your Db files reside.  Under 5000 nodes, if all done right; Db on it's own spindles, with enough RAM, the systems should perform equally.

yes, you're right sir SymSEP, Im using SQL Server 2008 Std. SP1 x64 with my node under 100 but still no difference at all in terms of performance with embedded SQL Engine ?

and one more thing,

is that with SQL Server 2008, you can easily backup and restore using SSMS too, with the Embedded SQL DB it can only be backed up with builtin two buttons application only.

Thanks all for sharing your experience.