Forum Discussion
acim9090
Aug 26, 2021Copper Contributor
Activity monitor - sql queryies behind
Hello I need to find the sql queries behind Activity monitor in SSMS so I can edit a bit. Some ideas how to find these?
- Aug 27, 2021
acim9090 , that's easy, use SQL Server Profiler to trace all SQL statements send from SSMS to SQL Server.
But not all base on query result, e.g. CPU/MEM diagram uses WMI queries to get the values.
Olaf
olafhelper
Aug 27, 2021Bronze Contributor
acim9090 , that's easy, use SQL Server Profiler to trace all SQL statements send from SSMS to SQL Server.
But not all base on query result, e.g. CPU/MEM diagram uses WMI queries to get the values.
Olaf
acim9090
Aug 27, 2021Copper Contributor
Thank you olafhelper . This is actually good idea, will try.
I