Whenever instantiating a database for storage on a hyperconverged infrastructure, such as the case with the persistence provider accompanying ThingWorx, it is best practice to create separate disks for the host OS, for the data, and for the database logs.
In VMware, the configuration steps are simple. In the settings of the VM, add additional hard disks, typically assigning the largest amount of storage for the data disk. Leave the boot disk for the host OS as Hard Disk 1. Create one SCSI controller per disk, and assign it as the VMware Paravirtual type. Once the controllers are created, adjust the hard disk settings such that each hard disk has a dedicated SCSI controller.
Upon booting the VM and depending on your host OS, complete the partitioning, mounting, and formatting of the additional disks. Update the database configuration to point to the correct paths for these disks. The steps will vary depending on your OS and selected database.
If working on an existing database, follow proper procedures for backup and migration.
See Scaling, infrastructure, and migration tasks for detailed information on setting up hard disks and controllers and configuring databases.