SQL Performance

MARCH 29, 2022

Simple parameterization has a number of quirks in this area, which can result in more parameterized plans being cached than expected, or finding different results compared with the unparameterized version. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. DisplayName.

Cache 90

Cache Servers Database Testing 90

SQL Performance

MARCH 22, 2022

This series doesn’t dwell too long on the basics but concentrates on less well-known aspects likely to trip up even the most experienced database professionals. In this first part, after a quick introduction, I look at the effects of simple parameterization on the plan cache. ALTER DATABASE SCOPED CONFIGURATION. Shell Plans.

Cache 61

Cache Servers Database Code 61

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? KB boundary   12 Larger transaction logs   13 Restore and attach   14 Format for 4 ?KB

Servers 40

Servers Cache Database Media 40

ScaleOut Software

JUNE 22, 2020

From Distributed Caches to Real-Time Digital Twins. Emerging in the early 2000s, the first such platforms provided distributed caching on clustered servers with straightforward APIs for storing and retrieving in-memory objects.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

ScaleOut Software

JUNE 22, 2020

From Distributed Caches to Real-Time Digital Twins. Emerging in the early 2000s, the first such platforms provided distributed caching on clustered servers with straightforward APIs for storing and retrieving in-memory objects.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

SQL Performance

MARCH 30, 2021

I used the public Stack Overflow 2013 database ( download details ). The fundamentals of row mode parallel execution haven’t changed since SQL Server 2005, so the following discussion is broadly applicable. See Myth: SQL Server Caches a Serial Plan with every Parallel Plan for details. It can be downloaded at the same link.

Cache 98

Cache Servers Operating System Processing 98

All Things Distributed

SEPTEMBER 20, 2013

Traditionally records in a database were stored as such: the data in a row was stored together for easy and fast retrieval. Combined with the rise of data warehouse workloads, where there is often significant redundancy in the values stored in columns, and database models based on column oriented storage took off.

Storage 90

Storage Hardware Cache C++ 90