Service Pack 1 was recently released for MSSQL Server 2016. This seems a bit early for a version released less than half a year ago, but Microsoft has a reason for this.
Service Pack 1 was recently released for MSSQL Server 2016. This seems a bit early for a version released less than half a year ago, but Microsoft has a reason for this:
“With the arrival of MSSQL 2016 Service Pack 1, almost all Enterprise features that you can apply to a database are also available in the Standard edition”
This means that the difference between Enterprise and Standard has been given a different meaning. With the arrival of this Service Pack 1, a large number of options are possible, which previously required an expensive license. You can think of:
If you develop applications yourself, there are even more options, such as:
Enterprise is now a term for “large environments”. That is, Enterprise is now recommended if you need more than 128GB of memory for the MSSQL server, or if you need an advanced high-availability solution. Furthermore, certain processes in Enterprise edition can be executed in parallel, while in Standard these operations are executed serially.
Also, the restrictions on the number of processors for Standard have not changed. 16 logical processors (or 4 physical) is still the limit, but this restriction will be less of an issue.
For difference in the editions, please refer to https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?redirectedfrom=MSDN&view=sql- server-ver15 .
Suppose I now use MSSQL 2008 Enterprise and I want to go to MSSQL 2016 Standard, is this possible?
That depends on whether features are used that are only available as an Enterprise feature in 2016. If this is not the case, a downgrade is possible. Otherwise, a choice must be made whether the feature used will no longer be used.
Another point of attention is the available hardware; if more than 128GB is in use, this ‘extra’ memory can no longer be used in the standard edition.
A number of things are important for the upgrade to a higher MSSQL version, the most important question being whether your application supplier supports MSSQL 2016.
If this is the case, or if you are able to adapt the code so that your application works with MSSQL 2016, please contact us. Our consultants have extensive experience with migration processes and know all the points of attention involved.
DBA.nl is the all-round database expert specialized in setting up, maintaining and monitoring database environments. In addition, we provide advice and remove performance problems.
Since last June, we have switched to a working method based on customer teams within DBA.nl....
DBA.nl has launched a new service management system. The choice fell on Topdesk....
DBA.nl, the database experts, may continue to manage the database environment of RID de Liemers....