Performance Tuning Continued – Sun 2/5/2023 with POSHEM

In this video, we review some tools for performance tuning and how to use them effectively.

Some tools covered include:
SQL Server Activity Monitor- Processes and Recent Expensive Queries
Stored Procedure SP_Who2 and SP_whois ctive BY Adam Mechanic
Execution plans (Index Seeks and Scans)
We ended by working in teams (Accountability partners)

RREVIEW THE SQL SERVER DBA INTERVIEW and feel free to contact us at [email protected]