SQLWorkshops
This channel was created to provide SQL Server DBAs, developers and architects with useful information on how to tune Microsoft SQL Server.
The clips are demo-heavy, being the result of practical performance tuning for real world customer issues. The goal is to empower customers to fully realize the Performance potential of Microsoft SQL Server without increasing the total cost of ownership (TCO).
Author of most of the videos is Ramesh Meyyappan, a SQL Server performance tuning specialist with 20 years of experience. Ramesh worked for Microsoft Corporation for 10 years, almost half of that time in Redmond, especially as Program Manager in the SQL Server Development Team.
Newsletter @ https://newsletter.sqlworkshops.com
SQL Workshops, Consulting & Articles @ sqlworkshops.com
SQLTest ~ SQL Server Performance, Load, Stress & Unit Test Tool @ sqltest.org
sp_whopro ~ SQL Server Activity Monitoring and Logging Stored Procedure @ sqldownload.com
Tempdb Metadata Contention in SQL Server - Table Variable Vs Temporary Table
AlwaysOn Availability Groups Synchronous Replica Readable Secondary Data Access Latency
Seek or Scan - Cost Based Optimizer in SQL Server
Optimize for Ad Hoc Workloads - SQL Server Configuration Parameter
Extended Event Locks Lock Waits in SQL Server
Extended Event Query Post Execution Showplan in SQL Server
PAGELATCH Waits with Update Statements in SQL Server - PAGELATCH_EX and PAGELATCH_SH
Tempdb Allocation Contention in SQL Server
In-Memory OLTP Memory Optimized Table Variables Vs Disk Based Table Variable in SQL Server
Filtered Statistics in SQL Server
Parallel Insert Into - Table Variable Vs Temporary Table in SQL Server
Cardinality Estimation - Table Variable Vs Temporary Table in SQL Server
Understanding ASYNC_NETWORK_IO Waits in SQL Server
Resource Governor in SQL Server - Workload Throttling
Data Compression in SQL Server - Pros and Cons
SQL Server Command Timeout - Application Timeout - Attention
Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1)
NUMA remote (foreign) memory access overhead on Windows
NUMA remote (foreign) memory access overhead on SQL Server for Disk based Tables
NUMA remote (foreign) memory access overhead for SQL Server In-Memory OLTP Memory optimized Tables
SQL Test Essentials
sp_whopro Getting Started Part 1
SQLTest Getting Started Part 1
SQLTest Getting Started Part 2
SQLTest License
SQLTest Install