Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • Reply To: Non-yielding Scheduler every 30 days

    I changed this max degree of parallelism to 1 today because this Non-yielding Scheduler error still happen every 30 days. Before vale of max degree of parallelism was set 15...

  • Reply To: Non-yielding Scheduler every 30 days

    Few minutes ago databese create dump only few minutes after server reboot. Only one user on database - me. So it can't be other tasks. It can be only some...

  • Reply To: Non-yielding Scheduler every 30 days

    We have version SQL Server Standard 2019 so there isn't limitation of database size 10GB as for Express version.

    Because we have 2 companies we use exactly 2 the same servers...

  • Reply To: Non-yielding Scheduler every 30 days

    Mr. Brian Gale wrote:

    Probably a dumb question, but is there anything interesting in the windows event logs apart from the "application" log? What I mean is, is there anything interesting under System...

  • Reply To: Non-yielding Scheduler every 30 days

    Ant-Green wrote:

    Open a case with MSFT and send them the dumps to analyse whats going on.

    Although this is worrying

    2023-09-26 16:14:10.60 Server      Timeout...
  • Reply To: Non-yielding Scheduler every 30 days

    Ok thanks you for suggestions.

    No I don't have such this software like CrowdStrike, Bit9, CarbonBlack, McAfee.

  • Reply To: Non-yielding Scheduler every 30 days

    Yesterday i didn't restart database like I do every month. Today morning there was so many mesages error "Non-yielding Scheduler " and users can not login to database so I...

    • This reply was modified 1 year, 1 month ago by  sirius98.
    Attachments:
    You must be logged in to view attached files.
  • Reply To: Non-yielding Scheduler every 30 days

    Today  26th of  September  problem happen again with the message

    Process 0:0:0 (0x3f64) Worker 0x0000020289FB8160 appears to be non-yielding on Scheduler 21. Thread creation time: 13340206857857. Approx Thread...

    • This reply was modified 1 year, 1 month ago by  sirius98.
    • This reply was modified 1 year, 1 month ago by  sirius98.
    • This reply was modified 1 year, 1 month ago by  sirius98.
    • This reply was modified 1 year, 1 month ago by  sirius98.
    • This reply was modified 1 year, 1 month ago by  sirius98.
    • This reply was modified 1 year, 1 month ago by  sirius98.
    • This reply was modified 1 year, 1 month ago by  sirius98.
    Attachments:
    You must be logged in to view attached files.
  • Reply To: Non-yielding Scheduler every 30 days

    Yes sure I made this changes according this manual few days ago.

    We need to wait for results till 26-28 of September. Every day right know database works fine.

    By the way....

    • This reply was modified 1 year, 2 months ago by  sirius98.
  • Reply To: Non-yielding Scheduler every 30 days

    OK guys. Thank you for suggestions.

    Why I installed SQL Server Standard on Windows 11 PRO.

    We are trade company and using ERP software on this PC.

    SQL Database of this ERP software...

    • This reply was modified 1 year, 2 months ago by  sirius98.

Viewing 10 posts - 1 through 10 (of 10 total)