SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. Ryan Stonecipher – Principle SQL Server Software Engineer. SQL Server.

Hardware 40

Hardware Cache Servers Software Engineering 40

Brendan Gregg

FEBRUARY 28, 2023

This talk originated from my updates to [Systems Performance 2nd Edition], and this was the first time I've given this talk in person! CXL in a way allows a custom memory controller to be added to a system, to increase memory capacity, bandwidth, and overall performance. Ford, et al., “TCP

Performance 110

Performance Latency Cache Virtualization 110

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. Many open source proponents, including the Open Source Initiative (OSI) , do not consider software under the SSPL to be open source. We agree with the OSI’s determination that any software under the SSPL cannot be open source.

Open Source 81

Open Source Programming Database Servers 81

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. “. “Be The Back Story.

Servers 90

Servers Media Cache Storage 90

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers. I also wrote about these topics in detail for my recent [Systems Performance 2nd Edition] book. Ford, et al., “TCP

Performance 52

Performance Latency Hardware Storage 52

Brendan Gregg

FEBRUARY 28, 2023

This talk originated from my updates to Systems Performance 2nd Edition , and this was the first time I've given this talk in person! CXL in a way allows a custom memory controller to be added to a system, to increase memory capacity, bandwidth, and overall performance. Ford, et al., “TCP

Performance 52

Performance Latency Cache Virtualization 52

Percona

SEPTEMBER 19, 2023

This blog post will walk you through how MySQL’s InnoDB redo log archiving uses PXB to manage the redo log files on the busiest systems and look at how a new feature released in PXB version 8.0.34-29 Enabling redo log archiving on the server requires setting a value for the innodb_redo_log_archive_dirs system variable.

C++ 104

C++ Servers Storage Speed 104

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. This is not a problem for PostgreSQL alone; every database software needs to deal with this problem.

Database 116

Database Benchmarking Open Source Latency 116

Alex Podelko

OCTOBER 18, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Several tools recently announced integration with Continuous Integration Servers (such as Jenkins or Hudson). – Cloud. – Agile.

Performance Testing 100

Performance Testing Testing Performance DevOps 100

SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. As the following diagram shows the SQL Server Log Cache is in memory.

Cache 40

Cache Servers Media Storage 40

SQL Server According to Bob

JANUARY 5, 2017

Last March I moved from 22 years in SQL Server support to the SQL Server development team, working on SQL Server on Linux project and reporting to Slava Oks. As Slava highlights in his recent blog post , he also contacted me in early 2015 to assist with supportability of SQL Server on Linux.

Servers 40

Servers Operating System C++ Software Engineering 40

Alex Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Cloud seriously impacts system architectures that has a lot of performance-related consequences. First, we have a shift to centrally managed systems.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

SQL Server According to Bob

JUNE 9, 2016

SQL Server, as outlined in the following post ( [link] ) adjusts to various processor configurations. I have received questions related to how SQL Server accomplishes the alignment on both bare metal and VM installations. SQL Server uses Windows APIs to determine the processors and package interactions. GetSystemInfo [link].

Servers 40

Servers Virtualization Tuning Architecture 40

Brendan Gregg

OCTOBER 8, 2018

Created by Alastair Robertson , bpftrace is an open source high-level tracing front-end that lets you analyze systems in custom ways. eBPF (extended Berkeley Packet Filter) is in the Linux kernel and is the new hotness in systems engineering. It's shaping up to be a DTrace version 2.0: bcc is powerful but laborious to program.

C++ 110

C++ Virtualization Programming Latency 110

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). Once the connection to SQL Server is established the APP executes the odbc! Microsoft specific implementation for DTC using (OLE-TX).

Servers 40

Servers Azure Engineering Java 40

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

The Morning Paper

SEPTEMBER 29, 2019

As the primary source of third-party JavaScript packages for the client-side, server-side, and other platforms, npm is the centrerpiece of a large and important software ecosystem. No link to a public version control system (e.g. that means any third-party package can access the file system and network etc.

Code 76

Code Strategy Website Network 76

Brendan Gregg

NOVEMBER 29, 2017

Virtualized in Software**: While this can support an unmodified guest OS, many operations are emulated and slow. It's using software and coordination between the hypervisor and guest to improve performance. This was extended to instance storage devices for the x1.32xlarge in 2016. Apps may run 2x to 10x slower, or worse.

Virtualization 111

Virtualization AWS Hardware Storage 111

Rigor

SEPTEMBER 3, 2019

What you may be overlooking is that peak-event readiness is about more than just load testing or ensuring that your servers are up throughout a specific timeframe. Servers down or server health issues [APM]. This will ensure that you are not running software with a known vulnerability that has already been fixed.

Website 74

Website Cache Ecommerce Traffic 74

Alex Russell

MARCH 31, 2022

Late in the drafting of this post, it was pointed out to me by Frederik Braun that Brad Hill had considered the downsides of a site-populated SRI addressable cache back in 2016. Shared caches must make sense within this value system. and SFTP -ing one's dependencies to the server are gone. That's how much wire size matters.

Cache 82

Cache Government Traffic Network 82

Scalegrid

AUGUST 15, 2019

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. Should have an excellent way to measure server and query performance. Import data from RDBMS like MySQL, PostgreSQL, and SQL Server.

Database 40

Database Servers Monitoring Availability 40

Alex Russell

MAY 9, 2022

Only teams that master their systems can make intentional trade-offs. Panglossian nonsense. --> Organisations that serve their tools tread water no matter how advanced their technology, while groups that intentionally manage systems can succeed on any stack. [1]. Performance isn't a binary and there are no silver bullets.

Performance 86

Performance Latency Metrics Engineering 86

Rigor

SEPTEMBER 11, 2019

Rachel is also one of the people behind Perch , a PHP content management system (CMS). Rick is a software engineer on the Google Chrome team, “leading an effort to make the web just work for developers.” The future of HTTP/2 server push. All together, she has written 23 books as a solo or co-author since 2002.

Performance 89

Performance Education Google Website 89

Brendan Gregg

OCTOBER 7, 2018

Created by Alastair Robertson , bpftrace is an open source high-level tracing front-end that lets you analyze systems in custom ways. eBPF (extended Berkeley Packet Filter) is in the Linux kernel and is the new hotness in systems engineering. It's shaping up to be a DTrace version 2.0: bcc is powerful but laborious to program.

C++ 40

C++ Virtualization Programming Latency 40

Enprowess

SEPTEMBER 28, 2021

React developers introduced Inferno in 2016 as an experiment to examine whether or not a library can improve the battery, performance, and UX of mobile apps. Inferno JS would be your best option, if you would like to build client and server-side interfaces with faster speeds, better performance, and isomorphic rendering. .

Open Source 52

Open Source Mobile Entertainment Virtualization 52

High Scalability

AUGUST 9, 2018

One of the documents says in no uncertain terms that the company understands they will not be competitive in the server market until AFTER Sapphire Rapids, the 2022 server part. Uber : Since 2016, Uber has added several new lines of business to its platform, including Uber Eats, Uber Freight, and Jump Bikes.

Internet 21

Internet Internet Scalability Open Source 21

Brendan Gregg

NOVEMBER 28, 2017

Virtualized in Software**: While this can support an unmodified guest OS, many operations are emulated and slow. It's using software and coordination between the hypervisor and guest to improve performance. This was extended to instance storage devices for the x1.32xlarge in 2016. Apps may run 2x to 10x slower, or worse.

Virtualization 40

Virtualization AWS Hardware Storage 40

Smashing Magazine

OCTOBER 26, 2018

However, being an easy-to-use inclusive and versatile piece of software, WordPress comes with a plethora of options that are not necessarily utilized in each and every project. WordPress core developers used a system of hooks which allowed other developers to modify or extend certain functionalities. on December 6th, 2016.

Cache 78

Cache Website Speed Database 78

SQL Server According to Bob

AUGUST 23, 2016

Update System Table Info. The creation of the XTP, common access DLL requires SQL Server to generate C code, invoke the C compiler and save the DLL into the XTP directory. Bob Dorr – Principal Software Engineer SQL Server. Let’s take a high level look at the create table activities. Disk Based. In-Memory Optimized.

C++ 40

C++ Software Engineering Servers Code 40

All Things Distributed

DECEMBER 13, 2016

In just this past month we've had HSBC , ARM , Missguided , and most recently at re:Invent 2016 , Trainline , talking with us about how they are using AWS to transform and scale their businesses. I have been humbled by just how much our UK customers have been able to achieve using AWS technology so far.

AWS 166

AWS Cloud Artificial Intelligence IoT 166

Smashing Magazine

JULY 6, 2021

This data would be collated and authored in a Web Content Management System (WCMS) by a content editor. With Luminary’s 21 years of experience in the digital space, my experience of 17 years in the CMS space as well as our focus on Headless since 2016, here are my two cents on what you should look out for. Microservices architecture.

Cache 143

Cache Website Mobile Google 143