OLEDB waits not always updating in sys.dm_exec_session_waits - by Lonny Niederstadt

Status : 


Sign in
to vote
ID 3135073 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 5/31/2017 5:32:06 PM
Access Restriction Public


I've been testing checktable operations extensively in SQL Server 2016 SP1 cu0, and changing DOP from 1 to 8 on an 8 vcpu VMware vm.
OLEDB waits always seem to update in os level wait stats; not always in session level wait stats.
Some scenarios cause session level OLEDB waits not to update in checktable operations with MAXDOP > 1, some conditions cause session level OLEDB not to update with MAXDOP = 1. 

Sign in to post a comment.