I noticed a big uptick in tempdb read/write. This was during the same period of time that someone ran Alter Index
and I noticed that the biggest wait at that time was LCK_M_SCH_S
.
I'm trying to track down what caused the uptick in read/write latency. All four tempdb files had the uptick, so I'm thinking it was either the schema lock from LCK_M_SCH_S
or maybe a network connectivity issue.
It has since cleared and gone back to normal so I'm thinking more towards the lock issue. The wait type was not I/O according to the SQL monitor we use, but I can't find anything online that makes the connection between LCK_M_SCH_S
and tempdb. Thoughts?