[PVE-User] database performance: KVM or Physical machine

[Philippe Schwarz]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 17/05/2013 14:45, Muhammad Yousuf Khan a écrit :
> we have good specs server machines on which multiple Windows 2008 
> R2 servers are installed what is the recommended approach for
> using MS SQL database. the reason i am asking because i read it on 
> internet that people recommended to  install database server on 
> separate physical machine for better performance.
> 
> so is it just a misconception or virtual machines can also give us 
> the same processing power?
> 
> 
Hi,
I'd say that this reccommandation depends on the way a Db server works.
In short : The more IOPS the better !
So avoiding to spend time in web/PHP-Java-Whatever is useful in order
to be more effective in SQL service.
On the same phys machine (different VM) could be (__could be__, it's
just a suggest) a good solution with fast disks, or in a better way,
with SSDs for your VM.

My 2 cts

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlGWTRYACgkQlhqCFkbqHRYKzQCffHv5tqbDz8jN1bgQqrALkXT7
0D4AnjSlmI9aBbCjUfdumizR+mnpCIvV
=napD
-----END PGP SIGNATURE-----