How can I fix screen tearing and visual artifacts in Destiny 2 intense combat caused by VRAM overflow?

During intense combat in Destiny 2, VRAM usage approached the limit, causing shader compilation queue backlog and screen tearing that felt like a glitch. I tried lowering texture quality, which reduced VRAM usage but severely compromised visual details, making me feel helpless. I used DDU to clean install the latest Studio driver and cleared the cache in GamePP Shader Compilation Queue Management, then switched DLSS to Balanced. VRAM usage stabilized at 14.2-15.0GB per GPU-Z, and frame generation time converged to 11-13ms per GamePP frame time analysis.