tempdb contention - be on God's side
'When the tempdb database is heavily used, SQL Server may experience contention when it tries to allocate pages in it. This may cause queries and requests that involve tempdb to be unresponsive for a short period of time. If the page allocation issue creates a chain of blocking, the entire server may become unresponsive for longer periods of time and any further connection to the SQL Server instance may be aborted (time-out). This situation can be observed where workload and concurrency is high.'...
http://sqltouch.blogspot.de/2013/03/tempdb-contention-be-on-gods-side.html
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt