My dissatisfaction with SQL 2012 licensing
Hardware has been ever increasing in strength, but SQL licensing has not reflected this except for charging more money due to the per core cost. We are in the information and data collecting age and Microsoft’s scale limitations (http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx) for the versions of SQL might have been fine in the past, but they are not now.
Some examples of limitations that should change:
- 64GB limit on RAM for BI edition? How about 256GB, we are talking about BI right, it needs RAM, forcing us into Enterprise edition when we don’t need the extra features just makes us upset and angry with Microsoft.
- The core limitation on all editions save Enterprise would have worked pre SQL 2012, but if you actually asked a systems engineer or even a desktop support person, all these numbers are under current hardware specs being delivered as of 2012. I want to use express edition on a server for replicated read-only data, but I can’t buy a server with 4 cores. Minimum is 6-8. Therefore, I am forced to use MySQL. BI should be OS maximum, Standard 48 cores, Web 24 cores, and Express 16 cores.
- A 1GB memory maximum for Express is a joke. Phones have that much memory. 16GB is a more realistic number for 64 bit computing including reporting services.
- 10GB of storage maximum for Express? Please, my windows updates and driver storage take up more than 10GB. How about 1TB? At least this way you can compete with MySQL.
Speaking of MySQL, I am being forced to use it to lessen my licensing footprint as it is free, and don’t bring up the support costs involved with it as MySQL has matured and we have in-house expertise in it. Therefore, if the above changes don’t happen for Express, we WILL be moving to MySQL for our simple load-balanced database servers. And once we start on that track, I see management asking for more and more migration towards MySQL. Once the migration ball has started rolling, you won’t be able to stop it. And, by-the-way, MySQL support looks great on my resume, so I won’t fight it.
Please let the features of the editions of SQL speak more for our selection of the edition than the hardware. And if the Windows 2012 OS limitations are equally as restrictive, we will just move faster to open source solutions.
Don’t think I am a Microsoft hater, I have been using it for 22 years and want to continue using it as I am an expert in MS technologies.