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,547 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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 98,242 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 2,055 Super User 2026 Season 1

#2

YUN ZHU 1,063 Super User 2026 Season 1

#3

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans