AnandTech Ad Database Performance

Next up on the test list is our Ad Database Server test bench. All of the ads across AnandTech and the AnandTech Forums are served using e-Zone Media's FuseAds advertising management software. The software was custom tailored to fit our needs and is tightly integrated with our internal content management system. The end result is that the ad placement, rotation, statistics and customization is very flexible and easy to use for our sales staff, however its tight integration with the entire network means that this server is just as important as the content feeding servers. Should the Ad Database be slow to respond or not respond at all because of an overwhelming load, the entire site and forums would slow to a crawl.

Our Ad DB is still running off of a dual Pentium III 866 machine and will be upgraded over the next few weeks, what should this box be running instead?

AnandTech Ad Database Performance
Transactions per Second
Athlon MP 2000+ (1.6GHz) x 2

Xeon 2.2GHz x 2

Xeon 2.2GHz x 2 (HT Enabled)

Athlon MP 1.2GHz x 2

Intel Xeon 2.2GHz (HT Enabled)

Intel Xeon 2.2GHz

AMD Athlon MP 2000+ (1.67GHz)

Xeon 1.7GHz x 2

AMD Athlon MP 1.2GHz

Intel Xeon 1.7GHz












While we started off the analysis on the previous page by talking about the single CPUs and moving on to the dual configurations, we can't do the same here. If you look at the results of the older 1.7GHz Xeons you'll quickly realize that a single Athlon MP 2000+ can outperform the pair in this test. Once again, the newer Xeons manage to perform just about on par with the Athlon MP 2000+. The 2.2GHz part is 1.3% faster and enabling Hyper Threading gives it a 1.5% improvement, both not enough to truly separate the two.

Looking at the faster dual CPU solutions, the dual Athlon MP 2000+ is running on par with the dual 2.2GHz Xeon platform. What's interesting is that there is actually a 5% reduction in performance when Hyper Threading is enabled with two physical CPUs installed in the system. Although this isn't as huge of a hit as is possible when enabling Hyper Threading in desktop situations, the fact that it did occur makes it clear that although Intel recommends turning it on for servers you really have to look at the type of transactions your server is handling before making the final call on the feature. Luckily a 5% penalty is small enough that if accidentally enabled, it won't cause too much harm but it's something to be aware of nevertheless.

What's also interesting to point out here is that this DB test isn't as nearly demanding on the CPUs after a certain level. The dual Athlon MP 2000+ setup manages to outperform the dual Athlon MP 1.2GHz platform by just over 7%, indicating that other bottlenecks are at play here.

AnandTech Website Database Performance AnandTech Forums Database Performance
Comments Locked


View All Comments

Log in

Don't have an account? Sign up now