When trying to troubleshoot issues, a common request from Microsoft support and from partners is to run a DexSQL log. A DexSQL log is a file that logs commands made from Dynamics GP to the database to help understand performance issues. After creation, this file is sent to the company's partner or to Microsoft for assistance in troubleshooting.
When creating a DexSQL log, the key is to capture only the amount of data related to the problem. In this recipe, we will look at creating a DexSQL log to provide more information to Microsoft support.
For our example, we will assume that the problem relates to creating a financial batch, so that is the process that will get captured in the DexSQL log.