Microsoft has officially released new SQL Server 2016 on June 01 2016 for public to download and install it on their development, test or production servers. It is important to test the applications thoroughly before moving to production environment, as there may be some changes required to the application to work seamlessly. If the application is vendor application, then contact the respective vendor and get approval to use new SQL Server 2016, most times, vendors releases new version of the application which works fine on new versions of SQL Server. Although, installing and using SQL Server 2016 is straight forward, but important to take care of things prior to install to ensure no hiccups later for the installation process. SQL Server 2016 has a critical pre-requisite for updated Visual Studio VC++ 2013 Runtime Libraries. To install or check if this update is required on your system, refer KB316398 for further information.
Review SQL Server 2016 system requirements – Memory Minimum requirement for Express Editions is 512 MB, All other editions: 1 GB, however recommended for Express Editions is 1 GB and for All other editions is at least 4 GB and should be increased as database size increases to ensure optimal performance. Processor speed required minimum is x64 Processor: 1.4 GHz, however recommended is 2.0 GHz or faster. Type of x64 Processor is AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support. Important point to note is SQL Server 2016 is supported on x64 processors only. It is no longer supported on x86 processors. WOW64 is not supported for SQL Server 2016. Review SQL Server release notes – check the release notes of SQL Server before installation to get all the details.
Download and install full-featured software for a 180-day trial edition or buy a licenseed edition for production environments and developer edition for development purposes. We may also choose to use express edition based on our requirement, if we are not using all features.
Make sure the account which used to RDP to the server has administrative rights on the computer to install SQL Server 2016. We will have SQL Server 2016 DVD Image or ISO file for the installation.
The Microsoft SQL Server 2016 release is available for testing purposes only and should NOT be installed and used in production environments.
Side-by-Side installation with down-level production SQL Server instances as well as in-place upgrades of down-level production SQL Server instances, is supported for SQL Server 2008 and higher.
If you have questions or concerns that come up during your testing and evaluation, we encourage you to use the MSDN forum for SQL Server 2016 to search for answers or ask new questions.
Hope this was helpful.
This is applicable for below versions of SQL Server
SQL Server 2016
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings