开发者

What would be reason behid WaitType PAGEIOLATCH_SH?

开发者 https://www.devze.com 2023-02-07 05:32 出处:网络
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 exe

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

精彩评论

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