How you will get the sessions detail, in SQL Server(performance tuning)?
We can easily access session detail by querying the sys.dm_exec_sessions DMV using the following query: SELECT * FROM sys.dm_exec_sessions;

https://www.interviewquestionspdf.com/2017/01/how-you-will-get-sessions-detail-in-sql.html
We can easily access session detail by querying the sys.dm_exec_sessions DMV using the following query:
SELECT * FROM sys.dm_exec_sessions;
SELECT * FROM sys.dm_exec_sessions;