SQL Performance

MAY 16, 2019

Without this guarantee, SQL Server might add index rows that are not sorted correctly, which would not be good. For INSERT.SELECT , SQL Server makes its own determination whether to ensure rows are presented to the Clustered Index Insert operator in key order or not. DMLRequestSort Conditions.

Cache 67

Cache Servers Testing Storage 67

Dynatrace

APRIL 2, 2020

It evolved from the simplest web server plugins to runtime Java profilers to real-time performance monitoring of all transactions flowing end to end through application servers. The market grew tremendously, fueled by the adoption of the Java platform as the application server standard. .” The AppMon wave.

Network 165

Network Traffic Monitoring Java 165

SQL Performance

MARCH 15, 2021

This time around, I want to talk about a feature included with SQL Server client tools that we should not be using these days – not just because it is deprecated but, more importantly, because it has the potential to completely take a server down: SQL Server Profiler. Not too long ago, something like this happened to us.

Servers 64

Servers Azure Best Practices Monitoring 64

SQL Shack

MAY 27, 2019

Introduction SQL Server Always On is a high availability and disaster recovery solution available starting from SQL Server 2012. In this article, we will explore configuring Read Scale Availability Group that does not require a failover clustering configuration. It requires […].

Availability 49

Availability Servers 49

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

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT.

C++ 111

C++ Database Servers Code 111

Alex Russell

FEBRUARY 28, 2022

Tim Berners-Lee tweets that 'This is for everyone' at the 2012 Olympic Games opening ceremony using the NeXT computer he used to build the first browser and web server. Regardless of architecture, Gmail needs to send an HTTP request to the server and update some HTML when the server replies. This Is for Everyone #.

Performance 104

Performance Latency Architecture Network 104

All Things Distributed

AUGUST 17, 2012

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. Werner Vogels weblog on building scalable and robust distributed systems. Back-to-Basics Weekend Reading - Staged Event-Driven Architecture. Comments (). Contact Info.

Architecture 95

Architecture AWS Internet Internet 95

All Things Distributed

MAY 8, 2012

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

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 110

Performance Latency Cache Virtualization 110

Smashing Magazine

OCTOBER 19, 2021

You’ve probably heard about Serverless Functions, but if you haven’t, Serverless Functions provide functionality typically associated with server-side technologies that can be implemented alongside front-end code without getting caught up in server-side infrastructures. Start Development Server. npm run develop. npm run develop.

Serverless 111

Serverless Cloud Website Servers 111

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

John McCalpin

JANUARY 9, 2019

This week I updated three of those posts — two really old ones (primarily of interest to computer architecture historians), and one from 2018: July 2012: Local and Remote Memory Latency on AMD Processors in 2-socket and 4-socket servers. December 2013: Notes on Memory Bandwidth on the Xeon Phi (Knights Corner) Coprocessor.

Latency 40

Latency Architecture Servers Performance 40

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.

Open Source 52

Open Source Servers Storage Scalability 52

All Things Distributed

MARCH 5, 2012

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. We continuously apply all our innovative skills to the design of datacenters, servers, storage, network, etc. Comments ().

AWS 110

AWS Innovation Scalability Cache 110

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. We needed to serve our growing base of startup, government, and enterprise customers across many vertical industries, including automotive, financial services, media and entertainment, high technology, education, and energy.

AWS 167

AWS Energy Automotive Traffic 167

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.

Performance 52

Performance Latency Hardware Storage 52

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

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 52

Performance Latency Cache Virtualization 52

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

Tim Kadlec

DECEMBER 29, 2015

If your client-side MVC framework does not support server-side rendering, that is a bug. 2012 Favorites. This year, it was about Apple’s influence over the standardization process after some fallout around the Pointer Events specification. Client-side MVC’s Major Bug. Choosing Performance. Other years. 2014 Favorites.

Energy 40

Energy Google Servers Processing 40

All Things Distributed

JANUARY 23, 2012

By Werner Vogels on 23 January 2012 12:01 AM. s software appliance is installed on a local host, you can mount Storage Gateway volumes to your on-premises application servers as iSCSI devices, enabling a wide variety of systems and applications to make use of them. All Things Distributed. Expanding the Cloud - The AWS Storage Gateway.

Storage 115

Storage AWS Virtualization Cloud 115

All Things Distributed

SEPTEMBER 25, 2012

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. The Amazon RDS Provisioned IOPS storage option is available for all engines supported by Amazon RDS: MySQL, Oracle, and Microsoft SQL Server. All Things Distributed. Comments ().

Cloud 117

Cloud AWS Storage Database 117

All Things Distributed

APRIL 5, 2012

By Werner Vogels on 06 April 2012 06:00 AM. Troy: We moved our service from internal servers to AWS. We consulted directly with Amazon and learned that the storage and the DB Server size affected I/O throughput – after altering our size we dropped our load time to 1 hour which was within expectations relative to native database.

Innovation 146

Innovation AWS Education Network 146

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

All Things Distributed

AUGUST 16, 2012

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. Werner Vogels weblog on building scalable and robust distributed systems. Total Cost of Ownership and the Return on Agility.

AWS 118

AWS Hardware Traffic Best Practices 118

SQL Performance

JULY 24, 2022

SQL Server 2012 went out of all forms of official support about two weeks ago, on July 12 th. And this site turns 10 years old today – the first post was on July 24 th , 2012. Best approaches for running totals – updated for SQL Server 2012. A Big Deal : SQL Server 2016 Service Pack 1.

Servers 66

Servers Strategy Availability Processing 66

Dynatrace

JUNE 16, 2022

In 2012, Gartner coined the term RASP to characterize this approach, which brings the security perimeter right to the application itself. A centralized approach to WAF uses a single firewall to protect many application servers against large-scale distributed attacks.

Tuning 220

Tuning Cloud Open Source Network 220

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. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

The Morning Paper

FEBRUARY 11, 2020

This paper tells the story of Let’s Encrypt, from it’s early beginnings in 2012/13 all the way to becoming the world’s largest HTTPS Certificate Authority (CA) today – accounting for more currently valid certificates than all other browser-trusted CAs combined. CCS’19. In the beginnning. The last word.

Internet 119

Internet Internet Open Source Transportation 119

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. Background. The Query Optimizer.

Servers 75

Servers Engineering Efficiency Retail 75

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

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. or better).

Azure 90

Azure Servers Tuning Operating System 90

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

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

The Netflix TechBlog

AUGUST 29, 2023

These design principles led us to client-side load-balancing, and the 2012 Christmas Eve outage solidified this decision even further. IPC clients are instantiated targeting that VIP or SVIP, and the Eureka client code handles the translation of that VIP to a set of IP and port pairs by fetching them from the Eureka server.

Traffic 220

Traffic Latency Cloud C++ 220

SQL Performance

APRIL 18, 2022

It’s no surprise even highly experienced SQL Server users tend to get this wrong, given the contradictory information often supplied to us. Let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14, with database compatibility set to 150. Parameterization Not Attempted. DisplayName , LOWER ( U.

Cache 58

Cache Servers Database Testing 58