ControlPoint SQL Server - Number of CPU's

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

Parents
  • Verified Answer

    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

Reply
  • Verified Answer

    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

Children