SQL Server According to Bob
Come here for knowledge about SQL Server uniquely provided by the two Bobs at Microsoft
Does SQL Server 2016 Require Trace Flag -T8048?
Various changes from automatic soft NUMA to CMemThread partitioning have muddied the water around...
Author: RDORR Date: 06/22/2016
Unresolved Deadlock vs Scheduler Deadlock
These are distinct errors but I have found that many people blend them together. It really takes an...
Author: RDORR Date: 06/21/2016
SQL 2016–Install MSVC Patch Required
I can’t emphasize this patch enough. There is a MSVC, runtime library patch needed by SQL Server...
Author: RDORR Date: 06/15/2016
How It Works: How SQL Server Determines Logical and Physical Processors
SQL Server, as outlined in the following post...
Author: RDORR Date: 06/09/2016
How It Works: SQL Server 2016 SSE/AVX Support
My recent posts...
Author: RDORR Date: 06/06/2016
SQL 2016 - It Just Runs Faster Announcement
SQL Server 2016 'It Just Runs Faster' A bold statement that any SQL Server professional can stand...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: DBCC Scales 7x Better
Many of you have experienced (MULTI_OBJECT_SCANNER* based) waits while running DBCC CHECKS*(checkdb,...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: DBCC Extended Checks
Last week’s post (SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better) talked about several...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Native Spatial Implementation(s)
Spatial data is among, if not the fastest, growing storage types for the SQL Server database. It is...
Author: Bob Ward (Microsoft) Date: 06/03/2016
SQL 2016 - It Just Runs Faster: TVPs with Spatial Column(s)
Table Valued Parameters (TVPs) containing spatial columns can be used as input parameter(s) to...
Author: Bob Ward (Microsoft) Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Spatial Index Builds Faster
Index creation and tessellation are often intensive, spatial activities. Along with the native and...
Author: Bob Ward (Microsoft) Date: 06/03/2016
SQL 2016 - It Just Runs Faster: -T1117 and -T1118 changes for TEMPDB and user databases
Configuration of TEMPDB is often critical to scalability and throughput of SQL Server applications....
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Automatic TEMPDB Configuration
Various KBs, whitepapers and blogs have outlined the need for the creation of multiple, TEMPDB...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: LDF Stamped
When creating or growing the database log file (LDF) a byte pattern is stamped. The pattern...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Instant File Initialization
Database Instant File Initialization was added several SQL Server releases ago. The instant file...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Automatic Soft NUMA
As hardware continues to expand and evolve SQL Server testing and customer reports have highlighted...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Updated Scheduling Algorithms
SQL Server 2016 gets a scalability boost from scheduling updates. Testing uncovered issues with the...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Dynamic Memory Object (CMemThread) Partitioning
The CMemThread waits (PWAIT_MEMTHREAD) can be a point of contention as machine sizes advance. The...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: SOS_RWLock Redesign
The SOS_RWLock is a synchronization primitive used in various places throughout the SQL Server code...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Indirect Checkpoint Default
There are two(2) distinct checkpoint paths provided starting with SQL Server 2014, referred to as...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Larger Data File Writes
SQL Server uses WriteFileGather for the vast majority of data file write requests. The logic is to...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Multiple Log Writer Workers
SQL Server 2016 introduces multiple log writer workers to the engine. For many years the log device...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: Column Store Uses Vector Instructions (SSE/AVX)
SQL Server's Column Store feature is designed to accommodate large amounts of data and associated...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster - BULK INSERT Uses Vector Instructions (SSE/AVX)
SQL Server 2016 enhanced the bulk insert activities (BULK INSERT), leveraging the CPUs vector...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: AlwaysOn Log Transport Reduced Context Switches
The AlwaysOn log transport uses a SQL Broker based design to send and receive messages between the...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms
SQL Server 2016 introduces two distinct changes in the AlwaysOn transport, compression design....
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster - AlwaysOn AES-NI Encryption
The SQL Server 2016, AlwaysOn, log transport takes advantage of hardware based encryption to...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: In-Memory Optimized Database Worker Pool
SQL Server leverages a worker pool for the In-Memory Optimized Database capabilities. Prior to SQL...
Author: RDORR Date: 06/03/2016
SQL 2016 - Leverages On Demand MSDTC Startup
SQL Server leverages MSDTC for distributed transactions (begin distributed transaction, remote proc...
Author: RDORR Date: 06/03/2016
SQL 2016 - It Just Runs Faster: XEvent Linq Reader
SQL Server 2016 improves the XEvent Linq reader scalability and performance. The XEvent UI in SQL...
Author: RDORR Date: 06/03/2016