asked on SQL Server 2016 Stability and Upgrade
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?
Thanks
-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.
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?
Thanks
-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.
Microsoft SQL Server
Last Comment
CityInfoSys
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks