Database Administrators Asked by TitanL0rd on February 19, 2021
We currently have an issue with some queries/jobs causing non-yielding at a specific point in time.
There no are mini dumps which are generated when this happens.
Is there a way to know which query was causing the non-yielding on a specific scheduler in the past?
Look in your Wait Stats (preferably Query Store Wait Stats, Session Wait Stats, and otherwise System Wait Stats) for preemptive waits.
Sessions enter preemptive waits when calling into code that doesn't participate with SQL Server's cooperative scheduler, which is a common cause of a session refusing to yield a scheduler (CPU Core).
Answered by David Browne - Microsoft on February 19, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP