June 28, 2024 at 1:46 pm
SQL 2019 CU 27 added a warning that appear to be a bug!
WARNING Long asynchronous API Call: The scheduling fairness of scheduler can be impacted by an asynchronous API invocation unexpectedly exceeding xxxxxms
A few of my servers are getting hundreds of thousands of these bogus warnings and are making my logs useless
I need a wy to turn these off.
thank you
June 28, 2024 at 3:55 pm
its a bug - will be fixed on future CU - helps reading the documentation https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2019/cumulativeupdate27
June 28, 2024 at 4:23 pm
Thanks, it didn't have the bug notice when I read that document ..
July 3, 2024 at 7:42 am
Yep, not the best experience for us either. Installed the CU yesterday on some of our servers, and in 30 hours, the error log has grown to 130 GB. Not seeing it in our Test environment, which was updated 10 days ago.
Not being able to turn off the warning message, we're simply cycling the error log, and aging the files out to prevent the host disk from filling up.
Given that the bug notice seems to have been added recently, hopefully MS are pulling the stops out to get an updated CU ready.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply