Diagnostic Data for Synchronous Statistics Update Blocking

added by DotNetKicks
11/13/2018 6:39:22 PM

1 Kicks, 2325 Views

Consider the following query execution scenario: You execute a SELECT query that triggers an automatic synchronous statistics update. The synchronous statistics update begins execution and your query waits (is essentially blocked) until the fresh statistics are generated. The query compilation and execution does not resume until the synchronous statistics update operation completes.