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...

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...

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...

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...

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...

Ok thanks you for suggestions.

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

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, 2 months ago by  sirius98.

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, 2 months ago by  sirius98.
• This reply was modified 1 year, 2 months ago by  sirius98.
• This reply was modified 1 year, 2 months ago by  sirius98.
• This reply was modified 1 year, 2 months ago by  sirius98.
• This reply was modified 1 year, 2 months ago by  sirius98.
• This reply was modified 1 year, 2 months ago by  sirius98.
• This reply was modified 1 year, 2 months ago by  sirius98.

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, 3 months ago by  sirius98.

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, 3 months ago by  sirius98.