cancel
Showing results for 
Search instead for 
Did you mean: 
Reliable Contributor AaronT
Reliable Contributor
Report Inappropriate Content
Message 11 of 19

Re: Mcafee CSR performance issue

Jump to solution

What about the MSSQL performance?  what do you have configured for that?  You might need some additional RAM to run the extended queries with more a few months of data

Re: Mcafee CSR performance issue

Jump to solution

Database server configured with 32 GB of RAM 

Reliable Contributor AaronT
Reliable Contributor
Report Inappropriate Content
Message 13 of 19

Re: Mcafee CSR performance issue

Jump to solution

When we live, the minimum recommended database was at least cores and at least 64 GB of RAM for the small environment.  Medium doubled the RAM and Large went to 24/256.  We are a much larger environment (our DB is multi-TB) and we ran 128GB x 16 core database with minimal issues.  I would look at adding resources to the DB server as that is where the bulk of the processing is done.

Re: Mcafee CSR performance issue

Jump to solution

In our case, what is the recommended specs for all servers  (CSR, epo, DB)? As McAfee Support Team ask me to use external DB and use separate servers for epo and CSR and this does not solve the problem 

Reliable Contributor AaronT
Reliable Contributor
Report Inappropriate Content
Message 15 of 19

Re: Mcafee CSR performance issue

Jump to solution

I can't speak for McAfee, but it appears that the CSR Server is sized right and configured right or the inserting of log data would be painful.  I suspect the issue is with resources on the database. 

I would recommend getting the database to at least 10 cores and either 64 or 128 GB of RAM to see if that solves the problem.  That would be a small to medium configuration for the DB.

 

Re: Mcafee CSR performance issue

Jump to solution
we proceed with upgrade CSR to version 2.6 and after upgrade , we need to update database schema but it is seems took long time as the task was running for two days . is it normal ?
Highlighted
Reliable Contributor AaronT
Reliable Contributor
Report Inappropriate Content
Message 17 of 19

Re: Mcafee CSR performance issue

Jump to solution

Per the 2.6 installation guide:  The amount of time it takes for the schema to update depends on the size of your database. For example, a database with 50 GB of data takes about 5 hours to update.

So it could take 1 hour per 10 gb of data.

Re: Mcafee CSR performance issue

Jump to solution
the database size about 320 GB , so we need about 33 hours to complete , but this task running for 4 days without completion
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 19 of 19

Re: Mcafee CSR performance issue

Jump to solution

I am also going to move this over to the group that supports CSR, as they can probably answer your questions better.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator
  • Community Help Hub

      New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

    • Find Forum FAQs
    • Learn How to Earn Badges
    • Ask for Help
    Go to Community Help

    Join the Community

      Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

    • Get helpful solutions from McAfee experts.
    • Stay connected to product conversations that matter to you.
    • Participate in product groups led by McAfee employees.
    Join the Community
    Join the Community