Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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