What should you use?

You are examining information about users, sessions, and processed in an on-premises Microsoft SQL ServerDatabase Engine instance.

You need to return information about processes that are not idle, that belong to a specific user, or that belongto a specific session.

What should you use?
A . Activity Monitor
B . sp_who3
C . SQL Server Management Studio (SSMS) Object Explorer
D . SQL Server Data Collector
E . SQL Server Data Tools (SSDT)
F . SQL Server Configuration Manager

View Answer

Answer: B

Explanation:

Use sp_who3 to first view the current system load and to identify a session of interest. You should execute thequery several times to identify which session id is most consuming teh system resources.

Parameters

sp_who3 null – who is active;

sp_who3 1 or ‘memory’ – who is consuming the memory;

sp_who3 2 or ‘cpu’ – who has cached plans that consumed the most cumulative CPU (top 10);

sp_who3 3 or ‘count’ – who is connected and how many sessions it has;

sp_who3 4 or ‘idle’ – who is idle that has open transactions;

sp_who3 5 or ‘tempdb’ – who is running tasks that use tempdb (top 5); and,

sp_who3 6 or ‘block’ – who is blocking.