Another tool we can use to help to monitor and improve the performance of our DAX queries is SQL Server Profiler. This tool is installed as part of the SQL Server management tools and can be accessed directly from Windows or from within DAX Studio. SQL Server Profiler allows you to capture trace files that record events generated by an instance of the Analysis Services engine. Using the information it captures, you can do the following:
- Monitor performance.
- Debug queries.
- Find slow running queries.
- Test queries in development.
- Audit activity on an instance.
- Save data to a file or a SQL Server table.
If you want to use Profiler with an instance of Analysis Services, you will need to know some details about that instance, such as the name of the server it is running on.
As Excel Power Pivot and Power BI Desktop also use the Analysis Services engine, it...
