<div>
<div class="content wysiwyg-content">
We are planning to upgrade sql version from sql 2012 to sql 2014. We have DB with the size of 220 GB and this DB is hosted on SQL 2012 but DB compatibility level is showing as 100 (sql 2008), I am not sure why our earlier DBA is not changed it to sql 2012 (110).<br />
<br />
Now we have to host above DB on sql 2014 environment (RTM version) and we have to change the compatibility level to 110 or 120 (sql 2012 or sql 2014).<br />
<br />
One of our team member said that we may face performance issues in sql 2014 because of new cardinal estimator of SQL 2014 is not handling database well. Is it true?<br />
<br />
Please share your comments and suggestions on this.<br />
<br />
Please note that, we are using crm 2016 and we have to apply sql 2014 RTM version NOT SP1 because SP1 is not compatible with CRM 2016.
</div>
</div>


We are planning to upgrade sql version from sql 2012 to sql 2014. We have DB with the size of 220 GB and this DB is hosted on SQL 2012 but DB compatibility level is showing as 100 (sql 2008), I am not sure why our earlier DBA is not changed it to sql 2012 (110).

Now we have to host above DB on sql 2014 environment (RTM version) and we have to change the compatibility level to 110 or 120 (sql 2012 or sql 2014).

One of our team member said that we may face performance issues in sql 2014 because of new cardinal estimator of SQL 2014 is not handling database well. Is it true?

Please share your comments and suggestions on this.

Please note that, we are using crm 2016 and we have to apply sql 2014 RTM version NOT SP1 because SP1 is not compatible with CRM 2016.

SQL 2014 Performance issues+new cardinality estimator

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.

Microsoft SQL Server

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.