Thursday, August 13, 2020

SQL Server Profiler - Just My Queries

To record only the actions you are performing, and not everything else from all the other users and services, simply add a filter for the ClientProcessID.

Trace File Properties:
 - Column Filters
     - ClientProcessID
         - Set the value to the your clients process.

No comments:

Post a Comment

Performance: Linking a List of Child Objects To a List of Parent Objects

Many a time I've had to build a relationship where a parent object has a list of child objects linked to it, where the parent itself als...