Monthly Archives: April 2014

Beware the impact of Auto Update Stats kicking in unexpectedly..

Interesting catch today with someone complaining of some API latency a week ago for a couple minutes.  IGNITE shows some 50 processes blocked at this time: Head blocker is a SPID (694) from a SOAP server. The SQL being executed … Continue reading

Image | Posted on by | Tagged | Leave a comment