반품
-
제목
How to find the cause of page split? -
설명
How to find the cause of page split?
-
해결 방안
Page splits - this metric is being shown at Instance level and it cannot be directly co-related to the SQLs that may have caused the problem.
The correct way of following up this issue would be:- determine the time frame in the PI History when the high page splits, narrow down the time frame as much as possible
- in the same time period, follow the program that caused the high page splits, and
- drill down the program to see what type of SQL statements this program ran in this time frame that caused the high page splits.