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

SQL Performance

JULY 11, 2019

Connecting to SQL Server 2012 or better, or Azure SQL Database. And recommended system configuration: Two or more cores 8GB or more of memory Operating Systems: Windows (8.1 / Server 2012 R2 or better) macOS (10.13 In a new query window, establish a connection to a server, and write or paste a query.

Azure 90

Azure Servers Tuning Operating System 90

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 Performance

MARCH 15, 2021

In my last post , I illustrated one reason you should stop using deprecated system tables like sysprocesses. Since SQL Server 2012 (and, to a much lesser extent, since SQL Server 2008), the most complete and flexible solution for monitoring events on a SQL Server instance has been Extended Events.

Servers 64

Servers Azure Best Practices Monitoring 64

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

All Things Distributed

AUGUST 17, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 17 August 2012 07:00 PM. I am in São Paolo, Brazil for the 2012 AWS Latin America Summit and for The Next Web Latin America conference. Several of the principles from this paper have made it into systems I have since built.

Architecture 95

Architecture AWS Internet Internet 95

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

All Things Distributed

MAY 8, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 08 May 2012 02:00 PM. Amazon RDS for SQL Server. We introduced Amazon RDS for Oracle last year , and based on the demand from our Windows customers, are introducing Amazon RDS for SQL Server today. Comments ().

Cloud 115

Cloud Development AWS Servers 115

Smashing Magazine

NOVEMBER 8, 2018

Sharing Data Among Multiple Servers Through AWS S3. Sharing Data Among Multiple Servers Through AWS S3. After the file is uploaded to a server on step 1, the file must be available to whichever server handles the request for steps 2 and 3, which may or may not be the same one for step 1. Leonardo Losoviz.

AWS 44

AWS Servers Storage Cloud 44

All Things Distributed

OCTOBER 2, 2017

With these requirements in mind, and a willingness to question the status quo, a small group of distributed systems experts came together and designed a horizontally scalable distributed database that would scale out for both reads and writes to meet the long-term needs of our business. This was the genesis of the Amazon Dynamo database.

Internet 128

Internet Internet AWS Performance 128

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

All Things Distributed

MARCH 5, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 05 March 2012 02:01 PM. AWS today announced a substantial price drop from March 1, 2012 for many of the Amazon EC2, Amazon RDS, and Amazon ElastiCache instances types around the world. All Things Distributed. Comments ().

AWS 110

AWS Innovation Scalability Cache 110

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

All Things Distributed

NOVEMBER 13, 2018

In 2012, Amazon opened its first Italian office and its first Italian point of presence (PoP) based in Milan. This includes system integration (SI) and independent software vendor (ISV) partners who have built cloud practices and innovative technology solutions using AWS. Since then, AWS has added another PoP in Palermo in 2017.

AWS 167

AWS Energy Automotive Traffic 167

SQL Performance

AUGUST 15, 2019

Connecting to SQL Server 2012 or better, or Azure SQL Database. And recommended system configuration: Two or more cores 8GB or more of memory Operating Systems: Windows (8.1 / Server 2012 R2 or better) macOS (10.13 In a new query window, establish a connection to a server, and write or paste a query.

Azure 50

Azure Servers Tuning Operating System 50

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. Full backups are most suitable for critical systems or sensitive data that cannot afford any loss or downtime, allowing for a complete recovery of data in the event of data corruption, hacking, system failures, or natural disasters.

Storage 67

Storage Strategy Network Efficiency 67

The Netflix TechBlog

DECEMBER 17, 2019

In order to be supported, a database is required to fulfill a set of features that are commonly available in systems like MySQL, PostgreSQL, MariaDB, and others. We want to support these systems as a source so that they can provide their data for further consumption. Some of DBLog’s features are: Processes captured log events in-order.

Database 197

Database Traffic Transportation Open Source 197

All Things Distributed

SEPTEMBER 21, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 21 September 2012 06:00 PM. Of the work that is already public the systems that Uplynk has built for Disney/ABC are impressive. All Things Distributed. Back-to-Basics Weekend Reading - Leases. Comments (). Gray and David R.

AWS 75

AWS Media Cache Operating System 75

Smashing Magazine

AUGUST 20, 2021

Yet, for all these technological developments, it’s interesting that many of us are still serving sites in the same way Tim did with the very first website — a web server serving static website files. These desktop applications incremented the tooling an inch closer to the modern Jamstack content management systems of today.

Ecommerce 139

Ecommerce Website Government Internet 139

The Netflix TechBlog

DECEMBER 17, 2019

In order to be supported, a database is required to fulfill a set of features that are commonly available in systems like MySQL, PostgreSQL, MariaDB, and others. We want to support these systems as a source so that they can provide their data for further consumption. Some of DBLog’s features are: Processes captured log events in-order.

Database 212

Database Traffic Transportation Open Source 212

All Things Distributed

FEBRUARY 18, 2013

Werner Vogels weblog on building scalable and robust distributed systems. OpsWorks provides an event-driven configuration system with rich deployment tools that allow you to efficiently manage applications over their lifetime, including support for customizable deployments, rollback, patch management, auto scaling, and auto healing.

AWS 157

AWS Cloud Architecture Infrastructure 157

All Things Distributed

JANUARY 23, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 23 January 2012 12:01 AM. All Things Distributed. Expanding the Cloud - The AWS Storage Gateway. Comments (). Once the AWS Storage Gatewayâ??s

Storage 115

Storage AWS Virtualization Cloud 115

All Things Distributed

MAY 13, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 14 May 2012 12:01 AM. The first set of features that CloudFront is launching today include: Multiple Origin Servers: the ability to specify multiple origin servers, including a default origin, for a CloudFront download distribution.

Cache 117

Cache Latency AWS Website 117

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

All Things Distributed

APRIL 5, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 06 April 2012 06:00 AM. Troy: We moved our service from internal servers to AWS. Lack of root access to the underlying server OS was unique – but we have found it does not hinder us in anyway. All Things Distributed.

Innovation 146

Innovation AWS Education Network 146

Alex Russell

MARCH 6, 2021

The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively. If those specs sound eerily familiar, it's perhaps because they're identical to 2016's $200USD Moto G4 , all the way down to the 2011-vintage 28nm SoC process node used to fab the chip's anemic, 2012-vintage A53 cores. Tap for a larger version.

Performance 124

Performance Network Cache Metrics 124

All Things Distributed

SEPTEMBER 25, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 25 September 2012 06:00 PM. If you are using the SQL Server database engine, you can provision from 1,000 IOPS to 7,000 IOPS. All Things Distributed. Expanding the Cloud â?? Provisioned IOPS for Amazon RDS. Comments ().

Cloud 117

Cloud AWS Storage Database 117

SQL Server According to Bob

NOVEMBER 29, 2016

Back in June, Bob Dorr gave you the thinking behind why SQL Server 2016 It Just Runs Faster due to changes in our SQL Server and NUMA configurations. Bob blogged about a new SQL Server 2016 feature called Auto Soft NUMA. 144 total logical processors as exposed by the Windows OS and seen by SQL Server.

Servers 45

Servers Virtualization Scalability Hardware 45

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. They were being launched piecemeal, improving performance of pre-Nitro systems. 0% performance overhead. Run whatever you like: Xen, KVM, containers.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

SEPTEMBER 2, 2021

UPDATE: September 2nd, 2021 (Originally published July 26th, 2012.). SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1. STRING_SPLIT() in SQL Server 2016 : Follow-Up #2.

C++ 59

C++ Servers Testing Database 59

All Things Distributed

JANUARY 18, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 18 January 2012 07:00 AM. The original Dynamo design was based on a core set of strong distributed systems principles resulting in an ultra-scalable and highly reliable database system. All Things Distributed. Comments ().

Scalability 167

Scalability Database Ecommerce Latency 167

All Things Distributed

AUGUST 16, 2012

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 16 August 2012 10:00 AM. 3-Year Heavy Utilization Reserved Instances offer the maximum savings over equivalent servers deployed in an on-premises environment. All Things Distributed. Total Cost of Ownership and the Return on Agility.

AWS 118

AWS Hardware Traffic Best Practices 118

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. Introduction. instructions are available.

Servers 67

Servers Testing Metrics Storage 67

Smashing Magazine

APRIL 1, 2020

In the end, youll have built a shopping cart using GraphCMS (a (backend-only content management system). A scalable, cross-platform content management system is crucial to ensuring a product’s growth velocity. It was developed by Facebook in 2012 and released open-sourced in 2015. Using GraphCMS. GraphCMS And GraphQL.

Open Source 103

Open Source Website Mobile Code 103

Smashing Magazine

APRIL 9, 2019

Most sites were all hosted on a single physical server somewhere on our own hosting infrastructure, and it was the server we thought about defending when it came to security best practices. Let’s imagine that it’s 2012 and everyone is using the brand new jQuery 1.8. file hosted as part of their own website on their own server.

Website 58

Website Servers Code Best Practices 58

ScaleOut Software

MAY 15, 2014

For example, the IMDG must be able to efficiently create millions of objects in each server to make use of its huge storage capacity. Given all this, we thought it would be a good opportunity to see how we are doing relative to the competition, and in particular, relative to Microsoft’s AppFabric caching for Windows on-premise servers.

Cache 40

Cache Servers Network Design 40

Percona

JANUARY 14, 2019

In a partitioned massively parallel database system, the storage format and sorting algorithm may not be optimized for that operation as we are reading multiple partitions in parallel. ClickHouse is a great massively parallel analytical system. blockade','arizona'] ? ? protests','occupy','romney','weiner','protesters'] ? ? Conclusion.

Database 40

Database Analytics Blockchain Healthcare 40