Hello!
I'd like to know what is the best storage configuration for VM with MSSQL Server 2014 running on Win2012R2 guest. Maybe get some advice
After fresh proxmox installation with ext4 type we got an LVM-Thin storage which is worst possible storage for MSSQL, AFAIK. As Proxmox wiki said it is possible to revert this configuration to regular LVM by deleting thin pool and add regular LV, format it with ext4 and mount to /var/lib/vz or somewhere else.
The question is, is it necessary to make an FS on logical volume? I mean, couldn't we just delete thin pool from default installation, then in GUI add PVE VG as an LVM storage, so new VM will make its own LV for an HDD image. There is no need for ext4 on top of it what should give a better performance.
Correct me if i'm wrong.
Thanks!
I'd like to know what is the best storage configuration for VM with MSSQL Server 2014 running on Win2012R2 guest. Maybe get some advice
After fresh proxmox installation with ext4 type we got an LVM-Thin storage which is worst possible storage for MSSQL, AFAIK. As Proxmox wiki said it is possible to revert this configuration to regular LVM by deleting thin pool and add regular LV, format it with ext4 and mount to /var/lib/vz or somewhere else.
The question is, is it necessary to make an FS on logical volume? I mean, couldn't we just delete thin pool from default installation, then in GUI add PVE VG as an LVM storage, so new VM will make its own LV for an HDD image. There is no need for ext4 on top of it what should give a better performance.
Correct me if i'm wrong.
Thanks!
