SQL Server According to Bob

AUGUST 8, 2016

For internal structures SQL Server often applies partitioning designs. For example, SQL Server may employ a per NODE or per CPU based design. If you study a CPU you will find various cache levels (L1, L2, …) In fact, the further away from the CPU the colder the memory is considered.

Cache 40

Cache Energy Database Servers 40

Abhishek Tiwari

DECEMBER 13, 2017

This has far-reaching implications how future data systems and algorithms will be designed. Their result is particularly promising for specialized index structures termed as learned indexes which has potential to replace B-Trees without major re-engineering. Bigger picture.

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

The Netflix TechBlog

OCTOBER 16, 2019

This post is a high level overview of the design and architecture of Gutenberg. Often the data is held in memory by consumers and used as a “total cache”, where it is accessed at runtime by client code and atomically swapped out under the hood. An important point to note is that Gutenberg is not designed as an eventing system?—?it

Cache 187

Cache Architecture Metrics Java 187

Abhishek Tiwari

NOVEMBER 3, 2018

In the CMS selection process, developer experience is not a factor, although successful implementation and ongoing maintenance require developer friendly tooling and support for modern software engineering practices. Not to mention, traditional CMS implementation cycle is generally waterfall or water-Scrum-fall at best.

Systems 63

Systems Cache Website Network 63

SQL Server According to Bob

JUNE 3, 2016

The new column store engine and query processing technology could increase query performance up to 100X and the new In-memory OLTP engine can process 1.25million batches/sec on a single 4 socket server, which is more than 3X of SQL 2014. “ – Rohan Kumar, Director of SQL Software Engineering. Auto-soft NUMA.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Server According to Bob

MAY 19, 2019

Testing shows that locking mechanisms, such as spin locks, start to become saturated when shared across 8 to 12 CPUs and where the physics become a direct contributor to partitioned design. The lock manager has partitions, lock block cache and other structures. Reduce the number of partitions and size of the cache. Lock Manager.

IoT 61

IoT Servers Development Cache 61

SQL Server According to Bob

JULY 23, 2016

Just imagine of all the times SQL Server may need to lookup something in a cache. Using a reader, writer object allows multiple threads on multiple CPUs to do the lookups in parallel versus lining up behind a single, gated synchronization object design. Bob Dorr – Principal Software Engineer SQL Server.

Cache 40

Cache Software Engineering Servers Code 40

SQL Server According to Bob

DECEMBER 31, 2018

iBytesRead = s.Read(bData, 0, c_iMaxReadSize); } }. . // Do we need to start the read-ahead to suck data into file system cache if (iCookie > -1) { tReadAhead.Start(iCookie); } }. Bob Dorr – Principal Software Engineer SQL Server. textBoxDisplay.Text += strText; } } } } }. Designer.cs. TabIndex = 2; this.menuStrip1.Text

Efficiency 40

Efficiency Code Servers Cache 40