开发者

What would be reason behid WaitType PAGEIOLATCH_SH?

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?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜