The second member of Xujiahe formation of the HC area in the Sichuan Basin has great potential for exploration and development, but it is a typical low-hole and low-permeability tight gas reservoir, which requires in-situ stress refined evaluation to recommend the optimal selection of engineering sweet spots for later vertical fracturing and flat fracturing to increase production. Based on experimental test analysis such as 25 groups of acoustic emission and 13 groups of differential strain, combined with hydraulic fracturing, conventional and special logging data. To analyze the applicability of different experimental test methods in dense sandstone reservoirs by performing a fine-scale evaluation of the magnitude of in-situ stress and identified layers and sweet spots conducive to engineering modifications. The results of the experimental tests the second member of Xujiahe formation in the HC area showed that the maximum horizontal principal stress values ranged from 50.77 to 75.65 MPa, with a mean value of 59.71 MPa; the minimum horizontal principal stress values ranged from 45.37 to 54.31 MPa, with a mean value of 49.31 MPa; and the vertical stress values ranged from 48.11 to 65.62 MPa, with a mean value of 56.53 MPa. The comparison of the three-way stress relationships between the minor layers indicates that the second member of Xujiahe formation is in a strike-slip stress state. The dense sandstone in the second member of the Xujiahe formation is more homogeneous, the acoustic emission test results are more inaccurate. The results of the differential strain test are in better agreement with the results of the in-situ stress magnitude interpretation, making the test method more suitable for more homogeneous sandstone formations. In combination with the magnitude of in-situ stress, it is recommended vertically that the more favorable combination of compartments, upper middle of the second subsection of Xu-II, be selected as the target layer for fracturing. To achieve a better volumetric seam network fracturing transformation, it is recommended to avoid areas near faults with a large horizontal in-situ stress difference factor in the plane. The area of HC102-HC111 well in the central part of the HC area, where high-quality reservoirs are developed and the horizontal stress difference factor is relatively small, should be selected.