• Home
  • My Favorite Topics
    • Blogging
    • Business
    • Career
    • Cars
    • Consulting
    • Epic Life Quest
    • Iceland
    • Marketing
    • Presenting
    • Productivity
  • My Life Quest
    • Future Achievements
  • About Me
  • My Recent Photos

Good News About SQL Server Standard Edition’s Limits

9 years ago
microsoft, SQL Server
39 Comments

I got in a lot of trouble when I wrote that SQL Server 2014 Standard Edition Sucks.

That post generated a lot of public discussion, and it also generated a lot of private ill will for me. I heard from several Microsoft folks who were downright angry. How dare I voice an opinion like that? I even heard from MVPs who told me I shouldn’t criticize Microsoft in public, only in private.

I didn’t back down, and I didn’t apologize. I believed in the post, and I never heard anyone arguing that Standard should indeed be capped at $500 of memory. And amazingly, I’m still an MVP.

SQL Server 2014 Standard Edition Limits
SQL Server 2014 Standard Edition Limits

Good news: Microsoft marketing heard our cries, and raised SQL 2014 Standard Edition’s limit to 128GB (or at least, the latest Books Online pages read that way.)

I don’t know if my blog post had anything to do with it, but I do know a lot of folks who have been quietly and politely raising this issue for years – long before SQL 2012 came out – and we haven’t seen any relief.

I like to think of my blog post as an act of civil disobedience – raising awareness of an important issue for DBAs. I’d like to challenge you to do the same. When you believe in something, talk about it. Fight for the things that matter to you. Consumers have a bigger voice than ever before, and what you think matters.

Yes, there’s going to be haters who tell you to be quiet and do as you’re told. You have to learn how to handle the haters. Life is too short – get out there and make a difference. Build things. Help people. Someone’s always going to complain about your methods, but you have to stand up for yourself and your beliefs.

microsoft, SQL Server
Previous Post
Using an HD Camcorder as a Mac Webcam (Updated 2018)
Next Post
Book Review for Presenters: The Story-Teller’s Start-Up Book

39 Comments. Leave new

  • paulpopovichjr
    March 12, 2014 2:00 pm

    I’m so happy about this news. And so sad I have no SA on my newly built 2012 cluster.

    Reply
  • Kevin Boles
    March 12, 2014 2:02 pm

    This would indeed be SUPER knews for the 9x% of installed SQL instances that are NOT enterprise edition! I have been bringing this up at virtually every user group/SQL Saturday I present at for a long time. I even mention it as the WORST thing NOT changed in SQL 2014 in my presentation on SQL 2014 New/Enhanced Features.

    I sincerely hope they back-fill this increase to at least SQL 2012, but I wouldn’t at all be surprised if they didn’t because it is such a HUGE (almost ONLY really useful) carrot to get the Standard Edition users to upgrade to 2014.

    Reply
    • Brent
      March 12, 2014 2:03 pm

      I do like this as a carrot to get Standard Edition folks to upgrade. That’s a great angle.

      Reply
      • Bobby Rentfro
        March 17, 2014 1:28 pm

        The best argument I have when arguing to use Enterprise Edition is that Standard Edition won’t multithread DBCC CHECKDB. The business typically comes around when I tell them their maintenance cycle will be 4 times longer without Enterprise Edition.

        Reply
        • James Fogel
          May 20, 2014 1:40 pm

          And then they go back around after they see how much Enterprise costs!

          Reply
  • Ameena
    March 12, 2014 2:39 pm

    This is a great news. But I am sad to see that there are some MVPs who will not bring up something wrong with SQL server product. I think it is their duty to inform community about the pros and cons and not only pros. Good job Brent.

    Reply
    • Brent
      March 12, 2014 2:51 pm

      Thanks, Ameena!

      Reply
    • Allan Hirt
      March 12, 2014 9:47 pm

      Not all MVPs are silent. I’m outspoken and critical publicly when I need to be, but there are many “battles” behind the scenes that I don’t air publicly, either. Bottom line is that MS does listen even though people think they don’t. Whether or not they do what you want is a different story.

      Reply
  • Steve Hood
    March 12, 2014 6:31 pm

    WHAT??? They managed to keep the memory limited to what you can get on a $100 SD Card? Am I still limited to making sure my tables are indexed, forced to learn about SARGability, and write out my column names instead of using *?

    Seriously, thank you for making this subject so public. Microsoft could never give you credit for it, but I’m sure you helped influence their decision.

    Reply
    • Brent
      March 12, 2014 8:39 pm

      Awww, thanks Steve!

      Reply
  • ishtiaq ahmed
    March 12, 2014 9:47 pm

    Nice!! Too bad they didn’t do the same on the CPU side

    Reply
  • Barry Rawlings
    March 13, 2014 6:57 am

    On that MSDN page there is a typo for either the amount of memory SQL Server standard edition allows or the amount of memory the database engine in BI edition allows. They’re the same database engine install so either they’re both 64GB or both 128GB.

    Reply
    • Brent
      March 13, 2014 7:19 am

      Barry – so you’re saying BI and Standard will have the same limits in 2014 just because 2012 did?

      Reply
  • Andrew Notarian
    March 13, 2014 8:19 am

    Having just watched the first episode of Cosmos twice, I would encourage everyone to question everything.

    Might the decision have been based on a survey of the installed base of SQL Server? To make Enterprise Edition reflect the upper crust specs of the already installed base? Until recently I was at an organization that limited all VMs to 16 GB. In that environment they would just let a thousand Standard Editions bloom.

    Reply
  • Ray
    March 13, 2014 9:57 am

    Thanks for posting about this Brent. My 128GB servers will be happy to hear the news as well.

    Reply
  • Dan Gras
    March 13, 2014 3:49 pm

    Thanks Brent for your original post. That is great news.

    Reply
  • (SFTW) SQL Server Links 14/03/14 • John Sansom
    March 14, 2014 4:45 am

    […] Good News About SQL Server Standard Edition’s Limits – Brent Ozar (Blog|Twitter) […]

    Reply
  • Endrju
    March 14, 2014 11:12 am

    And it looks like they didn’t remove Database Mirroring? It was deprecated, but somehow survived. At least it is listed under HA section.

    Reply
  • Endrju
    March 14, 2014 11:18 am

    Buffer Pool Extension goes to people who can already have lots of RAM, I mean it’s only in Enterprise Edition. That’s not logical 🙂

    Columnstore also only EE.

    Reply
    • sqlbattsman
      March 17, 2014 7:53 pm

      The same page has also been updated to show Buffer Pool Extension available for EE, BI, and Standard

      Reply
      • sqlbattsman
        March 17, 2014 7:58 pm

        Check that… it says Yes for BPE under scalability and performance, and No under RDBMS Manageability. Clearly still a living document and not reliable until SQL Server 2014 actually releases RTM.

        Reply
  • Chuck Lathrope
    March 14, 2014 11:30 am

    It would be awful if BI edition was limited to 64GB of RAM also. I personally think it shouldn’t be limited in BI edition, as it is a step up from standard. If Microsoft wants to compete more in BI world, they need to remove barriers for smaller companies.

    I think this thought should also go towards SQL Express. If Microsoft wants to compete with MySQL and other open source DBMS’s, they need to increase the limitations of 10GB DB size and 1GB of RAM. I think it is a joke that it is limited to this size.

    Reply
  • Randolph West
    March 17, 2014 10:49 am

    I’m a bit late to this party. If you had anything to do with this change, I owe you a beer.

    Heck, I’ll buy you one anyway.

    Reply
    • Brent
      March 17, 2014 1:13 pm

      DEAL!

      Reply
  • Derek Steinmetz
    March 17, 2014 1:10 pm

    Is there anyway to verify if this is just a typo or if this is truly legit? This would make the move from Enterprise to Standard a lot easier pill to swallow.

    Reply
    • Brent
      March 17, 2014 1:13 pm

      Prior to a few days ago, it read 64. Seems like an awfully curious way to introduce a typo. 😉

      Reply
      • Derek Steinmetz
        March 18, 2014 10:55 am

        I did find this in the release notes:

        3.1 Changes made for Standard Edition in SQL Server 2014 RTM
        SQL Server 2014 Standard has the following changes:
        The Buffer Pool Extension feature allows using the maximum size of up to 4x times of configured memory.
        The maximum memory has been raised from 64GB to 128GB.

        http://msdn.microsoft.com/en-us/library/dn169381(v=sql.15).aspx

        Reply
  • Peter Schmitz
    March 18, 2014 3:37 am

    Nice going, Brent. Regardless of whether or not your post had anything to do with it, good on you that you spoke up about something you disagree with.

    The way I see it, it’s our job as consultants to help our customers get the best possible product for their needs and budget. That means you advise them without bias, and highlighting both the good as well as the bad. That’s the only way a customer can get to an educated decision.

    If the only way one could/would be allowed be be a Microsoft MVP was by never criticizing, it’d instantly undermine every MVP’s title. Good to see MS didn’t remove you as an MVP for speaking out.

    Reply
  • sean
    March 18, 2014 9:23 am

    So great they are vtaxing us like VMware. Hey Microsoft how about dont pull a move like Vmware did you think you would have learned. Ppl dont buy enterprise for just using ram lets be frank. Availability groups is why you go enterprise in my opinion. vtaxing me on ram is just assine in my opinion even if they bumped it up. Stop being stupid Microsoft compete on feature set not on hardware use and all your customers will probably be alot happier.

    Reply
  • Ron Sexton
    March 19, 2014 12:30 pm

    This is a start in the right direction and thanks for providing the news and any impact you may have had on this.

    Another issue to me is the per core license. All servers have a boat load of cores these days which makes this tricky as many times you may need the memory and faster processors but not that many cores. And then the licensing for all those cores is expensive. This and a few other things (some not SQL Servers fault probably) are causing my company to look more at Oracle.

    Reply
    • Brent
      March 19, 2014 12:31 pm

      Ron – they only have a boat load of cores if you buy ’em that way. (I’m specing out brand new quad-core servers as we speak for a client, heh.)

      Reply
  • Ron Sexton
    March 19, 2014 2:58 pm

    Aren’t you the one that sent out that advert for the new monster 6TB memory 15 core xeon servers? 🙂
    How much memory do those servers max out at?
    We most by HP servers in our area.

    Reply
    • Brent
      March 19, 2014 3:07 pm

      And I make commission on all the RAM you buy. 😉

      Reply
  • Ian
    March 26, 2014 10:18 am

    I can see a lot of independent software vendors continuing to move data access to memcache rather using in memory tables, as you always have some customers with standard edition. Having to have different code depending on the edition of sql server a customer has is not pleasant and tents to lead to enterprise edition features being ignored.

    The level of discontented over not being able to make use of new capabilities in SQL server are leading a lot of .NET software engineers to lose interest in learning about new versions of SQL server.

    One day SQL server will stop being the default choose of .NET developers for data storage, when it happens Microsoft will lose one of their money printing machines.

    Reply
  • Rob Risetto
    March 31, 2014 2:27 am

    Hey Brent can you also complain about not having the ability to configure a 2 x node cluster with an Availability Group in Standard Edition. This would have been another great incentive to migrate.

    cheers Rob

    Reply
  • 128Gb DDR4 RAM Module
    April 7, 2014 5:45 pm

    […] even after Microsoft ups the SQL 2014 RAM limit, you still looking at 1 stick of RAM before you hit the limit. Darn, there goes my plans of maxing […]

    Reply
  • Microsoft SQL Server 2014 Standard Edition licensing changes makes it less attractive to SMBs » Martin DENIZET
    April 8, 2014 2:57 am

    […] 128GB(raised after protests) […]

    Reply
  • Javier
    August 22, 2015 5:10 am

    Hi Brent, thanks for the information. I would like to ask you a question about limiting MSSQL Server memory. Is there any recomendation from Microsoft to limit maxsize memory in MSSQL(2012) or choose unlimited memory in the parameter? Because I need to find official information from Microsoft about what it is better. Thank you very much for your time.

    Reply
    • Brent
      August 22, 2015 10:24 am

      Javier – this blog post is about SQL Server 2014. You’re asking a question unrelated to the post, on a stranger’s blog. This isn’t the best way to get quick, accurate answers.

      Instead, check out Q&A sites like http://dba.stackexchange.com. This way you can get quick, accurate help from whole communities. (I’d rather teach you how to fish than give you a fish.) Hope that helps!

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Hi. I’m Brent.

That's me, Brent.

I live in Las Vegas, Nevada. I'm on an epic life quest to have fun and make a difference.

I co-founded Brent Ozar Unlimited to help make your SQL Server go faster. I also maintain sp_Blitz® and the open source First Responder Kit repo.

My current car collection includes a Jaguar XKR-S, Porsche 944 Turbo, Porsche 356 Speedster replica, and a Ferrari 328 GTS.

profile for Brent Ozar on Stack Exchange, a network of free, community-driven Q&A sites

© 2021 Brent Ozar, all rights reserved. Privacy Policy

  • Home
  • My Favorite Topics
  • My Life Quest
  • About Me
  • My Recent Photos