Opinions, tips, and news orbiting Microsoft
Moved from: bobsql.com
SQL Server 2016 introduces multiple log writer workers to the engine. For many years the log device was limited by the capabilities of spinning media and hardware caches. The a… Continue reading SQL 2016 – It Just Runs Faster: Multiple Log Writer Workers
Moved from: bobsql.com
SQL Server uses WriteFileGather for the vast majority of data file write requests. The logic is to consolidate dirty pages into a single I/O request.
For example page 1:13 and 1:12 are dir… Continue reading SQL 2016 – It Just Runs Faster: Larger Data File Writes
Moved from: bobsql.com
There are two(2) distinct checkpoint paths provided starting with SQL Server 2014, referred to as Automatic and Indirect.
The vast majority of documentation today highlights the behavior of automatic (classic) … Continue reading SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default
Our Azure training and certification portfolio continues to expand and evolve, and so does our support engineer specialties portfolio. As part of this expansion, we’re happy to announce the addition of the new Azure Support Engineer for Connectivity Sp… Continue reading Coming soon: Azure Support Engineer for Connectivity Specialty
Moved from: bobsql.com
The SOS_RWLock is a synchronization primitive used in various places throughout the SQL Server code base. As the name implies the code can have multiple shared (readers) or single (writer) ownership.
 … Continue reading SQL 2016 – It Just Runs Faster: SOS_RWLock Redesign
Moved from: bobsql.com
The CMemThread waits (PWAIT_MEMTHREAD) can be a point of contention as machine sizes advance. The CMemThread object type is utilized in 100s of objects throughout the SQL Server code base and can… Continue reading SQL 2016 – It Just Runs Faster: Dynamic Memory Object (CMemThread) Partitioning
Moved from: bobsql.com
As hardware continues to expand and evolve SQL Server testing and customer reports have highlighted the need to partition activities for optimal scaling. Partitioning based designs are common ways to localize ac… Continue reading SQL 2016 – It Just Runs Faster: Automatic Soft NUMA
Preface – Originally, this blog was simply going to be about why we run hackathons. But as we are writing this piece, we thought it’d be beneficial to make this a multi-part series. This will allow us to go deeper into why culture plays such a huge rol… Continue reading Tech Intensity and Driving Innovation Pt. 1 – Hack Culture