Tagged Questions
2
votes
4answers
215 views
Should I expect a great increase in Oracle performance in terms of handling multiple requests switching from single to dual core?
We have an Oracle database of roughly 100 GB that runs on top of a Windows Server 2k3R2 VM in ESX in a 1 socket, 1 core configuration. Whenever it has to handle a major query it seems to get "pegged" ...
2
votes
1answer
1k views
Hyperthreading vs. SQL Server & PostgreSQL
I have read that hyperthreading is a "performance killer" when it comes to DBs. However, what I read didn't state which CPUs. Further, it mostly indicated that I/O was "cut to < 10% performance".
...
