I'm trying to understand CloudWatch metric about my database running queries.
I read that when some query has high PAGEIOLATCH_SH and CXPACKET together it means that the query is poorly indexed or missing important indexes and PAGEIOLATCH_SH occurrence almost ever means bad indexing, is it true?. Now about LCK_M_IX, two of my queries have it in high levels. Is some other query blocking their try to INSERT, DELETE, UPDATE data or are they blocking everything else? How can I figure out the blocking query?
