Most RecentMost ViewedMost LikesHow It Works: Soft NUMA, I/O Completion Thread, Lazy Writer Workers and Memory Nodes First published on MSDN on Apr 02, 2010 There seems to be some semantic(s) confusion on the books online description of SOFT NUMA. How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks) First published on MSDN on Dec 13, 2012 Applies to: SQL 2005, 2008, 2008 R2, and SQL 2012 versions. How It Works: SQL Server 2005 Connection and Task Assignments First published on MSDN on Feb 12, 2008 I have talked about how connections and tasks get assigned as PASS and during many other mentoring opportunities. How It Works: SQL Server 2005 NUMA Basics First published on MSDN on Jan 24, 2008 The Senior Escalation Engineers do various training and mentoring activities. SQL Server: Clarifying The NUMA Configuration Information First published on MSDN on Nov 11, 2011 The increased number of cores per socket is driving NUMA designs and in SQL Server support we are seeing more NUMA machines and less pure SMP machines. When is Spinlock a Significant Driver of CPU utilization in SQL Server? SQL Server Spinlocks - "How many spins is too many?" The answer: approximately 18,000 - 20,000 or more How It Works: Controlling SQL Server memory dumps First published on MSDN on Nov 17, 2009 I just completed a lengthy bit of research and thought I would share it with everyone. How It Works: SQL Server 2012 Database Engine Task Scheduling First published on MSDN on Aug 13, 2013 Over the years the SQL Server scheduling algorithms have been documented in various publications. Hot It Works: SQL Server SuperLatch'ing / Sub-latches First published on MSDN on Jan 28, 2009 SQL Server Books Online uses the terms super latches and sub-latch to describe them. The SQL Server Wait Type Repository…First published on MSDN on Nov 02, 2009 12/10/2009: Significant updates to the blog.
