I am executing a stord proc that basically truncates & reload the table x.During reload of data , It joins table a , table b that contains 100 millions & 2 millions records resp.During the execution of stored proc i found in activity monitor that WaitType PAGEIOLATCH_SH is slowing down my sp. what would be the reason behind this waittype "PAGEIOLATCH_SH". And how to avoid this waittype.
Thanks in开发者_JAVA技巧 Advance.
This might be helpful What is PAGEIOLATCH_SH wait type in SQL Server?
精彩评论