SQL Performance

OCTOBER 14, 2020

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. Substitution/unnesting. Figure 4: Execution plan for Query 4.

C++ 140

C++ Servers Code Efficiency 140

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 Availability Monitoring 40

SQL Shack

AUGUST 13, 2020

This article continues from the series on SQL Server Always On Availability Group. This is the 11th article in this series.

Availability 98

Availability Servers 98

SQL Shack

JULY 13, 2020

In this series for SQL Server Always On availability groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In this article, we […].

Availability 77

Availability Servers Virtualization Network 77

SQL Shack

AUGUST 25, 2020

In the previous article, An overview of distributed SQL Server Always On Availability Groups, we explored the concept of the distributed availability groups in SQL Server always on availability group. It is available from Windows Server 2016 and SQL Server 2017.

Availability 76

Availability Servers 76

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. Instead the design of CMemThread was updated.

Servers 40

Servers Azure Software Engineering Design 40

Dynatrace

JUNE 7, 2019

ActiveGate OS: Ubuntu Server 16.04 LTS, RHEL server 7, CentOS server 7. A: We currently support Ubuntu Server 16.04 LTS, Red Hat server 7 and CentOS server 7 for the execution of private browser monitors; Windows Server 2016 support is coming soon as well.

Network 166

Network Monitoring Servers Hardware 166

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

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

MARCH 24, 2023

Originally developed as a research project at the University of California, Berkeley, in 2009, Mesos launched formally as a mature product in 2016 under the auspices of the Apache Software Foundation, a decentralized open source community.

Infrastructure 198

Infrastructure Open Source Operating System Cloud 198

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. This was a chance to talk about other things I've been working on, such as the present and future of hardware performance.

Performance 121

Performance Latency Hardware Storage 121

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Server According to Bob

JUNE 15, 2016

There is a MSVC, runtime library patch needed by SQL Server 2016 and without the patch the SQL Server service can simply terminate (crash.) This may not produce stack dumps and the SQL Server error log often looks like it simply terminates (no logging of shutdown.).

Software Engineering 40

Software Engineering Servers Database Engineering 40

All Things Distributed

DECEMBER 13, 2016

In just this past month we've had HSBC , ARM , Missguided , and most recently at re:Invent 2016 , Trainline , talking with us about how they are using AWS to transform and scale their businesses. I have been humbled by just how much our UK customers have been able to achieve using AWS technology so far.

AWS 157

AWS Cloud Artificial Intelligence IoT 157

High Scalability

AUGUST 8, 2018

Niantic launched Pokémon GO in the summer of 2016. Each cluster contained pods of Nginx instances, which served as Layer 7 reverse proxies that terminated SSL, buffered HTTP requests, and performed routing and load balancing across pods of application server backends. Figure 11-5. Pokémon GO (pre-GCLB).

Google 130

Google Games Entertainment Cloud 130

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

Servers 75

Servers Engineering Efficiency Retail 75

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.

Hardware 40

Hardware Servers Cache Software Engineering 40

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

SQL Performance

MARCH 20, 2020

We're mid-cycle between releases, where we're not yet hearing about any of the features planned for SQL Server vNext. In SQL Server 2016, STRING_SPLIT solved a long-missing gap in a language that, admittedly, was not intended for complicated string processing. And that is what I want to bring up today.

Database 109

Database Servers C++ AWS 109

Dynatrace

AUGUST 10, 2019

Windows 2016 Server (or a supported Linux distribution ). Browser monitors can now be executed from Windows-based ActiveGates. What you need to start synthetic monitoring with Windows ActiveGates. A synthetic-enabled environment ActiveGate: ActiveGate version 1.173+. Compliance with hardware requirements.

Monitoring 105

Monitoring Hardware Tuning Mobile 105

KeyCDN

MARCH 10, 2021

With Tel Aviv being the technology capital of Israel, it's the ideal edge server location. How to check a POP location Each edge server adds the HTTP response header X-Edge-Location delivered by KeyCDN. The image below shows a significant drop in latency once we've launched the new point of presence in Israel.

Latency 110

Latency Internet Internet Speed 110

High Scalability

AUGUST 9, 2018

One of the documents says in no uncertain terms that the company understands they will not be competitive in the server market until AFTER Sapphire Rapids, the 2022 server part. Uber : Since 2016, Uber has added several new lines of business to its platform, including Uber Eats, Uber Freight, and Jump Bikes.

Internet 21

Internet Internet Scalability Open Source 21

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 103

Performance Latency Cache Virtualization 103

SQL Shack

MARCH 4, 2021

Introduction Sometimes, query tuning operations can get very challenging and complicated in SQL Server. With the SQL Server 2016, a new feature Query Store has been introduced and this feature […].

Tuning 71

Tuning Servers Performance 71

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain.

Performance 127

Performance Network Metrics Cache 127

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 40

Scalegrid

JANUARY 19, 2024

Recovering from a MongoDB rollback involves locating rollback files, using mongorestore to load data into a separate server, cleansing unneeded data, and importing the data back into the primary cluster, coupled with ongoing monitoring and maintenance of replica sets to maintain system health.

Database 130

Database Network Servers Monitoring 130

SQL Server According to Bob

DECEMBER 26, 2017

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Q uick XE Trace ’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release. Here is an example using the SQL Server SSMS 2017 against my SQL 2016 server.

Servers 40

Servers Software Engineering Engineering Availability 40

SQL Server According to Bob

OCTOBER 3, 2016

Back in July, I told you about a new installation experience for SQL Server. Today, we are proud to announce Version 2 of the new SQL Server Installer. Now when you run the executable for the installer (for example, for SQL Server Developer it is called SQLServer2016-SSEI-Dev.exe you can use a /? SQL Server 2016 Express Edition.

Servers 40

Servers Development 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

Percona

FEBRUARY 2, 2023

The only real limitation is that one can only publish tables from a read-write server such as the PRIMARY. PGDATA on an Ubuntu install /var/lib/postgresql/15/main/pg_replslot/pg3 └── state However, the caveat is that it requires a full server restart to the REPLICA, in addition to being promoted, before the logical slot is fully active.

Games 95

Games Open Source Tuning Servers 95

SQL Performance

JUNE 5, 2019

One of the more perplexing problems to troubleshoot in SQL Server can be those related to memory grants. SQL Server’s optimizer estimates how much memory is needed, and the query must obtain the memory grant in order to start executing. EXEC [ Sales ] [ usp_OrderInfo_OrderDate ] '2016-01-01' , '2016-06-30' ; GO.

Servers 41

Servers Cache Database Metrics 41

Alex Podelko

OCTOBER 18, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Several tools recently announced integration with Continuous Integration Servers (such as Jenkins or Hudson). – Cloud. – Agile.

Performance Testing 100

Performance Testing Testing Performance DevOps 100

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

Brendan Gregg

OCTOBER 8, 2018

bpftrace has most of DTrace's capabilities and more. ## bpftrace The prior work that led to [bpftrace] (aka BPFtrace) is discussed my earlier [DTrace for Linux 2016] post, which explains how the Linux kernel gained [eBPF]: the virtual machine that we're using to run tracing programs. bcc is powerful but laborious to program.

C++ 105

C++ Virtualization Programming Latency 105

SQL Performance

DECEMBER 9, 2020

I tested my solutions in SQL Server 2019 Enterprise edition. SQL Server chose row mode processing for all previously shown solutions by default. There are a couple of ways to get SQL Server to use batch processing here. The main activity here that can benefit from batch processing is the row number computation.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

FEBRUARY 1, 2022

This is done to make managing operations in the transaction log easier for the log manager in SQL Server. You can’t specify how many VLFs are created by SQL Server when the database is first created or the log file automatically grows, but you can influence it. So why does SQL Server pick 37 and not 1 for the first VLF sequence number?

Architecture 53

Architecture Servers Virtualization Database 53