Skip to main content

Posts

Showing posts with the label sql server 2012

Sharing Tips quickly for Performance Improvement for Axapta

Top Tips for Ax 2012 Performance improvement. I am sharing This clip will show you Top 10 tips for SQL performances on Ax Quickly. 1. How to Check Client and Server configuration of ax 2012. 2. Check memory setting options for SQL server databases. 3. Regular checking of Disk size is required. 4. Regular Cleanup of log data from ERP. 5. Client Usage data cleanup at ax side. 6. Index optimization(use include column option in index) and new index creation at Ax. 7. Reindexing and Rebuilding Indexes. 8. Use set based operations is required to improve the performance of execution of logic. insert_recordset , update_recordset and delete_from 9. Check batch jobs running sequences on Ax side. 10.Don’t create indexes directly on SQL for Axapta. Visit below clip to get practical knowledge for the above points. If you like this video do not forget to subscribe that channel.