Link to home
Create AccountLog in
Avatar of CityInfoSys
CityInfoSysFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of CityInfoSys

ASKER

Thanks