Mcafee CSR performance issue

[adnankhazaleh]

how to size McAfee CSR to choose the hardware requirements that fit with customer , as the customer suffering from performance issue when generating web reports for 3 days , the customer use external DB and use Separate servers for epo and CSR . is there any guide or best practices to install reporting without performance issues 

[LKS]

Hi adnankhazaleh,

I would like to know little more information on this issue. What kind of performance issue are you facing.

Is it a dedicated EPO for CSR. Are you looking hardware configuration for EPO server or CSR database server. If you could explain little more with detailed information, it would be helpful for us to look into it. 

Was my reply helpful?

If you find this post useful, please give it a Kudos! Also, please don't forget to select "Accept as a soultion" if this reply resolves your query!

[adnankhazaleh]

generating reports takes time to complete and sometimes the progress of the report stuck at 0% for hours , the customer use two servers one for epo and one for CSR and external DB to save the logs , epo is dedicated for CSR 

[Former Member]

Hello,

I would like to request you to please refer the below link to get some more idea:

https://kc.mcafee.com/resources/sites/MCAFEE/content/live/PRODUCT_DOCUMENTATION/27000/PD27999/en_US/...


Was my reply helpful?
If you find this post useful, Please give it a Kudos! l Also, Please don't forget to select "Accept as a solution" if this reply resolves your query

[adnankhazaleh]

installation Guide shows the hardware  requirements for three customer size categories without any Clarification to choose the right category 

[AaronT]

We've struggled through a number of CSR performance issues. How many log sources are sending data and how long are you keeping the logs in the database?  Based on that, what did you size for the DB and the CSR server?

[adnankhazaleh]

there are two log source sending about 30 - 50 log files of 100 MB daily , and the customer keeps data for 12 months

[adnankhazaleh]

the database size is about 300 GB and increasing 

[AaronT]

Is this using MSSQL?  And is partitioning enabled?

What size did you do for the CSR server and DB?  Medium or Small?

[adnankhazaleh]

Yes, the Database is Mssql and managed by the customer, we use small size for CSR server