News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to check the nativ...

Finance | Project Operations, Human Resources, ...

Unanswered

How to check the native SQL Server version of the AX DB

(1) Share

Report

Report

Posted on by Eth60

2

Our AX 2012R3 is very slow.

One of our partner specialized in AX performance said that we should check the native SQL Server version of the DB and stay with this version in the "compatibility check" not put the version of the current SQL Server engine. Because they notice performance issues at this level

How can i check the original DB version with queries ?

Categories:

Microsoft Dynamics AX

All responses Img

All responses (2)

Answers Img

Answers (0)

Anton Venter 18,788 Super User 2024 Season 2 on at

Like (0)

Report
How to check the native SQL Server version of the AX DB

That doesn't make any sense. Since when is it slow? Is this new? The reasons it's slow could be a lot of things and might not even be the database. It could be a faulty storage device or network interface. To be sure it's not the database though, someone with database performance experience has to connect to the SQL Server (when the performance is bad) to see what's going on. It could be missing indexes, incomplete or missing database maintenance, bad queries etc. etc. The daily database maintenance jobs must run every day.

Get the SQL version with TSQL:

SELECT @@VERSION
Martin Dráb 230,503 Most Valuable Professional on at

Like (0)

Report

How to check the native SQL Server version of the AX DB

I'm not sure that I understand. You seem to be talking about the Compatibility Level of a database, where native means the version of your SQL server. But you're saying that you want the native but not the current, which doesn't make sense to me.

Don't they mean you should use a lower compatibility level than the native?

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans