Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I've questions about SQL server for current CRM version (22.214.171.124) and related cumulative updates.
On the MS site is written that mentioned version of CRM supports Microsoft SQL Server 2016, Enterprise with Cumulative Update 2 (CU2). So I have following questions related to that:
I am trying to gather needed information, because probably we'll have to do an upgrade of SQL server. The documentation for our CRM version is not updated anymore, so I couldn't find the answers on internet. Probably someone has experiences with that and could help me out.
Thank you in advance!
Hope you are well.
Answering your questions in line:
Is it allowed to install cumulative updates for this SQL Server version?
Pedro: Yes. CRM team is not able to test all SQL cumulative updates. We simplify the compatibility by enforcing the boundaries of the Major SQL version, which on this case does allow you to Install any SP or CU higher on sql 2016 , above what the compatibility matrix suggests. The minimum builds are a strict requirement though, both on CRM and SQL.
Do the updates affect on support that is guaranteed by Microsoft?
Pedro: The above answer applies here. Updating SQL server 2016 to latest CU does not affect supportability on your crm v8. Specially since SQL team does complicate support when customers are not on latest SPs/CUs.
Will CRM work OK if we patch our sql server to version SQL 2016 SP2 CU17 without upgrading CRM application?
Pedro: Yes. Any problem that this may cause, should be discussed with SQL support first.
Can we expect any problems after upgrade?
Pedro: Expectation is that no problems will be created by the upgrade.
Note: Build 126.96.36.199 is known to hold a defect that may affect performance on "power users" since there is a table that keeps growing and affects these users forms loading and similar. If you need to know if you are affected by this please check the following SQL query:
Select len(RecentlyViewedXML) as size, objecttypecode, ownerid, s.fullname from userentityUIsettingsBase ujoin SystemUserBase s on u.OwnerId=s.SystemUserIdorder by len(RecentlyViewedXML) desc
If the top users show hundreds of thousands on length, you are affect and you should open a ticket with us for the mitigation.
The issue is resolved on builds 8.2.3 and above but there is a mitigation if the upgrade cannot happen.
Let us know if you require anything else around the topic.
Thank you for your answer. You helped me a lot!
Business Applications communities