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;