Brendan Gregg

JULY 2, 2021

This is also applicable for people adding it to their own in-house monitoring systems. You likely already have agents running on all your customer systems. There are so many options it's really your own preference based on your existing system and customer environments. cachestat File system cache statistics line charts.

Latency 145

Latency Cache Energy Systems 145

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

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. Trace flag –T8048 longer exists in SQL Server 2016.

Servers 40

Servers Azure Software Engineering Design 40

SQL Server According to Bob

JUNE 6, 2016

As indicated, SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance. This post will outline SQL Server’s decisions around SSE/AVX or software algorithm use. SQL Server asks the CPU if it supports SSE or AVX in order to determine the level of hardware support present on the system.

Servers 40

Servers Hardware Software Engineering Software 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 52

Performance Latency Cache Virtualization 52

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

SQL Performance

FEBRUARY 22, 2021

I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us. The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests , sys.dm_exec_sessions , and sys.dm_exec_connections.

Latency 57

Latency Servers Monitoring Systems 57

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Test Environment. The cost threshold for parallelism is set to 50.

Servers 86

Servers Tuning Database Efficiency 86

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. set nocount on.

Hardware 40

Hardware Cache Servers Software Engineering 40

Brendan Gregg

JULY 2, 2021

This is also applicable for people adding it to their own in-house monitoring systems. You likely already have agents running on all your customer systems. There are so many options it's really your own preference based on your existing system and customer environments. cachestat File system cache statistics line charts 7.

Open Source 40

Open Source Latency Cache Energy 40

SQL Performance

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). ORDER BY ExecutionCount DESC ; Note: The sys.dm_exec_function_stats DMV was added in SQL Server 2016. Each option has pros and cons. query_hash AS [ query_hash ] , qs.

C++ 74

C++ Database Servers Tuning 74

Brendan Gregg

JULY 30, 2017

In late 2014 I was modifying the JDK to preserve the frame pointer so that traditional stack walkers and profilers would work (an example of the problem is here , where Java methods lack ancestry). If you're automating or implementing flame graphs, this is a small detail that may interest you. First, a confession.

Code 40

Code Java C++ Website 40

Brendan Gregg

MARCH 16, 2024

The problem is that this system has a default libc that has been compiled without frame pointers, so any stack walking stops at the libc layer, producing a partial stack that's missing the application frames. Back-end servers. This is pretty common and usually goes unnoticed as the flame graph looks ok at first glance.

Java 145

Java Cache Google Hardware 145

Dynatrace

AUGUST 11, 2022

Cloud providers then manage physical hardware, virtual machines, and web server software management. The FaaS model of cloud computing debuted in 2014 with startups like hook.io. This code is then executed on remote servers in response to an event, such as users interacting with functional web elements. Limited visibility.

Development 253

Development Serverless Best Practices Lambda 253

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. I always check backups first when looking at a new system. Statistics.

Servers 49

Servers Azure Hardware Database 49

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. Microbenchmark os::javaTimeMillis() on both systems.

Speed 126

Speed Java AWS Virtualization 126

Dynatrace

SEPTEMBER 29, 2020

Since we moved to AWS in May 2014 we have had an availability of 99.95%! It was on August 25 th at 14:00 when Davis initially alerted on a disk write latency issues to Elastic File System (EFS) on one of our EC2 instances in AWS’s Sydney Data Center. Sydney, we have a disk write latency problem!

Infrastructure 181

Infrastructure Cloud Monitoring AWS 181

Rigor

SEPTEMBER 11, 2019

Rachel is also one of the people behind Perch , a PHP content management system (CMS). Patrick is a London-based software developer who specializes in web performance and who describes himself as enjoying “working the entire stack, back-end to front-end, CDN to server.” The future of HTTP/2 server push.

Performance 89

Performance Education Google Website 89

Abhishek Tiwari

NOVEMBER 3, 2018

Recently I was asked about content management systems (CMS) of the future - more specifically how they are evolving in the era of microservices, APIs, and serverless computing. If you put your whole website on CDN, technically you don’t need a large number of server infrastructure and CMS licenses.

Systems 63

Systems Cache Website Network 63

Dynatrace

MAY 31, 2021

Since Kubernetes emerged in 2014, it has become a popular solution for scaling, managing, and automating the deployments of containerized applications in distributed environments. Although Kubernetes simplifies application development while increasing resource utilization, it is a complex system that presents its own challenges.

Virtualization 133

Virtualization DevOps Infrastructure Cloud 133

Sutter's Mill

MARCH 11, 2024

We must make our software infrastructure more secure against the rise in cyberattacks (such as on power grids, hospitals, and banks), and safer against accidental failures with the increased use of software in life-critical systems (such as autonomous vehicles and autonomous weapons). The C++ community has not done so. Turn authentication on!

C++ 139

C++ Programming Code Java 139

Brendan Gregg

NOVEMBER 29, 2017

In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. AWS has a name for their Bare Metal platform: it's the "Nitro system".

Virtualization 111

Virtualization AWS Hardware Storage 111

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. Microbenchmark os::javaTimeMillis() on both systems.

Speed 40

Speed Java AWS Virtualization 40

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. Microbenchmark os::javaTimeMillis() on both systems.

Speed 52

Speed Java AWS Virtualization 52

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

All Things Distributed

OCTOBER 25, 2018

With the AWS based system, Exatype can do this at a fraction of the cost. Since it launched in 2014, more than 9 million people have saved or borrowed on the JUMO platform. What would have taken two weeks on local servers now only takes a few minutes. Traditionally, it cost $300 to $500 to do a single resistance test.

AWS 167

AWS Cloud Education Programming 167

Dynatrace

FEBRUARY 25, 2021

Since its introduction by AWS in 2014, AWS Lambda has revolutionized the compute space and boosted the entire serverless movement. Lambda functions often serve as a gluing tier or a gateway from on-premises systems to AWS services; they’re almost never standalone. Dynatrace news. Why metrics alone aren’t enough. What’s next.

Lambda 221

Lambda AWS Monitoring Serverless 221

All Things Distributed

APRIL 4, 2017

In 2014 and 2015 respectively, AWS opened offices in Stockholm and Espoo, Finland. Scania is planning to use AWS for their connected vehicle systems, which allows truck owners to track their vehicles, collect real-time running data, and run diagnostics to understand when maintenance is needed to reduce vehicle downtime.

AWS 117

AWS Airlines Latency Games 117

Brendan Gregg

NOVEMBER 28, 2017

In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. AWS has a name for their Bare Metal platform: it's the "Nitro system".

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

APRIL 8, 2019

These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. This 14nm first-generation AMD EPYC 7551 processor has 32 cores and 64 threads, and it works in one or two-socket servers. This makes it a good choice for many SQL Server workloads, especially DW workloads.

Azure 42

Azure Virtualization Storage Benchmarking 42

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

The Morning Paper

AUGUST 27, 2019

I am so pleased to see a database systems paper addressing the concerns of the application developer! To the developer, a strongly consistent system behaves exactly like a single-threaded system running on a single node, so reasoning about the behaviour of the system is simple 1. VLDB’19.

Programming 59

Programming Processing Database Systems 59

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

Brendan Gregg

AUGUST 8, 2017

Linux load averages are "system load averages" that show the running thread (task) demand on the system as an average number of running plus waiting threads. This measures demand, which can be greater than what the system is currently processing. then your system is idle. - cat /proc/loadavg. 42/3411 43603. 42/3411 43603.

Latency 111

Latency Metrics C++ Systems 111

KeyCDN

OCTOBER 10, 2018

Although a beta version was released in 2014, the first stable release of Kubernetes was just made available in September 2018. That’s why Google set out to develop an open source system that would simplify the “deployment, scaling and operations” of containerized applications across multiple hosts.

Virtualization 47

Virtualization Open Source Network Architecture 47

Enprowess

SEPTEMBER 28, 2021

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. . You will get add-ons like server-side rendering, routing and more. The DOM structure is surrounded by Inferno for browser/server edits. Inferno Pros.

Open Source 52

Open Source Mobile Entertainment Virtualization 52

High Scalability

NOVEMBER 16, 2018

Unwelcome Gaze is a triptych visualizing the publicly reachable web server infrastructure of Google, Facebook, Amazon and the routing graph(s) leading to them. Doubleslash : Back in 2014 OpenStack may have been a thing but nowadays, 4 years later, people learned a lesson. It's HighScalability time: Beautiful. I'd really appreciate it.

Internet 28

Internet Internet Scalability Energy 28