Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more

  • State Verified Answer
  • Replies replies
    3
  • Subscribers subscribers
    7
  • Views views
    675
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

ControlPoint SQL Server - Number of CPU's

kuth

Team,

Currently, we have 4 CPU's in our Controlpoint SQL Server , the ControlPoint injestion purchased for 25TB and based on performance metrics by our DBA proposing  [ revising ] to 2 CPU's 

Any recommendations or impact due to this? I am going through ControlPoint Support Matrix and install guide and unable to find the recommendation on the cpu'S?

Any Advice \ Suggestions?

Thanks,

Kuth

  • Verified Answer

    +1

    Hi Kuth,

    We don't normally specify the number of CPUs but we do mention 16 cores.

    In the ControlPoint_5.9.0_DBConversion.pdf  an example SQL Server system is listed as:

    CPU 2x Intel Xeon E5 2660 @ 2.20GHz, Hyperthreading Enabled (Total: 16 core/32 thread)
    RAM 128G DDR3 (SQL permitted to use 124G)
    System Disk 1x 450G HDD
    Tempdb Disk 7x 900G 2x HDD RAID0
    Database Disk 3x 1500G SSD


    So 2 CPUs should be fine as long as you have 16 cores.
    The most important factors for overall ingestion performance are memory, fast disks and multiple discrete files for the database files.

    Regards,
    Colin

  • 0 in reply to 

    Thanks Colin, Noted with thx. We need to upgrade ControlPoint as we are approaching CM10.* [ Either CM 10.0 with Patch2 or CM10.1 if it releases on Mid May as Microfocus confirmed ] , then upgrade to 5.9 and still we are on 5.8. Any timeline as End of support for 5.8 at the moment and I believe it is too early. 

  • 0   in reply to 

    Hi. CP 5.8 is planned end of support in Jan 2023. Regards. J-Mi

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.