Record count of tables in AX

Sometimes we need to track the record counts of tables in AX.  The fastest way is creating a query in SQL Server Management Studio.

USE Dynamics

GO

SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count

FROM sys.dm_db_partition_stats st

WHERE index_id < 2

ORDER BY st.row_count DESC

GO