|
This videos and others about Profiler from this author/presenter are very helpful. For the past 10 years, I've treated Profiler like the jack in my car: good to know it's there, better if I know how it works, but by and large I don't want to see it and resent the day I'm going to have to use it.
|
|
Helpful videos. That said, I think you missed a chance to clarify something that many miss. While you noted that filters "only apply to events that produce that column", and you may know what that implies, I think most do not realize it: it means that if you select events that DO NOT have that column (that's being filtered on), the rows for that event WILL still be in the trace.
Many people miss this and think they will "only get events that match the filter". But if they're not careful and pick events that do not have the filtered columns but generate many rows (like login/logout, lock events, etc.) then they could have a much larger trace than expected.
This seems a "dirty little secret" about Profiler that rarely gets mentioned. You do say at the end of the description above, "Note that even with a filter the volume can still be substantial!", so this may be what you were getting at. It just seems an opportunity was missed to make that more clear when you commented in the video about how filters apply only to events with that column. :-)
Still, again, thanks for taking the time to add the videos to help people.
|