SQL Server 2016 Stability and Upgrade
Posted on 2016-08-18
We would like to take the leap from SQL Server 2008 32 bit to SQL Server 2016 x64 however, I have a couple of questions about the upgrade best practices.
1. Is it best to detach and reattach the databases from SQL Server 2008 32 bit to SQL Server 2016 64 bit? Or should we backup our SQL Server 2008 32 bit databases and restore them to the SQL Server 2016 64 bit instance?
2. How stable is SQL 2016? Is it even worth waiting for SP1 to come out?
3. Those using SQL 2016, have you found any upgrade issues or performance problems?
4. For SQL Vmware VMs do you make the drives containing the databases thin provisioned or thick provision eager zeroed?
-Current server version: Windows server 2008 64 bit with SQL Server 2008 32 bit.
-Future server version: Windows server 2012 R2 64 bit with SQL Server 2016 64 bit.