HomeSQL SERVER PERFORMANCE TUNING INTERVIEW QUESTIONSHow you will get the sessions detail, in SQL Server(performance tuning)? How you will get the sessions detail, in SQL Server(performance tuning)? 0 Vikas 22:18 We can easily access session detail by querying the sys.dm_exec_sessions DMV using the following query: SELECT * FROM sys.dm_exec_sessions; Tags MS SQL SERVER PERFORMANCE TUNING SQL SERVER PERFORMANCE TUNING INTERVIEW QUESTIONS Newer Older