We are planning to host the Future database on SQL Server 2012 (x64) with SP1 on Windows Server 2012 (x64) operating system, and would appreciate your advice, whether it is the right thing to do?
I look forward to hear from you.
Note:
1. Currently the database is hosted on SQL Server 2005 (x64) with SP4 on Windows Server 2008.
2. Initial plans were to migrate to SQL Server 2008 R2 (x64) with SP2 on Windows Server 2008 R2.
-----------------------------------------------------------------------------------------------------------------------------------------------------
I do not have sufficient detailed knowledge to make a recommendation one way or the other. What I can do is give you a bit of information about how FUTURE uses the database that might help you decide.
FUTURE uses very standard SQL syntax, so it would not make direct use of any new features that are exclusive to 2012.
FUTURE uses multiple threads for the background writing of data and it now adjusts the number of these threads (typicallly between 5 and 30 per FUTURE session) to whatever gives the fastest performance. So if SqlServer 2012 gives better performance of parallel operations, you might see an improvement.