Why not use the tools available for you
SQL Server Profiler is an interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when diagnosing a problem
SQL Server Profiler is a part of SQL Management Studio and can even be used to troubleshoot SQL Express.
A very helpful feature is “ClientProcessID” which will display which Process ID on the remote client is running the SQL Query.
There are several templates for monitoring and to help you filter out noise you can go into file-properties and the “Event Selection”
Here you can define column filters for specific databases, and as an example you can choose to show only TSQL queries that last longer than 500 milliseconds, which will often indicate a slow query.
Happy troubleshooting SQL😊
