Forum Discussion
Which SQL Server Profiler Events to select for Analysis Service?
I am currently trying to undertsand what are the components that are responsible for longer refresh time for my report. High lvel, I know how to do this through SQL Server Profiler. Low Level, I wa...
There is no magic wand - what you are doing sounds reasonable, keep doing it. Look at all potential causes
- slow data source (maintain indexes and statistics)
- slow connection (reduce the traffic)
- slow measures (check the query plan in DAX, especially the cycle count)
- slow rendering (remove unneeded UX elements, use small multiples etc.)