Skip to main content

SQL Server Licensing

As part of my current project I’ve spent some time over the past couple of months trying to determine the best (cheapest) SQL Server configuration to support web servers running in a virtualised environment. As a quick disclaimer, the following are my thoughts on the subject and should be used as guidance for further research only!

Firstly you need to figure out whether you are going to license using the “per user” or “per processor” model. For most typical configurations a “break even” point can be determined when it becomes cheaper to switch to the per processor licensing model instead of the per user model. It is important however to plan for future growth as it can be very expensive to try and switch from one model to another once a system has been deployed. It is not possible to convert SQL “user” CALs into a processor license.

If you are developing a web application that will be exposed via the internet to external customers then it would probably make sense to use the web edition, which only comes with “per processor” licensing. The Microsoft definition of what is a user is critical when selecting the web edition as this can not be used for intranet based applications used by company employees. See the licensing section for more information.

To aid in the selection of the correct edition Microsoft have put together the following SQL Server 2008 Comparison Table

It is also worth considering the environment that is going to host the SQL Server instance? If you intend to host SQL Server in a virtualised environment things can quickly become confusing and potentially (yet again) expensive.  Even the Microsoft FAQ on SQL Licensing appears to contradict itself – the answer to the question “What exactly is a processor license and how does it work?” appears to state that you only need to buy a license per physical processor even for virtualised environments.  However, the answer to a later question “How do I license SQL Server 2008 for my virtual environments?” then contradicts this by giving a more detailed answer highlighting that in a virtualised environment the definition of the “per processor” model changes depending upon which edition of SQL Server you have purchased.

You then need to dig around the Microsoft site a little more to investigate the licensing model a little more – the Licensing Quick Reference PDF provides a lot more information from page 3 onwards.  I won’t duplicate the information held in that document, because if nothing else it may be updated over time but it is worth noting the differences in Data Centre / Enterprise editions and Standard edition. For the standard edition the document then moves on to describe the formula that should be used to determine the number of per processor licenses that should be purchased for each virtualised instance of SQL Server. At the time of writing you divide the number of virtual processors with the number of cores on the physical processor (rounding up) to get the number of SQL licenses needed. This does mean that if you have a 4 core physical CPU and you expose each core as a virtual CPU to the instance of SQL Server, you still only need one “per proc” license. A common misconception is that you must have a “per proc” license for each virtualised CPU exposed to SQL Server, but this hopefully clears up that potentially costly misunderstanding.


Popular posts from this blog

Mocking HttpCookieCollection in HttpRequestBase

When unit testing ASP.NET MVC2 projects the issue of injecting HttpContext is quickly encountered.  There seem to be many different ways / recommendations for mocking HttpContextBase to improve the testability of controllers and their actions.  My investigations into that will probably be a separate blog post in the near future but for now I want to cover something that had me stuck for longer than it probably should have.  That is how to mock non abstract/interfaced classes within HttpRequestBase and HttpResponseBase – namely the HttpCookieCollection class.   The code sample below illustrates how it can be used within a mocked instance of HttpRequestBase.  Cookies can be added / modified within the unit test code prior to being passed into the code being tested.   After it’s been called, using a combination of MOQ’s Verify and NUnit’s Assert it is possible to check how many times the collection is accessed (but you have to include the set up calls) and that the relevant cookies have …

Do "Task Hours" add anything in Scrum (Agile)?

What do task hours add to the overall process in scrum?This was a question that has arisen from all team members in both instances that I've helped teams switch over to scrum. The benefits of artifacts like the comparative story point estimation, the 2 week sprints, stand-ups and the end of sprint demo have been self evident to the team, but as one I think every team member has expressed dismay when it comes to task planning and estimating each task in hours. Left unchecked there is a natural tendency for people to actually begin to dread the start of each sprint purely due to the task planning session.In my current role we've been lucky to investigate this further as a team.The team sat down to discuss the problems it was experiencing with estimating tasks in hours and the following common themes appeared:It is hard: Maybe it shouldn't be, but time estimation is hard! Story points are comparative and abstracted making them easier to determine, but time estimate is gen…

Why do my Android Notification only appear in the status bar?

I'm definitely getting back into Android development, I'm remembering that feeling of 'Surely this should be easier than this!'. All I wanted to do was to schedule a local notification which behaved similar to a push notification pop-up. That is, as well as showing the small icon in the status bar I wanted it to pop up on screen to notify the end user. All seems fairly easily, I found this code for how to schedule a notification. That all worked perfectly, apart from the notification would only appear in the status bar. Searching around I found loads of different answers / solutions, mostly all saying the same thing:It only worked if you used 'NotificationCompat.Builder' in place of 'Notification.Builder', orYou had to set the priority to 'NotificationCompat.PRIORITY_HIGH'As usually happens, none of these solutions worked for me until I added in the missing piece of the jigsaw:- '.setDefaults(Notification.DEFAULT_ALL)'. For me this…