The below is from EC7 Part 1. It is very general guidance. Often the type of structure dictates the site investigation. Geology and local knowledge is also very important. Without knowing what your site investigation is for its hard to give a more specific answer.
B.3 examples of recommendations for the spacing and depth of investigations
(1) The following spacing of investigation points should be used as guidance:
− for high-rise and industrial structures, a grid pattern with points at 15 m to 40 m distance;
− for large-area structures, a grid pattern with points at not more than 60 m distance;
− for linear structures (roads, railways, channels, pipelines, dikes, tunnels, retaining walls), a
spacing of 20 m to 200 m;
− for special structures (e.g. bridges, stacks, machinery foundations), two to six investigation
points per foundation;
− for dams and weirs, 25 m to 75 m distance, along relevant sections.
(2) For the investigation depth za the following values should be used as guidance. (The reference
level for za is the lowest point of the foundation of the structure or structural element, or the
excavation base.) Where more than one alternative is specified for establishing za, the one which
yields the largest value should be applied.
NOTE For very large or highly complex projects, some of the investigation points generally extend to greater
depths than those specified under B.3 (5) to B.3 (13).
(3) Greater investigation depths should always be selected, where unfavourable geological
conditions, such as weak or compressible strata below strata of higher bearing capacity, are
presumed.
(4) Where structures under B.3 (5) to B.3 (8) and B.3 (13) are built on competent strata, the depth
of investigation can be reduced to za = 2 m, unless the geology is indistinct, in which case at least
one borehole should be taken down to a minimum of za = 5 m. If a bedrock formation is
encountered at the proposed base of the structure, this should be taken as the reference level for za.
Otherwise, za refers to the surface of the bedrock formation.
(5) For high-rise structures and civil engineering projects, the larger value of the following
conditions should be applied (see Figure B.1 a)):
− za ≥ 6 m;
− za ≥ 3,0bF.
where bF is the smaller side length of the foundation.
(6) For raft foundations and structures with several foundation elements whose effects in deeper
strata are superimposed on each other:
za ≥ 1,5⋅bB
where bB is the smaller side of the structure, (see Fig. B.1 b)).