|
| Iniciado por guest, 19,nov. 2014 08:07 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 19,noviembre 2014 - 08:07 |
Hi all,
We have a VPS hosting about 6 different databases on one HFSQL Server.
Does having two separate servers, of 3 databases each (on different ports), enhance performance?
Thanks
Sarah |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,noviembre 2014 - 11:16 |
Hi Sarah
never tested, but let's examine what I DO know...
Generally, the bottleneck on a DB server is the hard drive. In that aspect, if you are reaching this botleneck, having a second HF server ALSO trying to read from disk wil not enhance anything (in fact, it may even slow down things)... So for that, we get a NO
Also, we have to find out what the processor situation is: If your two HF server are sharing a processor core, then NO, it wont enhance anything, on the contrary even. But if your server has multiple processors/cores and each HF server has it's own set, then both can run in parallel and you will get more performance... So here we get a MAYBE
Finally, the last aspect ifthe cache. Each HF server has a cache setting. So if you have enough memory available to set a BIG memory cache for each of your two HF server, you will get a better performance, as more request will be served from the cache. That point also balances the hard drive bottleneck and should be considered a YES.
With all that, in theory, with enough processors/cores and enough memory, the general tendency seems to go to YES. On any more basic machine, I would say NO.
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,noviembre 2014 - 14:04 |
| Thank you very much Fabrice! |
| |
| |
| | | |
|
| | | | |
| | |
|