<div>
<div class="content wysiwyg-content">
We would like to take the leap from SQL Server 2008 32 bit to &nbsp;SQL Server 2016 x64 however, I have a couple of questions about the upgrade best practices.<br />
<br />
1. Is it best to detach and reattach the databases from SQL Server 2008 32 bit to &nbsp;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?<br />
<br />
2. How stable is SQL 2016? Is it even worth waiting for SP1 to come out?<br />
<br />
3. Those using &nbsp;SQL 2016, have you found any upgrade issues or performance problems?<br />
<br />
4. For SQL Vmware VMs do you make the drives containing the databases thin provisioned or thick provision eager zeroed? <br />
<br />
Thanks<br />
<br />
-Current server version: Windows server 2008 64 bit with &nbsp;SQL Server 2008 32 bit.<br />
-Future server version: &nbsp;Windows server 2012 R2 64 bit with &nbsp;SQL Server 2016 64 bit.
</div>
</div>


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.

SQL Server 2016 Stability and Upgrade

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.