We have a Application upgrade to next version.
SQL Server 2014 is currently on SP1.
The upgrade pre-requisite is not necessarily SQL Server SP2.
But I feel and read the below link which says SQL Server 2014 has many fixes related to AOAG and some fix to SQL File stream.
I am stuck up in below situation:
My Manager asked do we really need to upgrade to SP2 as it is not necessary for upgrade .
He is little worried as this might be involved in little risk as they are PRODUCTION servers.
But I am sure Microsoft released the SP2 for some intention as this help the SQL Server 2014 performance.
I want to convey the same and make them accept the feasibility to apply the SP2 for our PROD servers ?
So do I really need to apply SP2 and how can I make them understand it helps ?