CPU utilization is certainly not high during the resource_semaphore_query_compile wait logjam*.
But... spinlock SOS_BLOCKALLOCPARTIALLIST has a pretty high level of activity during that time range. Neither Google nor Duckduckgo know much about that spinlock type. Maybe in the future I will :-)
*I describe that here...
http://sql-sasquatch.blogspot.com/2014/09/resourcesemaphorequerycompile-logjam.html
No comments:
Post a Comment