Scaling up by Downgrading?

Is low-end SQL Express 2005 the way to go for a heavily trafficked site? OK, I know. The question sounds daft, but hear me out.

Right now, Atomic Avenue (and ComicBase.com for that matter) use SQL Server 2000 as their back-end database. Like most databases, the bread and butter of the whole thing is garden variety SQL: SELECTs, UPDATEs, etc. using the requisite JOINs, stored procedures and whatnot, along with the occasional subquery, and—I think once or twice in the entire database—something really avant garde like a temporary table. The point is, we make use of basically none of the high-end features that Microsoft has been stuffing into SQL Server in the past few versions to try to sell to the “enterprise” market.

What we do make use of is connections—lots of them. And that’s where we’re starting to get into trouble. See, you don’t just pay Microsoft a couple of grand to use SQL Server, you pay a couple of grand to use SQL Server on one machine, with up to five simultaneous connections going. If you want more connections (and believe me, you do), you have to spring for something called a “CAL” — Client Access License, which permits your server to keep more than that number of connections open at once. These CALs come in “packs” of five, ten, twenty five, etc. and cost about $162 per connection license. Need 25 more simultaneous client connections on your “SQL Standard Edition” server? That’s a cool $4,050 on top of the initial purchase price of $1,899. And remember: that’s for one server.

Being the kind folks they are, Microsoft also offers the option of skipping all this CAL business and just licensing SQL Server for a fixed amount based on the number of processors on your server machine. An SQL Standard Edition license by processor runs $5,999—so that’s basically $12,000 if your machine has two processors. But heck, at least that’s better than the Enterprise Edition of SQL Server 2005: that baby runs $24,999 per processor. Imagine: $50,000 to run a single piece of software on one machine. I’ve just depressed myself utterly by realizing that a copy of ComicBase sells for something like 1/10th of 1 percent of that. We’re definitely in the wrong end of the software biz!

The only good news in this scenario is that connections go surprisingly far if your site is programmed halfway properly. Typically, you can open, service, and close connections in well under a second, allowing a relative handful of connection licenses to handle the connections generated by thousands of typical users without too much waiting around for a free connection to open up. Still, as Atomic Avenue’s traffic continues to grow, I’m getting concerned about lack of available client connections becoming a problem.

The obvious way to handle the problem is to just throw money at it and pay Microsoft for ever-more licenses. When I think of all the giant Alien statues and toy robots we could buy for the office with that same money, however, I’ll admit I have to think twice before reaching for my wallet.

One intriguing alternative is that we might be able to solve the problem by actually downgrading our production servers to the new “Express” version of SQL Server 2005. This version was introduced to compete with free databases like MySQL, and brings virtually all the features of the full versions of SQL Server to the table, but with no cost for the application, and unlimited client connections. The catch? Microsoft hobbled the server by limiting it to handling databases of 4 GB or less; the server can only make use of one processor (but as many cores as it wants); and it can only use 1 GB of RAM for the buffer memory.

Of these limitations, frankly, the memory one gives me the most pause, but it definitely seems worth checking out. I think there’s at least the chance that we may be better off going down to the free version, than by throwing untold thousands at the folks in Redmond. (And if this doesn’t work, we also have the option of rewriting the back-end database in something like MySQL anyway, although that would be a major project to say the least).

I just got our new quad-core database server racked up and ready to go using SQL 2005 Express. I’m not really getting my hopes up, but I’ll let you know what I find out… (And if any of you have experience in this area, by all means write and let me know what you discovered!)

[digg=http://digg.com/microsoft/Is_the_free_version_of_SQL_Server_better_than_the_paid_one]

Life-Size Lost in Space Robot

I want one.

http://www.lostinspacerobot.com/index.html

…actually I want a whole bunch of them. For the office 😉

Crazy “Zoom Art”

Just amazing stuff:

http://zoomquilt2.madmindworx.com/zoomquilt2.swf

(and apparently available as a screen saver too!)

Confused About Processors

For the first time in as long as I can remember, I’m utterly at a loss as to which processor is faster—or whether buying a server with a new processor (or even multiple processors) will make the slightest bit of difference in terms of overall performance of our web site.

Back in the day, it was easier to say whether a new processor would be faster than an old one: just look at the clock speed. 1.6 GHz smoked a 800 MHz processor; 2.4 GHz was better still, and 3.6 GHz was the best you could buy. But then heat factors put an end to simple clock speed races and Intel and AMD turned to multiple processors, multiple cores, different piplelining schemes, and so on.

I’ve heard the advice that multiple cores and processors are essentially worthless unless you’re running a machine specifically geared toward using the multiple cores. But how then, is a 2.4 GHz Core 2 Duo noticeably outperforming my 3.4 GHz Pentium at most regular desktop work—none of which (that I can see) has been optimized to work with two processors?

Then there’s the question of our web servers: when running Windows Server 2003 and IIS 6, is there any advantage at all to upgrading our 3.0 GHz Xeon processor-based servers to whatever the top-of-the-line offerings from Dell or Supermicro are? So far as I can tell, the major bottlenecks for web servers are bandwidth (not immediately upgradeable), disk (we’re already running fast SATA drives in RAID configurations), and only then the processor speed. That said, kicking off compiles in ASP.Net does feel kind of slow to me, and I’d be willing to throw some cash at solving the problem…but I’d have to have some assurance first that throwing cash at it would actually make a noticeable difference in some metric I care about (# of web requests serviced, compile speeds, etc.)

Ideally, what I’d like to have a sense for is, “If I spend $X to buy Y, my <something I care about> will run Z% faster than it does now.” Several nights spent googling around on this score really haven’t yielded anything enlightening. I’ll admit it: right now, I’m at a loss.

Can anyone with real-world experience on our brave new world of processors kick in some words of wisdom on this subject?

The Atomic Avenue Comic Book Trivia Challenge

With the system coming up on its first anniversary in a couple of months, we decided to have some fun. This week, we kicked off the Atomic Avenue Comic Book Trivia Challenge, designed to test your knowledge of the fabulous four-color fantasy world of comics.

From January 15th through the 31st, we’re posting a new question (actually a question and a bonus question) each day to the Atomic Avenue web site. Answer them correctly, and you’re entered to win great daily prizes including Marvel Masterworks volumes, DC Archives, Marvel Essentials, and more. Best yet, your total score adds up to give you a chance to win three amazing prizes which are among the few things you can’t find on Atomic Avenue—or anywhere else, for that matter:

– A copy of Batman: The Dark Knight signed by Frank Miller himself

– Frank Miller’s copy of Daredevil #179 (Elektra vs. Bullseye) from his personal collection

– and Frank Miller’s very own copy of Daredevil #181—the death of Elektra

(As a karmic bonus, Atomic Avenue arranged to buy the prizes from the Comic Book Legal Defense Fund in order to help them raise funds for their efforts. Check out http://www.cbldf.org for more information on this terrific organization)

If you think you know your stuff, head on over to Atomic Avenue and give it a shot!

Acronym Watch: SSD

It stands for Solid State Drive, and it’s my guess that this will be the year that it becomes a commonly used term in tech—if not yet a commonly used technology in our computers.

Basically, it means replacing the hard drive in (usually, a notebook) computer with a device which uses flash memory attached to an SATA or IDE interface, and fits in the same form factor as a notebook drive. The main advantages are speed, silence, and minimal power draw. Plus, the drives are nigh-indestructible, providing you don’t dip them in the pool.

Right now, it’s pretty much a boutique technology, but that’s changing awfully fast. A low-end SSD can be cobbled together using a $21.95 Addonics 2.5″ adapter and a couple of CF cards. At the higher end, Toshiba announced an SSD with a whopping 128 GB of capacity, albeit at a yet-to-be-disclosed price, topped by BiTMICRO’s CES announcement of drives of up to 832 GB capacity in the fall. Apple’s also offering a 64 GB SSD drive as a (pricy!) option in its new MacBook Air.

Hooray for Amazon.com!

In one of those decisions that makes onlookers roll their eyes, the French courts have ruled that Amazon.com violated their law by offering books at too high of a discount when you factor in Amazon’s free shipping offer. Amazon.com was ordered to pay 1,000 euros/day fine unless they comply…and Amazon decided to just pay the fine and keep the free shipping.

Realistically, the French courts will likely just raise the fine to a level at which no company can keep paying it, but for now, I say, “Hooray for Amazon.com!”

Apple’s Macworld Announcements

I’m a nine-year Apple veteran myself, but having said that: Is it just me, or was anyone else incredibly underwhelmed by Apple’s product announcements today?

Like so many other tech guys, I freely admit I look forward to each Macworld with a fair amount of anticipation. I love taking a spin in the fabled Steve Jobs Reality Distortion Field™, checking out bold new design ideas, and seeing what at least one strongly opinionated company thinks will be the Next Big Thing for technology…

…but today, we got expensive online video rentals and a skinny, incredibly expensive laptop.

Sigh.

High-def Format Wars, Animated Cats, and the PS3

At this moment in time, it looks like Blu-ray has a leg up in the high-definition video format wars, particularly with news that Time-Warner had decided to switch to the format, and rumors afoot at CES that Universal and Paramount may soon follow. That said, I suspect all of us would rather declare somebody the winner so we could all enjoy better-looking movies at home without worrying we bought into the wrong format.

In addition to the “big war” of HD-Video vs. Blu-ray, however, it turns out that the manufacturers, in their wisdom, have also added a bunch of new interactivity features to each format—and now there’s concern that disks designed to use the features specified by the later “Profile 1.1” or “Profile 2.0” version of the Blu-ray format won’t work properly on players built around the earlier version of that spec.

Two things struck me about that article. First off, it’s apparently a good idea to buy a player which can be upgraded by flashing the firmware to add new capabilities. (I’d claim to be prescient in this regard, but to be honest, I really bought my PS3 to play Guitar Hero III and Rock Band—Blu-ray movie support was just a nice extra for me when making the purchase decision).

The second was how fantastically unexcited I am about the Java-based “interactivity” features which both the Blu-ray and HD-Video camps are willing to risk so much market confusion over. In my life, I have a pretty much perfect record of regretting the minutes I’ve spent with any client-side Java application, whether it involves animated cats jumping around in my browser, or some “interactive” feature launched by pressing the wrong button on my TV’s remote control. It’s always possible that someone will come up with an application which makes us all into believers on this score, but I haven’t seen it yet. I hate to say it, but when I’m watching a movie, I pretty much want to…well, just watch the movie. Sound and picture matter a lot to me when I do that. Interactive jumping cats…not so much.

But hey, since I’m currently doing my high-def movie-watching on a PS3, I guess I’ll likely be able to get my bouncing cats too. Yay.

The Less-Crazy Mythbuster on Tech Annoyances

(From Popular Mechanics)

He comes off as a tad cranky at times, but I definitely like his idea for modular rechargeable battery cells…