web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Can we use SQL Server ...

Small and medium business | Business Central, N...

Suggested Answer

Can we use SQL Server table compression and partitioning with Microsoft Navision 2017?

(1) Share

Report

Report

Posted on by MG-05110758-0

Hello,

We would like to use SQL Server table compression and partitioning for Navision 2017 [Change Log Entry] table.

Is this supported? Did anybody implement this in Nav 2017 successfully? Can this break later changes in Navision?

PS:

Only found support statement for Nav 2018/19: https://community.dynamics.com/blogs/post/?postid=e1bc0587-6fe0-4211-b913-0f332f7dd1a9

Categories:

Microsoft Dynamics NAV

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Gerardo Rentería Ga... 25,127 Most Valuable Professional on at

Like (1)

Report

Hi

I hope this can help you and give you some hints

Why you should upgrade to MS SQL Server 2017 if running NAV or BC onPrem – DOAL Konsult AB

SQL Server Performance with Business Central | Roberto Stefanetti Business Central Blog

Best

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,311 Super User 2025 Season 2 on at

Like (0)

Report

As far as I know this is supported, but it may affect performance when the amount of data is large. It is recommended that you test it in a test database before trying it in a production environment.

Thanks

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 3,177

#2

Jainam M. Kothari 2,467 Super User 2025 Season 2

#3

YUN ZHU 1,435 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans