Sometime the cube build took several minutes, but sometimes it took around 2 hours. I want to trace it and see what is going on. I used SQL profiler.
Question 1. Do you have any suggestions on use the profiler? In trace properties, any suggestions on setting Events, Data Columns, Filter? What do you think they are necessary to set?
Question 2. Do you know any good documents on using SQL profiler?