These days it has become trendy to talk about Virtualization. Virtualization has its virtues – however,you also need to study and plan carefully the workloads that you want to virtualize. Since database hosting is getting virtualized and databases by their very nature are very I/O intensive there are a myriad of things you need to understand when virtualizing database workloads.
So, before you virtualize a workload you should have an understanding of what that workload looks like on a physical machine first and part of that understanding involves storage interaction. I/O intensive workloads like SQL require some planning. SQL even has a tool that can be used to simulate workloads on storage, which you can find in this link:=
Some of the other relevant links to Virtualizing SQL are here:
OK. Now coming to some of the salient points, SQL virtualization needs careful consideration of the storage systems you are using and its I/O characteristics. Some of the main considerations are as below.