Timeline for Could a busy database affect others on the same server?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 17, 2018 at 10:44 | vote | accept | Nour Berro | ||
| Dec 17, 2018 at 10:36 | comment | added | Michael Green | There are too many variables to say for sure. But, intuitively, if there are more system resources it can do more work, or the same work faster. This assumes a very large number of small actions, not a few really big ones. And be sure memory and / or CPU is the actual bottleneck, not network, disk, poor indexes, or badly-written queries. Or other activity on the box. Or the antivirus software. Or poor patching levels. Or ... you see where I'm going with this? | |
| Dec 17, 2018 at 10:29 | comment | added | Nour Berro | so if I separate the very busy database into two databases on the same server it may improve the performance specially if i increased the CPU and the Memory. | |
| Dec 17, 2018 at 10:26 | history | answered | Michael Green | CC BY-SA 4.0 |