SQL Video

Here you can learn about SQL Server and SQL Server Performance Monitoring and Tuning. You can also watch videos on how to get the best out of SQLTest and sp_whopro™. You can practice the SQL Server Performance Tuning examples along with us while watching. SQLTest simulates the bottlenecks for you!

Many of our videos are now also available on MSDN Channel 9.

Attend one of our upcoming SQL Server Performance Tuning Hands-on Workshops and get a complementary 1 Year SQLTest Professional License!

Latest Videos

Tempdb Metadata Contention in SQL Server - Table Variable Vs Temporary Table

More info: http://www.sqlvideo.com/AllVideos/Tempdb-Metadata-Contention---Table-Variable-Vs-Temporary-Table

AlwaysOn Availability Groups Synchronous Replica Readable Secondary Data Access Latency

More info: http://www.sqlvideo.com/AllVideos/AlwaysOn-Synchronous-Replica-Readable-Secondary-Data-Latency

Seek or Scan - Cost Based Optimizer in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Seek-or-Scan---Cost-Based-Optimizer-in-SQL-Server

Optimize for Ad Hoc Workloads - SQL Server Configuration Parameter

More info: http://www.sqlvideo.com/AllVideos/Optimize-for-Ad-Hoc-Workloads---SQL-Server-Parameter

Extended Event Locks Lock Waits in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Extended-Event-Locks-Lock-Waits-in-SQL-Server

Extended Event Query Post Execution Showplan in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Extended-Event-Query-Post-Execution-Showplan-in-SQL-Server

PAGELATCH Waits with Update Statements in SQL Server - PAGELATCH_EX and PAGELATCH_SH

More info: http://www.sqlvideo.com/AllVideos/PAGELATCH-Waits-with-Update-Statements-in-SQL-Server

Tempdb Allocation Contention in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Tempdb-Allocation-Contention-in-SQL-Server

In-Memory OLTP Memory Optimized Table Variables Vs Disk Based Table Variable in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Memory-Optimized-Table-Variables-Vs-Disk-Based-Table-Variable

Temp Table Caching in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Temp-Table-Caching-in-SQL-Server

Filtered Statistics in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Filtered-Statistics-in-SQL-Server

Parallel Insert Into - Table Variable Vs Temporary Table in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Parallel-Insert-Into---Table-Variable-Vs-Temporary-Table

Cardinality Estimation - Table Variable Vs Temporary Table in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Cardinality-Estimation---Table-Variable-Vs-Temporary-Table

Understanding ASYNC_NETWORK_IO Waits in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Understanding-ASYNC_NETWORK_IO-Waits-in-SQL-Server

Resource Governor in SQL Server - Workload Throttling

More info: http://www.sqlvideo.com/AllVideos/Resource-Governor-in-SQL-Server---Workload-Throttling

Data Compression in SQL Server - Pros and Cons

More info: http://www.sqlvideo.com/AllVideos/Data-Compression-in-SQL-Server---Pros-and-Cons

SQL Server Command Timeout - Application Timeout - Attention

More info: http://www.sqlvideo.com/AllVideos/SQL-Server-Command-Timeout---Application-Timeout---Attention

Subscribe to our Newsletter

Tags

AlwaysOn Availability Groups   Application Timeout   ASYNC_NETWORK_IO   Asynchronous Replica   Attention   BPE   Command Timeout   CPU Throttling   Data Compression   Data Latency   Dynamic SQL   Estimation   Execution Plan   Extended Events   Filtered statistics   In-memory OLTP   Locking   locks lock waits   Memory Optimized Table Variable   NUMA   optimize for ad hoc workloads   Optimizer   PAGELATCH_EX   PAGELATCH_SH   Parameterization   query post execution showplan   Readable Secondary   Resource Governor   Scan   Seek   sp_executesql   sp_whopro   SQL Server   SQLTest   Stored Procedure   Synchronous Replica   Table Variable   Temp Table Caching   Tempdb   Tempdb Allocation Contention   Tempdb Metadata Contention   Temporary Table   Wait Stats   Workload Throttling  

VISIT ALSO OUR SISTER PAGES