Join Martin Guidry for an in-depth discussion in this video Choosing an edition, part of SQL Server 2012 New Features.
SQL Server 2012 is available in several editions. The Enterprise edition remains the top shelf edition containing every possible feature, but also the highest price tag. By researching the features of different editions, you might be able to find all the functionality you need in a lower-priced version. The Microsoft website is certainly the best source of information for details on what features are included in what version. The amount of information presented here can be a bit overwhelming.
I would like to walk you through some of it and point out some of the most popular features and what versions they are available in. Also should make a note that I am giving you information that is up-to-date as time of this recording, but Microsoft does tend change these things from time to time, in particular whenever they release a service pack for SQL Server. They often make minor changes to what features are available. With SQL Server 2012, Microsoft is primarily marketing three editions: Enterprise, Business Intelligence and Standard.
Enterprise and Standard have been around for a while but Business Intelligence is new in 2012. We can scroll down here and see some of the capabilities, some of the features that are included, and as we scroll down we will see a bullet point in every single box or enterprise. Like I said it contains every single feature, and we see slightly less features in Business Intelligence and Standard. Notice the features of basic Business Intelligence: Reporting, Analytics, Data Mining and Basic data integration are included in all three editions because they have one version named Business Intelligence you might think that Business Intelligence features aren't included in the other versions. That's not exactly correct.
The basic Business Intelligence, the basic reporting, the basic analytic server is included in all three versions. What Business Intelligence gives you, is a few advanced features that are not included in Standard such as Power View and PowerPivot. PowerPivot a very popular feature particularly among SharePoint developers. So that may be something that would push you to buy the Business Intelligence server. Also notice there's nothing in the Business Intelligence server that isn't in the Enterprise, so if you have access to Enterprise, there is no reason to downgrade to the Business Intelligence version.
Looking at some more detailed information, in particular information about the hardware, we will notice that the Enterprise version always uses the maximum CPU and maximum RAM supported by the operating system. And on the other end of the spectrum, Standard has some limitations on the number of CPUs we can use and the amount of RAM we can use. Currently that set to 16 cores and 64 GB. Now you might be thinking, hey right now that's a pretty beefy machine! 16 core, 16 GB of RAM is a pretty beefy machine by today's standards.
But remember you may be putting SQL Server in production for 5, 10, 15 years. Is that still going to be a beefy machine 15 years from now? I can't say for sure, how much RAM will be common 15 years from now. I'm betting it's a lot higher than 64 GB. So those limitations are more of a problem in the future than they are right now. Notice Business Intelligence has some limitations when you're running the database engine, but it ramps up to operating system maximum on the analysis services and reporting services piece.
The line on maximum relational database size is also interesting, 524 petabytes. That is very, very large. A petabyte is 1000TB, a terabyte is 1000 GB, so a petabyte is basically a million gigabytes. I have yet to see a database that is even 1 petabyte, so 524 petabytes would seem to be an overwhelming amount of information. Again it's hard to say that 10 or 15 years from now whether or not that'll still be a reasonable limitation, but also you notice Enterprise, BI and Standard all have the exact same limitations, so it's not something to consider one way or the other when purchasing.
We also have a line here for the licensing model. Notice that the Enterprise edition is only per processor or per core, the Business Intelligence edition is only available with licensing model of server plus client access license. But Standard edition is available with either licensing model. So when choosing edition, you also have to consider the different licensing models and we will get into those in detail over the next few movies.
- Choosing an edition
- Finding and downloading SQL Server 2012
- Using FileTables to enhance FileStream
- Searching unstructured data semantically
- Searching text
- Exploring the Watch, Quick Watch, and Quick Info windows
- Creating user-defined server roles
- Understanding the changes to replication
- Exploring new types of indexes and new options on indexes
- Accommodating changes to database structure