I want to know what is an aggregated result of an event and what to do in order to get aggregated results?
Thanks for your time!
SQL Server – What is Aggregation in SQL Profiler?
profilersql server
Related Question
- Sql-server – Sql profiler replay table
- SQL Server Profiler – Error Using Triggers with Profiler Tables
- SQL Server Profiler – Measuring DB Time of Application
- SQL Profiler – Can SQL Profiler Filter Data Columns for One Event
- SQL Server – What Does ‘Exclude Rows That Do Not Contain Values’ Checkbox Do in SQL Profiler?
- SQL Server Profiler – How to Handle Process Blocking
- Sql-server – find out current disk response time in MS SQL Server using DMOs
Best Answer
Say you aggregate on the LoginName column for instance. Then you get one blue section for each login name, and it will show you also how many events you have for that login name. To see the actual events, for that login, you look at the white rows under that blue row. In your example, you have aggregated over duration, and in the pic you included you have no two events with the same duration. Aggregating over something which has very few duplicates isn't very meaningful. You can think of aggregation such as a group by with a COUNT(*), that is what you see in the blue section for each value in the columns that you "grouped/aggregated" over.