high available

I have 3 of the same servers. My question is, in High Available mode, what would be the impact on an MSSQL server? I am unsure how Promox manages mount images. Does it create a shadow copy on the hard drive, and does real-time sync to the hosted image? Or does it force the VM into ram and use...