I don't know much about virtualization. Somebody just told me tha it can take use of other servere which are in your virtual environment.
Yes and No. :-D nothing is more dangerous that partial knowledge, isn't it?
In a virtualized environment you certainly can increase processing power by moving CPUs from one "virtualized server" to another, please note that the key word here is "virtualized".
You can build several virtual servers in a single host computer so, when you are moving CPUs from one virtual server to another you are playing with the CPUs in that particular physical server.
As you can see this does not solves your issue.
But, I know that in clustering, for example you have 3 servers. you can implement active-active cluster , then use table partiotionning to break your database into parts and put each part in an one cluster node.Now what you have is 3 servers, each of them servicing one part of database.Is that false?
Yes and No. :-D
What you describe is not clustering but database sharding. SQL Server implements database sharding thru "Federated Databases", this is what you have to research.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at Amazon and other bookstores.Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.