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. Another major trend is using multiple third-party components and services, which may be not easy to properly incorporate into testing. – Cloud.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

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. ALTER DATABASE [ WideWorldImporters ] SET QUERY_STORE = ON ; GO. sort, hash).

Servers 41

Servers Cache Database Metrics 41

SQL Performance

NOVEMBER 1, 2019

As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features.

Servers 40

Servers Hardware Database Availability 40

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

Percona

FEBRUARY 2, 2023

Recall that logical replication works by using the PUB/SUB mode, where individual tables are published and are then subscribed by remotely connected databases/tables. The only real limitation is that one can only publish tables from a read-write server such as the PRIMARY. DML operations, such as INSERT, UPDATE, DELETE, TRUNCATE, etc.,

Games 87

Games Open Source Tuning Speed 87

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. Such “torn pages” are corruptions from the database point of view. This is generally referred to as “ partial page writes ” or “ torn pages.”

Database 115

Database Benchmarking Open Source Latency 115

Percona

SEPTEMBER 19, 2023

This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Physical backups are the backups that consist of raw copies of the directories and files that store database contents. Copyright (c) 2016, 2023, Oracle and/or its affiliates. Type 'help' or '?'

C++ 102

C++ Servers Storage Speed 102

SQL Performance

JULY 27, 2021

Continuing my series of articles on latches, this time I’m going to discuss the DBCC_OBJECT_METADATA latch and show how it can be a major bottleneck for consistency checks prior to SQL Server 2016 under certain circumstances. But remember, this bottleneck only happens for versions of SQL Server earlier than SQL Server 2016.

C++ 54

C++ Servers Database Code 54

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

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>). That is to ensure your database is encrypted at the file level.

Servers 40

Servers Database Azure Cache 40

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

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. 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.

C++ 52

C++ Servers Code Efficiency 52

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

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.

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.

Servers 40

Servers Database Processing Virtualization 40

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. You can create supporting tables in the user database if needed.

C++ 114

C++ Servers Testing Processing 114

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

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 following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model.

Servers 47

Servers Database Testing Performance 47

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 124

Performance Network Cache Metrics 124

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. 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.

C++ 59

C++ Servers Testing Database 59

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016.

Cache 64

Cache Testing Servers Code 64

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. Testing different base table cardinalities is just one dimension to try. You can create supporting tables in the user database if needed.

C++ 61

C++ Servers Testing Processing 61

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). Once the connection to SQL Server is established the APP executes the odbc! Microsoft specific implementation for DTC using (OLE-TX).

Servers 40

Servers Azure Engineering Java 40

Percona

JANUARY 17, 2019

I will compare AWS Aurora with MySQL (Percona Server) 5.6 Test data and versions. For my test, I need to choose: Aurora instance type and comparison. 84.1 | | version_comment | Percona Server (GPL), Release 84.1, running on an EC2 instance of the same class. MySQL on ec2. MySQL on ec2.

Cache 46

Cache C++ AWS Airlines 46

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

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

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. Test ; END ; GO. DMLRequestSort Conditions. DROP TABLE dbo.

Cache 67

Cache Servers Testing Storage 67

Smashing Magazine

OCTOBER 26, 2018

It’s an all-in-one system that is equipped with a working admin interface; it manages database connection, and has a bunch of useful APIs exposed that handle user authentication, routing, and more. on December 6th, 2016. I’m working on Varying Vagrant Vagrants , and have set up a test site with an URL [link]. Large preview ).

Cache 78

Cache Website Speed Database 78

Brendan Gregg

NOVEMBER 29, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. My colleague Amer Ather was responsible for testing it and making it work at Netflix, and posted some of his results: [2 Million Packets Per Second on a Public Cloud Instance]. The first was c3. AWS called this [enhanced networking].

Virtualization 111

Virtualization AWS Hardware Storage 111

Alex Russell

MAY 9, 2022

Improving latency and reducing variance allows teams to test other product hypotheses with less noise. Even junior PM s internalise the notion that product quality is at risk if tests are not built, automated, and tracked. These tests are expensive to run, so they must be chosen well. Protecting the Commons #.

Performance 86

Performance Latency Metrics Engineering 86

The Symphonia

DECEMBER 6, 2017

We plan to test this out when we get the chance. without web app servers?—?to Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. There have been some improvements since re:Invent 2016 but to see nothing announced at this re:Invent was very disappointing. But this year?

Serverless 40

Serverless Lambda AWS Traffic 40

Brendan Gregg

NOVEMBER 28, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. My colleague Amer Ather was responsible for testing it and making it work at Netflix, and posted some of his results: [2 Million Packets Per Second on a Public Cloud Instance]. The first was c3. AWS called this [enhanced networking].

Virtualization 40

Virtualization AWS Hardware Storage 40