SQL Server According to Bob

JUNE 22, 2016

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Instead the design of CMemThread was updated.

Servers 40

Servers Azure Software Engineering Design 40

ScaleOut Software

JUNE 22, 2020

The pace of these changes has made it challenging for server-based infrastructures to manage fast-growing populations of users and data sources while maintaining fast response times. They transparently distribute stored objects across the cluster’s servers and ensure that data is not lost if a server or network component fails.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

ScaleOut Software

JUNE 22, 2020

The pace of these changes has made it challenging for server-based infrastructures to manage fast-growing populations of users and data sources while maintaining fast response times. They transparently distribute stored objects across the cluster’s servers and ensure that data is not lost if a server or network component fails.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

SQL Performance

AUGUST 12, 2020

You can find it in the documentation of Microsoft SQL Server and Azure SQL Database. T-SQL supports it starting with SQL Server 2005. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors.

C++ 140

C++ Code Design Database 140

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90

Servers Media Cache Storage 90