Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning tempdb contention on System tables RE: tempdb contention on System tables
mxy
SSCarpal Tunnel
Points: 4034
More actions
May 6, 2015 at 8:58 am
#1795960
I quickly ran wait stats on the server in question. the two session that are in blocking state have following locks
PREEMPTIVE_OS_GETPROCADDRESS blocking
LCK_M_S blocked
I believe blocking session is holding lock on tempdb tables