Forum Discussion
DAX Studio and SQL profiler
Hi, I ran a refresh of a dataset for the first time. It took 4.5 hours. The main query in this is a view in SQLServer, being an aggregate on a table. When I run this view in SQLServer it takes 40...
Thnx, is on my read list. Is there something else then SQL Profiler to get insight in why refreshing takes so long?
Use SSMS and examine the actual query execution plan. It will even suggest indexes for you.