SQL Performance

JULY 11, 2019

There were some complications, as you can imagine; Plan Explorer is written using desktop technologies, and ADS is a whole new world. Connecting to SQL Server 2012 or better, or Azure SQL Database. After some discussion, we brought the concept to the leadership team, and set a plan in motion. or newer ( July announcement post ).NET

Azure 90

Azure Servers Tuning Operating System 90

All Things Distributed

MAY 8, 2012

By Werner Vogels on 08 May 2012 02:00 PM. You can then off load the management and scaling of your database and application stack to Amazon RDS and AWS Elastic Beanstalk , and focus on adding value to your customers. Amazon RDS currently supports SQL Server 2008 R2 and plans to add support for SQL Server 2012 later this year.

Cloud 115

Cloud Development AWS Servers 115

All Things Distributed

APRIL 11, 2012

By Werner Vogels on 12 April 2012 12:00 AM. s search technology to every developer. Search is a much broader technology than just the indexing of large collections of web pages. Their main motivation is that existing search technologies, both commercial and open source, have proven to be hard to manage and complex to configure.

Cloud 149

Cloud AWS Technology Technology 149

All Things Distributed

OCTOBER 8, 2014

The original Dynamo paper inspired many database solutions, which are now popularly referred to as NoSQL databases. These databases trade off complex querying capabilities and consistency for scale and availability. In 2012, we launched Amazon DynamoDB, the successor to Amazon Dynamo.

Availability 145

Availability Performance Scalability AWS 145

All Things Distributed

NOVEMBER 28, 2012

By Werner Vogels on 28 November 2012 09:00 AM. Unlike traditional row-based relational databases, which store data for each row sequentially on disk, Amazon Redshift stores each column sequentially. This means that Redshift performs much less wasted IO than a row-based database because it doesnâ??t Expanding the Cloud â??

Cloud 164

Cloud Storage Architecture Scalability 164

SQL Performance

FEBRUARY 22, 2021

We pay a lot of attention to latency here, along with any long-running transactions, because of downstream impact to technologies that use the log reader – like Availability Groups and transactional replication. Recently one of our teams was investigating a log reader latency issue. Sure, sys.sysprocesses has dbid and waittime.

Latency 57

Latency Servers Monitoring Systems 57

All Things Distributed

FEBRUARY 18, 2013

When a new app server instance starts, OpsWorks will use built-in recipes to configure the app server software and deploy your apps, and can also apply your specified recipes to make changes to your database and monitoring infrastructure. Operational Control â?? You can extend or modify pre-defined layers, or create your own from scratch.

AWS 157

AWS Cloud Architecture Infrastructure 157

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). The rapid acceleration in technology brought on a new discovery and paradigm.

Availability 40

Availability Servers Hardware Benchmarking 40

SQL Performance

AUGUST 15, 2019

There were some complications, as you can imagine; Plan Explorer is written using desktop technologies, and ADS is a whole new world. Connecting to SQL Server 2012 or better, or Azure SQL Database. After some discussion, we brought the concept to the leadership team, and set a plan in motion. or newer ( July announcement post ).NET

Azure 50

Azure Servers Tuning Operating System 50

All Things Distributed

APRIL 5, 2012

By Werner Vogels on 06 April 2012 06:00 AM. Often we think about innovation as doing new things or based on revolutionary new technologies such as DynamoDB, but it is more important to ensure that one can also innovate based on existing paradigms. Werner Vogels weblog on building scalable and robust distributed systems. Comments ().

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

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. The first was c3.

Virtualization 111

Virtualization AWS Hardware Storage 111

All Things Distributed

NOVEMBER 8, 2012

By Werner Vogels on 08 November 2012 03:00 PM. For example, AWS customers use SQS for asynchronous communication pipelines, buffer queues for databases, asynchronous work queues, and moving latency out of highly responsive requests paths. All Things Distributed. Werner Vogels weblog on building scalable and robust distributed systems.

Efficiency 104

Efficiency Cloud Games Scalability 104

All Things Distributed

AUGUST 20, 2012

By Werner Vogels on 21 August 2012 12:01 AM. From selecting the right technology, to maintaining multi-site facilities, to dealing with exponential and often unpredictable growth, to ensuring long-term digital integrity, digital archiving can be a major headache. All Things Distributed. Expanding the Cloud â?? Comments ().

Storage 122

Storage Cloud AWS Media 122

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. SQL 2016 – It Just Runs Faster: LDF Stamped.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Performance

JULY 16, 2019

If you have been paying attention to the technology press over the past 12-18 months, you may have noticed a rather large number of negative stories about Intel's processor business. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

O'Reilly Software

OCTOBER 23, 2018

A look at the roles of architect and strategist, and how they help develop successful technology strategies for business. I'm offering an overview of my perspective on the field, which I hope is a unique and interesting take on it, in order to provide context for the work at hand: devising a winning technology strategy for your business.

Strategy 100

Strategy Architecture Technology Technology 100

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. The first was c3.

Virtualization 40

Virtualization AWS Hardware Storage 40

Smashing Magazine

APRIL 1, 2020

Since the frontend and backend are separated from each other, it makes it possible for you to pick which front-end technology suits your needs. An open-source tool that wraps custom SQL databases with a dynamic API and provides an intuitive admin app for managing its content. Here are security measures for Drupal developers.

Open Source 105

Open Source Website Mobile Code 105

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 uses Vertipaq technology to determine a good way of sorting columns in each row group to give a good overall compression result. Introduction.

Servers 67

Servers Testing Metrics Storage 67