Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • kevinuk84 10 posts 30 karma points
    Sep 06, 2021 @ 07:04
    kevinuk84
    0

    High CPU Usage

    Hi,

    Is there a way to throttle the CPU usage when sending a newsletter? Recently, I have noticed SQL Server utilising 100% of a single vCPU.

    If useful, I have a set of perfmon logs and a SQL trace - However, I'd prefer not to share them via this public forum.

    Kind Regards

    Kev

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Sep 06, 2021 @ 08:29
    Markus Johansson
    0

    Hi!

    The process of sending is quite SQL-intense since the que is stored in the database.

    What version of the package are you running on?

    What version of Umbraco are you on?

    How does you setup look? What kind of machine? Number of CPUs and memory?

    // m

  • kevinuk84 10 posts 30 karma points
    Sep 06, 2021 @ 08:54
    kevinuk84
    0

    Thanks Markus,

    4 vCPU - Intel Core i7 2GHz 10GB RAM

    SQL Express - So limited to a single CPU.

    Umbraco 7.7.4

    Newsletter Studio 2.1.9.8

    Would the throttling settings add value?

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Sep 06, 2021 @ 08:59
    Markus Johansson
    0

    Hi!

    The V2-version of the package has throttling settings, see details in the docs: https://www.newsletterstudio.org/help/getting-started/basic-settings/

    It would basically pause the process for a time, this would most likely reduce the load on the server.

    You could try to enable throttling and set the "Throttling seconds between batches" to something like 2 seconds or something to see it this has any impact. Be aware that this will slow down the sending process.

    Are you sending to very big lists? How many recipients?

    // m

  • kevinuk84 10 posts 30 karma points
    Sep 06, 2021 @ 12:39
    kevinuk84
    0

    Great - Thank you.

    I have enabled throttling, setting it to batch 100 messages and pause for 5 seconds.

    The largest recipient list we have is ~1400.

    Kind Regards

    Kev

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Sep 06, 2021 @ 15:00
    Markus Johansson
    0

    Hi!

    Okey, that sounds fair - might want to have e shorter deelay and smaller batch size.

    Ex:

    Batch: 10 Pause: 2 sec

    Let me know if this has any impact on the CPU usage

    / m

Please Sign in or register to post replies

Write your reply to:

Draft