SQL Server Quickie #7 – TempDb Latch Contention

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 7th SQL Server Quickie to YouTube. This time I’m talking about Latch Contention in TempDb. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Klaus

SQL Server Quickie #6 – THREADPOOL Starvation

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 6th SQL Server Quickie to YouTube. This time I’m talking about THREADPOOL Starvation in SQL Server. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Klaus