New answers tagged

0

I ended up creating a c4.xlarge EC2 and having it operating as my MariaDB 10 server. Due to the large amount of traffic currently and a major increase coming with new marketing campaigns I could not depend on RDS without spending several hundreds per month. And I found numerous complaints about AWS RDS with similar issues as mine. Now the system is able to ...


0

Thanks for all the answers. They have been very helpful. After some subsequent research, I found that I/O speed was not the main bottleneck in this particular case, although it's important in general. Best practices in tempdb management include having at least 4 data files. Microsoft also recommends 1 data file for each cpu core. Having more files helps ...



Top 50 recent answers are included