Compartilhar via


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

<Previous