...performance tests in Dynamics AX, you often want to clear the SQL cache so you can be sure that all data must be re-read from thedisks. If you want to clear the SQL cache, execute these 3 lines in a query window: CHECKPOINT DBCC DROPCLEANBUFFERS...
http://axaptafreak.blogspot.com/