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.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
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 (18.104.22.168) 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 22.214.171.124 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!
Hello! We have updated our database to SP2 CU17 and so far everything works ok. But now Microsoft asked us to update our SQL DB to SP3, because of some tools included in SP3 for optimizing database. Is this still safe? Can we expect any problems after update? What about support? Will MS CRM support team complicate about raised support cases?
We just want to be sure updating to SP3 is still supported by Microsoft. Application version is still the same as it is written in my first question.
Simplifying, our product officially supports any higher SP update on SQL that is not documented.
So in this case yes, SP3 is supported.
This because CRM team does not have the plan to test all upcoming SP's or CU's for SQL.
As long as we respect major versions and minimum SP's, that is fine.
If any weird problems occur, we should be able to help.
In a side note, general best practices on SQL is to keep legacy cardinality estimation ON (in case you move compat mode to 130) and use maxdop = 1.
Thank you, Pedro! You helped me a lot with all provided information.
Business Applications communities