As a business analyst that uses SQL mainly to query databases, this is a little technical for me and I can't seem to find the right information.
We have an SQL Server that we query using Power BI (Direct Query Mode). However some query's take a long time to complete. With SQL Profiler I can set up a trace and see the incoming query's. But it's only active while I have the trace active.
How can I set up a monitoring for incoming query? Ideally, I would have a table that contains at least: Query, User, Starttime, Endtime (or total runtime)