You are working in a Microsoft Fabric data environment that includes a data warehouse named Warehouse1. This warehouse receives daily data updates via data pipeline and stored procedures. Recently…

queryinsights.frequently_run_queries provides historical data about queries that run often, not currently executing queries.

sys.dm_exec_sessions is a dynamic management view (DMV) that provides information about all active user connections and internal tasks in a SQL Server instance, including the current login, host name, and program name for each session, making it ideal for identifying who is connected and potentially running queries.

queryinsights.long_running_queries provides historical data about queries that took a long time to complete, not currently executing queries.

sys.dm_exec_connections provides details about connections, but sys.dm_exec_sessions gives a more complete picture of active user sessions and their associated activity, which is better for identifying 'who is currently executing queries'.

sys.dm_exec_requests shows currently executing requests, but sys.dm_exec_sessions provides more direct user context for active sessions, which is the primary focus of identifying 'which users' are running queries.