You cannot add multiple SCSI controllers through the PVE UI. To do so, you will need to experiment with direct QEMU options via --args.
I am not sure which UUID your SQL installation is bound to, as there are several possibilities. Most of these identifiers will change once you modify almost everything about the disk configuration: controller type, driver, disk model, disk serial number, etc.
Given your scale, you may want to engage a PVE partner or, at a minimum, purchase a support subscription so you can obtain guidance directly from the developers. I'd imagine there is a significant number of support subscriptions on the line with 8000 VMs.
Blockbridge : Ultra low latency all-NVME shared storage for Proxmox - https://www.blockbridge.com/proxmox
Hello you are correct I finally figured this out with the help of Deepseek. I was able to get the commands in the config file
Here the example incase anyone else is looking.
# Add this line to your VMID.conf file
args: -device virtio-scsi-pci,id=scsihw1,bus=pci.0 -device virtio-scsi-pci,id=scsihw2,bus=pci.0
# Keep your OS disk managed by Proxmox normally
scsi0: local-lvm:vm-100-disk-0,size=40G
# Manually add the other two to scsihw1 (the second controller)
args: -device virtio-scsi-pci,id=scsihw1,bus=pci.0 \
-drive file=/dev/pve/vm-100-disk-1,if=none,id=drive-scsi15,format=raw \
-device scsi-hd,bus=scsihw1.0,channel=0,scsi-id=0,lun=0,drive=drive-scsi15,id=scsi15 \
-drive file=/dev/pve/vm-100-disk-2,if=none,id=drive-scsi16,format=raw \
-device scsi-hd,bus=scsihw1.0,channel=0,scsi-id=1,lun=0,drive=drive-scsi16,id=scsi16