SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Standard Limitation

By Steve Jones,

Is 64GB of RAM enough for a SQL Server instance? It was in the past for most servers that I've developed software on or administered. These days I know some people have 2TB of RAM in their big database servers, which makes 64GB seem paltry. After all, I've had 32GB in a laptop before. However I know most of the SQL Server databases out there, in absolute numbers, are fairly small. In the low GB in size. I'd think 64GB isn't too much for these.

The reason that number comes up is that it's the limitation for SQL Server's Standard Edition (SE), and apparently, it's my fault the number is set so low. Not just my fault, but all of you out there that keep buying SQL Server licenses. I'm not sure I agree with Brent's verbiage, but I do agree with his conclusion. As long as SQL Server sells, and it's selling well, why wouldn't Microsoft push people to buy Enterprise Edition and pay more to use larger servers?

Personally I think we should be charged by the scale of the system we use, rather than this weird, limited feature/scale list that MS has. They could easily say that SQL Server is $2000/core and $500/4GB. They could play with the numbers and come up with something that might be cheaper for some, more expensive for some, but it would allow us to easily buy more capacity and pay more as we needed to add hardware.  That's how the cloud works, and even how many of our virtualized systems work. Want to move from 4 cores and 16GB of RAM to 16 cores and 64GB of RAM? Flip some switches. Depending on the version of Windows, you might not even need to reboot.

I know some of you think SQL Server should be $5000 and we put it on any size hardware we like, but that's certainly not going to happen in today's world. We tend to value computing resources by scale, and I think that's a reasonable way to examine software. 

Total article views: 379 | Views in the last 30 days: 1
Related Articles

Scaling Out

Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?


Scaling Out

Steve Jones likes Service Broker as a scale out technology, but it hasn't caught on. He thinks more ...


Scaling SQL Server

On Friday, October 14, 2011,  I had the pleasure of delivering my new Scaling SQL Server presentatio...


Small Scale SQL Server Deployment

Everyone seems to focus on the large scale, enterprise level installations of SQL Server with not a ...


Scaling out SQL Server 2005 article

This article appeared just recently on MSDN: Scaling Out SQL Server 2005 It's a relatively h...