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

The Netflix TechBlog

APRIL 17, 2019

Netflix headquarters circa 2014. AOM has produced the reference software for AV1, which is called libaom and is available online. SVT-AV1 uses parallelization at several stages of the encoding process, which allows it to adapt to the number of available cores including newest servers with significant core count.

Open Source 166

Open Source Scalability Speed Efficiency 166

SQL Server According to Bob

JULY 12, 2016

For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. For SQL Server 2016 the trace flags are available but the behavior may be altered by the design changes. The SQL Server 2016 design change uses the CheckScanner instead of the MultiObjectScanner improving I/O behavior.

Servers 40

Servers Design Engineering Database 40

SQL Performance

JULY 1, 2019

The results are technically non-deterministic since SQL Server could validly return any one of the rows in each group. Nevertheless, if you run this query yourself, you are quite likely to see the same result I do: The execution plan depends on the version of SQL Server used, and does not depend on database compatibility level.

C++ 58

C++ Servers Database Performance 58

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). DMV data is always available, so very often it's the easiest method to get a quick first look at query performance. Each option has pros and cons. CROSS APPLY sys. CROSS APPLY sys.

C++ 74

C++ Database Servers Tuning 74

Brendan Gregg

JULY 2, 2021

The architecture is: While the bpftrace binary is installed on all the target systems, the bpftrace tools (text files) live on a web server and are pushed out when needed. As an extreme example, I wrote cachestat(8) while on vacation in 2014 for use on the Netflix cloud, which was a mix of Linux 3.2 It depends on the tool. at the time.

Open Source 40

Open Source Latency Cache Energy 40

Brendan Gregg

MARCH 16, 2024

This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." 2014: Java in Flames Broken Java Stacks (2014) When I joined Netflix in 2014, I found Java's lack of frame pointer support broke all application stacks (pictured in my 2014 Surge talk on the right).

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. Increased availability.

Development 250

Development Serverless Best Practices Lambda 250

SQL Performance

JULY 24, 2022

SQL Server 2012 went out of all forms of official support about two weeks ago, on July 12 th. Best approaches for running totals – updated for SQL Server 2012. In the very first post on this site, I compared the performance of long-standing running totals methods with the new windowing functions added in SQL Server 2012.

Servers 66

Servers Strategy Availability Processing 66

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

Dynatrace

SEPTEMBER 29, 2020

Since we moved to AWS in May 2014 we have had an availability of 99.95%! On one hand, they enable our engineers to get their latest enhancements deployed into production. On the other, they enable everyone at Dynatrace through self-service to do their part ensuring. Sydney, we have a disk write latency problem!

Infrastructure 179

Infrastructure Cloud Monitoring AWS 179

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. This server is spending about a third of its CPU cycles just checking the time! How long does it take to read the time?

Speed 126

Speed Java AWS Virtualization 126

The Morning Paper

FEBRUARY 11, 2020

In a model for others to follow, the Caddy web server will automatically provision Let’s Encrypt certificates. Apache and Nginx remain the most popular Let’s Encrypt using web servers deployed in the wild though. Continuous availability via the facility to run multiple redundant instances of each function in parallel.

Internet 119

Internet Internet Open Source Transportation 119

CSS Wizardry

MARCH 3, 2019

This includes CDNs, proxy servers, and the like. Once the 60 seconds is up, the browser will head back to the server to revalidate the file. It means ‘do no t serve a copy from cache until you’ve revalidated it with the server and the server said you can use the cached copy’. public and private. Cache-Control: no-cache.

Cache 264

Cache Latency Strategy Servers 264

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. The Kube-scheduler schedules the pods, allocating available resources based on the CPU and memory requirements of each node. Resource optimization.

Virtualization 133

Virtualization DevOps Infrastructure Cloud 133

SQL Performance

MAY 1, 2019

The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking. The inputs to this calculation are: The version of SQL Server. The estimated number of rows leading into the Insert operator.

Servers 47

Servers Database Testing Performance 47

All Things Distributed

OCTOBER 25, 2018

The new AWS Africa (Cape Town) Region will have three Availability Zones and provide lower latency to end users across Sub-Saharan Africa. We already have 55 Availability Zones across 19 infrastructure regions that customers can use today. What would have taken two weeks on local servers now only takes a few minutes.

AWS 167

AWS Cloud Education Programming 167

Sutter's Mill

MARCH 11, 2024

Some rules, such as ones that rely on interprocedural analysis of full call trees, are inherently nondeterministic (because an implementation gives up when fully evaluating a case exceeds the space and time available; a.k.a. Kubernetes Secrets on public GitHub repos), misconfigured servers (e.g., best effort” analysis).

C++ 139

C++ Programming Code Java 139

Brendan Gregg

NOVEMBER 29, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. When I joined Netflix in 2014, we had begun transitioning from PV to HVM (PVHVM). This recommendation quickly became out of date.

Virtualization 111

Virtualization AWS Hardware Storage 111

Dynatrace

FEBRUARY 25, 2021

Since its introduction by AWS in 2014, AWS Lambda has revolutionized the compute space and boosted the entire serverless movement. To handle N parallel requests, N Lambda instances need to be available, and AWS will spin up up to 1000 such instances automatically to handle 1000 parallel requests. Dynatrace news. What’s next.

Lambda 218

Lambda AWS Monitoring Serverless 218

All Things Distributed

APRIL 4, 2017

The new AWS EU (Stockholm) Region will have three Availability Zones and will be ready for customers to use in 2018. As a result, we have opened 42 Availability Zones across 16 AWS Regions worldwide. In 2014 and 2015 respectively, AWS opened offices in Stockholm and Espoo, Finland.

AWS 117

AWS Airlines Latency Games 117

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. This server is spending about a third of its CPU cycles just checking the time! How long does it take to read the time?

Speed 40

Speed Java AWS Virtualization 40

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

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. This server is spending about a third of its CPU cycles just checking the time! How long does it take to read the time?

Speed 52

Speed Java AWS Virtualization 52

Abhishek Tiwari

NOVEMBER 3, 2018

If you put your whole website on CDN, technically you don’t need a large number of server infrastructure and CMS licenses. They often get blindsided by vendor’s pitch and end-up making decision based on some fancy demos (see my post from 2014 on Adobe AEM ). Circa 2014, I was working with a big Japanese automotive brand in Australia.

Systems 63

Systems Cache Website Network 63

SQL Performance

APRIL 8, 2019

These VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Since then, Microsoft has changed the naming of this series to Lsv2.

Azure 42

Azure Virtualization Storage Benchmarking 42

Enprowess

JANUARY 11, 2022

With a myriad of options available out there, we have compiled a list of top frontend frameworks out there to help you out. Many front end frameworks are available in different languages. Of all the available technologies, JavaScript popularity has shot up exponentially. Easy to perform Ajax requests with a dedicated server.

Virtualization 64

Virtualization Website Speed Mobile 64

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. When I joined Netflix in 2014, we had begun transitioning from PV to HVM (PVHVM). This recommendation quickly became out of date.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented.

Servers 95

Servers Tuning Architecture Processing 95

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. A Kubernetes cluster typically consists of: The Master Server The master server is the primary machine responsible for facilitating communication between the cluster’s different components.

Virtualization 47

Virtualization Open Source Network Architecture 47

SQL Performance

APRIL 23, 2019

In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate. SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. instructions are available. Introduction.

Servers 67

Servers Testing Metrics Storage 67

Enprowess

SEPTEMBER 20, 2021

Talent availability. Created by Evan You, Vue had its first public appearance in 2014. It has a vast community that explains online courses, many available tutorials, articles, and three times more questions on Stack overflow. Vue vs React: Talent Availability. Server-Side Rendering. and Vue.js Performance.

Open Source 52

Open Source Mobile Scalability Google 52

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

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016.

Cache 64

Cache Testing Servers Code 64

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. Backbone.js

Open Source 52

Open Source Mobile Entertainment Virtualization 52

O'Reilly

JULY 25, 2023

To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022. This choice also inspired me to call my project Swift Papers. But still, I liked how Moment.js

Programming 98

Programming Code Design Benchmarking 98