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
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?