SQLPS.exe uses 100% of 1 CPU core after update KB5005030 (Server 2019) or KB5005043 (Server 2016)

%3CLINGO-SUB%20id%3D%22lingo-sub-2711201%22%20slang%3D%22en-US%22%3ESQLPS.exe%20uses%20100%25%20of%201%20CPU%20core%20after%20update%20KB5005030%20(Server%202019)%20or%20KB5005043%20(Server%202016)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2711201%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22p-rich_text_section%22%3EAfter%20the%20updates%20were%20installed%20SQLPS.exe%20started%20to%20use%20100%25%20of%201%20core%2C%20on%20a%204-core%20machine%204%20SQLPS.exe%20processes%20use%20100%25%20of%20CPU.%202%20cases%20on%20different%20systems%20have%20found%3A%3C%2FDIV%3E%3CDIV%20class%3D%22p-rich_text_section%22%3E%3CBR%20%2F%3E-%20%3CSPAN%3EMicrosoft%20SQL%20Server%202019%20(RTM-CU11)%20(KB5003249)%20-%2015.0.4138.2%20(X64)%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EDeveloper%20Edition%20(64-bit)%20on%20Windows%20Server%202019%20Datacenter%2010.0%20%3CX64%3E%20(Build%2017763%3A%20)%20(Hypervisor)%3C%2FX64%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EUpdate%3A%3C%2FSPAN%3E%3CSPAN%3Ewindows10.0-%3C%2FSPAN%3E%3CSTRONG%3EKB5005030%3C%2FSTRONG%3E%3CSPAN%3E-x64_222160abfb75f543a693ca773dbcd0553ace6f03%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22p-rich_text_section%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22p-rich_text_section%22%3E-%20Microsoft%20SQL%20Server%202016%20(SP2)%20(KB4052908)%20-%2013.0.5026.0%20(X64)%20Developer%20Edition%20(64-bit)%20on%20Windows%20Server%202016%20Datacenter%2010.0%20%3CX64%3E%20(Build%2014393%3A%20)%20(Hypervisor)%3C%2FX64%3E%3C%2FDIV%3E%3CDIV%20class%3D%22p-rich_text_section%22%3EUpdates%20installed%20and%20then%20uninstalled%20on%20Windows%20Server%202016%20Datacenter%20to%20fix%20the%20same%20issue%20(most%20likely%20because%20of%20KB5005043)%3A%20%3CSTRONG%3EKB5005043%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EKB5004238%20KB5004948%3C%2FDIV%3E%3CDIV%20class%3D%22p-rich_text_section%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22p-rich_text_section%22%3EThe%20issue%20was%20reproduced%20by%20installing%20and%20uninstalling%20%3CSTRONG%3EKB5005030%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%20class%3D%22p-rich_text_section%22%3ESo%20far%203%20machines%20affected%2C%20developer%20and%20test%20environments%2C%20to%20prevent%20the%20update%20installation%20on%20production%20machines%20recommended%20to%20stop%20update%20services%20until%20the%20issue%20be%20solved%2C%20as%20this%20is%20cumulative%20update%20and%20the%20bug%20will%20be%20included%20in%20further%20updates%20as%20well%3C%2FDIV%3E%3CDIV%20class%3D%22p-rich_text_section%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22p-rich_text_section%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.jpeg%22%20style%3D%22width%3A%20708px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307599i046D4A437071A32D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221.jpeg%22%20alt%3D%221.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2711201%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLPS%20SQL%20Server%202016%202019%20KB5005030%20KB5005043%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor
After the updates were installed SQLPS.exe started to use 100% of 1 core, on a 4-core machine 4 SQLPS.exe processes use 100% of CPU. 2 cases on different systems have found:

- Microsoft SQL Server 2019 (RTM-CU11) (KB5003249) - 15.0.4138.2 (X64)
Developer Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)
Update:windows10.0-KB5005030-x64_222160abfb75f543a693ca773dbcd0553ace6f03
 
- Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Developer Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)
Updates installed and then uninstalled on Windows Server 2016 Datacenter to fix the same issue (most likely because of KB5005043): KB5005043 KB5004238 KB5004948
 
The issue was reproduced by installing and uninstalling KB5005030
So far 3 machines affected, developer and test environments, to prevent the update installation on production machines recommended to stop update services until the issue be solved, as this is cumulative update and the bug will be included in further updates as well
 
1.jpeg

 

0 Replies