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

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

Percona

FEBRUARY 2, 2023

The only real limitation is that one can only publish tables from a read-write server such as the PRIMARY. The challenge, of course, is reconstituting the logical replication process as quickly as possible, ideally without any data loss. DML operations, such as INSERT, UPDATE, DELETE, TRUNCATE, etc., And, of course, timing is critical.

Games 89

Games Open Source Tuning Speed 89

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

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 85

Programming Servers Database Hardware 85

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

Percona

SEPTEMBER 19, 2023

This issue most often occurs when there is significant MySQL server activity during the backup operation, and the redo log file storage media operates faster than the backup storage media. Enabling redo log archiving on the server requires setting a value for the innodb_redo_log_archive_dirs system variable. Type 'help' or '?'

C++ 105

C++ Servers Storage Speed 105

High Scalability

AUGUST 8, 2018

Niantic launched Pokémon GO in the summer of 2016. Prior to launch, they load-tested their software stack to process up to 5x their most optimistic traffic estimates. Pokémon GO’s success greatly exceeded the expectations of the Niantic engineering team. Figure 11-5. Pokémon GO (pre-GCLB).

Google 130

Google Games Entertainment Cloud 130

SQL Performance

OCTOBER 14, 2020

In Part 4 of the series, which focused on optimization of derived tables, I described a process of unnesting/substitution of table expressions. The TL;DR version of substitution/unnesting of CTEs is that the process is the same as it is with derived tables. You can find the script that creates and populates PerformanceV5 here.

C++ 52

C++ Servers Code Efficiency 52

Dynatrace

JUNE 7, 2019

ActiveGate OS: Ubuntu Server 16.04 LTS, RHEL server 7, CentOS server 7. Although, the upgrade process involves reinstallation of the ActiveGates that make this location or adding new ones enabled for synthetic monitoring. A: We currently support Ubuntu Server 16.04 Can I use it for browser monitors as well?

Network 163

Network Monitoring Servers Hardware 163

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

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. Yet here we are.

Database 109

Database Servers C++ AWS 109

SQL Performance

MAY 1, 2020

In a recent tip , I described a scenario where a SQL Server 2016 instance seemed to be struggling with checkpoint times. Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions.

C++ 58

C++ Database Servers Storage 58

SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. As the following diagram shows the SQL Server Log Cache is in memory.

Cache 40

Cache Servers Media Storage 40

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 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. Take GoSquared , a UK startup that runs all its development and production processes on AWS, as an example.

AWS 166

AWS Cloud Artificial Intelligence IoT 166

SQL Performance

DECEMBER 9, 2020

I mainly experimented with different table value constructor cardinalities, with serial versus parallel processing, and with row mode versus batch mode processing. The plan is serial, and all operators in the plan use row mode processing by default. Batch processing. Figure 5: Plan with batch processing.

C++ 114

C++ Servers Testing Processing 114

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. Advances in browser content processing. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively.

Performance 124

Performance Network Cache Metrics 124

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. 10 percent processed.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. 10 percent processed.

Servers 40

Servers Database Processing Virtualization 40

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

Dynatrace

OCTOBER 28, 2021

In 2010, Netflix introduced a technology to switch production software instances off at random — like setting a monkey loose in a server room — to test how the cloud handled its services. Thus, the tool Chaos Monkey was born. Any damage or influence caused by the test is known as the ‘blast radius.’

Engineering 234

Engineering Entertainment Cloud Infrastructure 234

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

FEBRUARY 10, 2019

. · Failures occur from remote clients or sqlcmd executed directory on the server (/opt/mssql-tools/bin). SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. Server is a Superdome with lots of CPUs and RAM. Here is an example of a valid SQL Server login. – sqlclr.

Servers 40

Servers Network Database Systems 40

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. looking out for MongoDB Inc.

Open Source 82

Open Source Programming Database Servers 82

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. In agile development / DevOps environments it should be interwoven with the whole development process. – Cloud. – Agile.

Performance Testing 100

Performance Testing Testing Performance DevOps 100

Brendan Gregg

OCTOBER 8, 2018

Some one-liners: # New processes with arguments bpftrace -e 'tracepoint:syscalls:sys_enter_execve { join(args->argv); }'. Files opened by process bpftrace -e 'tracepoint:syscalls:sys_enter_open { printf("%s %sn", comm, str(args->filename)); }'. Pages paged in by process bpftrace -e 'software:major-faults:1 { @[comm] = count(); }'.

C++ 110

C++ Virtualization Programming Latency 110

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Individual processes generate WAL records, and latency is very crucial for transactions. So it has never been part of the general advice for optimizations.

Database 117

Database Benchmarking Open Source Latency 117

SQL Server According to Bob

JUNE 9, 2016

SQL Server, as outlined in the following post ( [link] ) adjusts to various processor configurations. I have received questions related to how SQL Server accomplishes the alignment on both bare metal and VM installations. SQL Server uses Windows APIs to determine the processors and package interactions. GetSystemInfo [link].

Servers 40

Servers Virtualization Tuning Architecture 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

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

APRIL 20, 2021

This is the third in a five-part series taking a deep dive into the way SQL Server row mode parallel plans start executing. We are now ready to start the query scan, perform some early phase processing, and start the first additional parallel tasks. SQL Server could have been designed to start all the extra parallel bits all at once.

C++ 98

C++ Processing Servers Cache 98

SQL Performance

AUGUST 14, 2019

The performance penalty is relevant only when the window function is optimized with row-mode processing operators. SQL Server 2019 introduces batch mode on rowstore support, so you can get batch-mode processing even if there's no columnstore indexes present on the data. Figure 1: Plan for Query 1, row-mode processing.

Best Practices 108

Best Practices Servers Database Azure 108

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40

Servers Azure Engineering Java 40

SQL Performance

DECEMBER 9, 2020

I mainly experimented with different table value constructor cardinalities, with serial versus parallel processing, and with row mode versus batch mode processing. The plan is serial, and all operators in the plan use row mode processing by default. Batch processing. Figure 5: Plan with batch processing.

C++ 61

C++ Servers Testing Processing 61

Alex Podelko

OCTOBER 20, 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. I decided to publish a few parts here to see if anything triggers a discussion. It would be published as separate posts: – Introduction (a short teaser).

Performance Testing 100

Performance Testing Architecture Testing Performance 100

Alex Russell

FEBRUARY 3, 2023

Partisans for slow, complex frameworks have successfully marketed lemons as the hot new thing, despite the pervasive failures in their wake, and crowding out higher-quality options in the process. [1] "Server-Side Rendering", a.k.a. "SSR" " [ an intro to "isomorphic javascript", a.k.a. "Server-Side

Social Media 119

Social Media Website Technology Technology 119