Performance issues in AX can be some of the most difficult to troubleshoot. Particularly as there's so many different areas which can potentially be the cause/solution to the issue. This post will just talk about one of the potential causes of bad performance, no doubt we'll cover some more performance issues in later posts.One of the common causes of bad performance is memo (in the database - ntext) fields. Unecessarily selecting memos can cause performance degredation. The business users often insist that they need the field to be so large that memo type is required, but in reality the length is rarely used. So I've created a bit of SQL which checks through a database, finds all tables with memo columns and details the length of the largest value in that field and also the total number of records in the table. This can give you the data you need to decide whether the memo field is a problem and whether is can be changed to a string (in the database nvarchar) of up to 1000 characters instead.