April 29, 2022 at 5:32 pm
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)
April 29, 2022 at 6:57 pm
You can configure a trace to run 24/7 ,which I found useful in the past for diagnosis.
Extended Events are the new & Improved option, but I have not had to delve into them much at my new job, so can't offer any advice on using them.
May 28, 2022 at 1:36 pm
This was removed by the editor as SPAM
May 28, 2022 at 1:36 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply