Deactivate Change Tracking on SQL server (Performance tuning)

MaW

Hi,
Have a customer with performance problems. They have a SQL consultant looking into SQL performance. He says that Change Tracking is activated on database, and that gives performance issues.
Can we deactivate Change Tracking on SQL database without problems for the running NAV 2018?
Are there any other areas to do performance tuning?

Thanks.

Haxiboy

Hello!

In Navision you can open the Change Log Setup.
You can either activate/deactivate the whole logging process, but you can edit which tables to log.



Or is this is the SQL server's builtin logging you speak of?

Regards,
Peter

RockWithNAV

@MaW - Can you provide some more detail please?

MaW

Hi,
It is the SQL servers built in logging I mean.
I tried to turn it off, but got an error trying to save changes on a table. So I guess deactivating Change Log SQL server side is off the table.

How to boost performance on NAV 2018, are there any rules of thumb to try if not looking into code at first?

wic

hi, it's an old post but, seems to be getting worse. With BC, same problem, the SQL change_tracking is consuming just... too much.
Any ideas?


https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-tracking-sql-server?view=sql-server-ver16