web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / compatibility Level of...
Microsoft Dynamics SL (Archived)

compatibility Level of MS Dynamics SL 2015 SYS database

(0) ShareShare
ReportReport
Posted on by REUser 162

We have an outsource dba looking into reasons why MS Dynamics SL 2015 CU1 is running slow on our new windows server 2012 R2 Standard and SQL Server 2014.  they suggests that we change the compatibility level of the sys to 120.

I read that for the CRM 2016 you don't want to set it higher than 110, and also the NAV versions.  I can't find anything on SL 2015 CU1.

The warning it gave for CRM 2016 setting higher than 110 is that the query optimizer estimates an incorrect number of records, which will result in poor performance.

Is there a preferred setting for Dynamics SL 2015 CU1?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Aloha, Page 8 from the Installation Guide for SL 2015 CU1 states the following: ...the system database and all associated application databases must exist within the same instance of SQL Server. Compatibility mode 100 is the default for new and upgraded Microsoft Dynamics SL databases.

  • REUser Profile Picture
    REUser 162 on at

    100 is the default, but can it be set higher like 120?

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi REUser,

    Unfortunately at this time it is not supported to be higher than 100 for SL 2015 (including CU1) databases. This may be changing in a future release.

  • Community Member Profile Picture
    Community Member on at

    When i run the database admin tools against the our 2015 cU1 databases,  it will change it back to 100.

  • HolliV Profile Picture
    HolliV 235 on at

    I'm curious.  Did you leave your SQL 2014 databases set to compatibility 120?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans