Home Forums SQL Server 2019 SQL Server 2019 - Administration Non-yielding Scheduler every 30 days Reply To: Non-yielding Scheduler every 30 days

  • December 7, 2023 at 6:41 am

    #4341324

    wrote:

    Users told me that they can not connect and after some time database work fine for next few minutes. Best solution is restart PC ... but next month the same problem happen. My hard discs are fine (SSD NVME), Windows 11 PRO and SQL Standard 2019 have latest updates. I don't have idea what to check and what to do next.

    That's what the OP had in his original post.  This looks like a prelude to spam.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)