Profiler Trace Events to Watch during Processing Watching in Profiler, you can observe of the following Progress Report Begin and Progress Report End events. The Progress Report End event contains a Duration column. Focus on the largest Duration events. Table 6. List of related trace events EventSubclass Progress Report Begin and End TextData Explanation 1 Process Processing of the 'YourPartitionName' The Duration on the Progress Report – partition has started. End event tells you how long the ProcessData phase took. The Finished processing the ProcessRecalc phase begins later. 'YourPartitionName' partition. 25 ExecuteSQL select * from YourTableName The SQL query run for that partition – 17 ReadData Reading data for the The Progress Report Begin fires when – 'YourTableName_GUID' table started. the first row is read from the relational data source. If the Finished reading data for the CurrentTime on this event is much 'YourTableName_GUID' table. delayed from when partition processing started, the SQL query was slow to return rows. If the duration on the Progress Report End event is longer than expected, optimize the SQL query. The Progress Report Current displays the number of rows returned in the IntegerData column. 53 VertiPaq Compression started for the Despite the text mentioning that – 'YourTableName_GUID' table. compression is starting for the table, this pair of events is seen once per Compression for the segment. 'YourTableName_GUID' table completed in '141509' steps with '60108' clusters See above for explanation of computed in total. Execution has been compression and timeboxing. timeboxed. 44 Compress Compressing segment 0 of column Detecting which columns take a long – Segment 'YourColumnName' for the time to compress can be seen by 'YourTableName_GUID' table started. monitoring the Duration column on the Progress Report End event. Finished compressing segment 0 of column 'YourColumnName' for the 'YourTableName_GUID' table 54 Hierarchy Started processing the 'YourColumnName' A long Duration on the Progress – processing hierarchy. Report End indicates a very high cardinality column for building the hierarchy is expensive. Consider
Profiler Trace Events to Watch during Processing Watching in Profiler, you can observe of the following Progress Report Begin and Progress Report End events. The Progress Report End event contains a Duration column. Focus on the largest Duration events. Table 6. List of related trace events EventSubclass Progress Report Begin and End TextData Explanation 1 – Process Processing of the 'YourPartitionName' partition has started. Finished processing the 'YourPartitionName' partition. The Duration on the Progress Report End event tells you how long the ProcessData phase took. The ProcessRecalc phase begins later. 25 – ExecuteSQL select * from YourTableName The SQL query run for that partition 17 – ReadData Reading data for the 'YourTableName_GUID' table started. Finished reading data for the 'YourTableName_GUID' table. The Progress Report Begin fires when the first row is read from the relational data source. If the CurrentTime on this event is much delayed from when partition processing started, the SQL query was slow to return rows. If the duration on the Progress Report End event is longer than expected, optimize the SQL query. The Progress Report Current displays the number of rows returned in the IntegerData column. 53 – VertiPaq Compression started for the 'YourTableName_GUID' table. Compression for the 'YourTableName_GUID' table completed in '141509' steps with '60108' clusters computed in total. Execution has been timeboxed. Despite the text mentioning that compression is starting for the table, this pair of events is seen once per segment. See above for explanation of compression and timeboxing. 44 – Compress Segment Compressing segment 0 of column 'YourColumnName' for the 'YourTableName_GUID' table started. Finished compressing segment 0 of column 'YourColumnName' for the 'YourTableName_GUID' table Detecting which columns take a long time to compress can be seen by monitoring the Duration column on the Progress Report End event. 54 – Hierarchy processing Started processing the 'YourColumnName' hierarchy. A long Duration on the Progress Report End indicates a very high cardinality column for building the hierarchy is expensive. Consider
Performance%20Tuning%20of%20Tabular%20Models%20in%20SQL%20Server%202012%20Analysis%20Services.docx