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

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

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

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
gdrenteria 12,338 Most Valuable Professional on at

Like (1)

Report

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

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans