RESOURCE SEMAPHORE Wait Type & SQLQERESERVATIONS Memory Clerk (by Amit Bansal)
In this video, you will learn about Resource Semaphore Wait Type in SQL Server and also, it’s relation with SQLQERESERVATIONS Memory Clerk.
SQL Server Parallelism (Part 2 of CXPACKET) (by Amit Bansal)
This video is a follow up to CXPACKET video (Part 1). You will see that SQL Server Query Execution Engine still assign max number of threads (as per the number of cores (up to a max of 64)) even when the DB engine is under severe pressure.
Query Tuning – sys.dm_exec_query_stats and sys.dm_exec_procedure_stats by Amit Bansal
In this video, you will understand the difference between sys.dm_exec_query_stats and sys.dm_exec_procedure_stats
SQL Server Index Tuning – Multi Column Seeking by Amit Bansal
In this video, you will understand how the SQL Optimizer utilizes a multi column index (Optimizer’s Choice of Indexes)
Debugging SQL Server – Setting Up Windows Debugger by Amit Bansal
In this video, you will understand how to setup windows debugger and get ready to debug windows with public symbols
CXPACKET Wait Type in SQL Server by Amit Bansal
In this video, you will understand what CXPACKET Wait Type is and how you can get rid of unwanted parallelism in SQL Server.
When Did SQL Server Start (Database Engine Start Time) by Amit Bansal
In this video, you will see how you can find the elapsed time in milliseconds since SQL Server process started
Processor Time (Processor vs Process) – Monitoring SQL Server CPU Usage by Amit Bansal
In this video, you will understand the difference between Processor % Processor Time & Process % Processor Time

RESOURCE SEMAPHORE Wait Type & SQLQERESERVATIONS Memory Clerk (by Amit Bansal)

SQL Server Parallelism (Part 2 of CXPACKET) (by Amit Bansal)

Query Tuning – sys.dm_exec_query_stats and sys.dm_exec_procedure_stats by Amit Bansal

SQL Server Index Tuning – Multi Column Seeking by Amit Bansal

Debugging SQL Server – Setting Up Windows Debugger by Amit Bansal

CXPACKET Wait Type in SQL Server by Amit Bansal

When Did SQL Server Start (Database Engine Start Time) by Amit Bansal

Processor Time (Processor vs Process) – Monitoring SQL Server CPU Usage by Amit Bansal