ref links
overview; iscsi works great when hosting a virtual machine, as it provides a high performance portable storage solution. However, when used for database or file servers, ISCSI should be linked direcly to the server. This ensures that no additional overhead is added from vmfs and more importantly, that the disk setting are contained with the internal server configuration.
Example;
- A sql2005 database server that has an OS hosted by a vmware server.
- Hosting the OS in vmware make the OS independent of a hardware failure, and incurrs a negligible performance impact from esx.
- Storing the SQL files on the iscsi device ensures that even a software failure will have little impact on the database files, and allow quick recovery by mounting the datafiles on another sql server.
- Furthermore, since snapshots or clones of the OS disk can be stored, the OS disk can be recovered quickly by mounting a saved version of the vmdk