Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

compatibility Level of MS Dynamics SL 2015 SYS database

Posted on by 150

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?

  • HolliV Profile Picture
    HolliV 235 on at
    RE: compatibility Level of MS Dynamics SL 2015 SYS database

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: compatibility Level of MS Dynamics SL 2015 SYS database

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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: compatibility Level of MS Dynamics SL 2015 SYS database

    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.

  • REUser Profile Picture
    REUser 150 on at
    RE: compatibility Level of MS Dynamics SL 2015 SYS database

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: compatibility Level of MS Dynamics SL 2015 SYS database

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans