Consistency Check - DBCC CheckDB

(0) Share

Report

Posted on by Community Member

Good day.

Hi Experts,

Hope you all are doing great everyday.

May I ask your assistance/opinions about consistency check in MSDAX 2012 R3. Is it the same with DBCC Check DB in SQL or is there any command from SQL that will have the same result for consistency check in AX? Because as of now, we are trying to run it but around 4 days it is not yet finished at all and I think it is looping only. Is there any substitute for this? I hope you get me.

Thank you in advance. Hoping for a positive response to all of you guys.

Raph

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

Hi Raph Dumape

you can select a specific module from a specific date.

this function different check in SQL server

you can use consistency check in MSDAX 2012 R3 to check or fix the error (correct error)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahmoud,

I already specified the module but still not finish. I run Sales Order last week Thursday. There is no error in evnet logs. It's just running and no results generated.

Thanks,

Raph

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

what about performance in AOS and DB server?

this is not normal.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahmoud,

This is currently running on one of our test servers. AX is deployed in a single server. I understand that the resources is not achieved since it has limited RAM and CPU. But it is running for 4 days. That is my concern, whether my servers are slow I think it should be able to run the consistency check.

Thanks,

Raph

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

I face the same problem before, after investigation I found database locked

so you can run sp_who2 active to check all active process in your database

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahmoud,

Thank you for this but as per checing there is no blocking/locking in the database.

Thanks,

Raph

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (2)

Report

Let me clarify the confusion here, because you guys are talking about two very different topics.

AX consistency check is only for a small subset of AX-based tables to validate if there are no broken record references, or if values add up like in Inventory on hand based on the transactional data, etc. It is a limited functionality to check if something is wrong with transactions.

DBCC CHECKDB on the other hand is for verifying the integrity of the SQL database and log files, and should be executed regularly to find corrupt data pages, and so on.

docs.microsoft.com/.../dbcc-checkdb-transact-sql

If it is running slow, blame your under-sized or incorrectly configured environment.

As the documentation clearly explains, you need either a large amount of RAM, or if you do not have that, properly sized and fast-performing TempDB database (multiple TempDB data files, files being spread across multiple fast-performing disks with dedicated I/O controllers/paths).

We have a 2 TB size AX database sitting on a mix of SSD and HDD tiers depending on where the cold data is. There are 8 x 12 GB TempDB data files spread across 2 disks sitting on our SSD hot-tier, SQL Server 2014 having 256 GB RAM, and it takes 10 hours to complete this command:

DBCC CHECKDB ([AXDB]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY

Also as per this article, SQL Server 2016 has a great boost for this area as well:

https://www.mssqltips.com/sqlservertip/4437/faster-dbcc-checkdb-with-sql-server-2016/

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

Please mark helpful answers with the checkbox next to each post to resolve the thread, thank you.

Was this reply helpful? Yes No