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. I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. Change the Target Recovery Time of a Database. ( WHERE. (

C++ 58

C++ Database Servers Storage 58

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++ 101

C++ Servers Storage Speed 101

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

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

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

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

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. Is MongoDB free to use?

Open Source 81

Open Source Programming Database Servers 81

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 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. Create / Alter Database … LOG ON. NVDIMM is measured in nanoseconds.

Cache 40

Cache Servers Media Storage 40

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Processed 4.15

Database 40

Database Analytics Blockchain Healthcare 40

SQL Performance

JUNE 22, 2021

The FGCB_ADD_REMOVE latch protects a data structure called an FGCB, or File Group Control Block, and there will be one of these latches for each online filegroup of each online database in a SQL Server instance. DROP EVENT SESSION [ FGCB_ADDREMOVE ] ON SERVER ; END. Showing the Bottleneck. ( SELECT * FROM sys.

Servers 54

Servers Database Code Performance 54

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

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. Cloud seriously impacts system architectures that has a lot of performance-related consequences. First, we have a shift to centrally managed systems.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

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

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

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). In order to use Query Store and Extended Events, you have to configure them in advance – either enabling Query Store for your database(s), or setting up an XE session and starting it.

C++ 74

C++ Database Servers Tuning 74

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

SQL Performance

APRIL 8, 2019

These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. This 14nm first-generation AMD EPYC 7551 processor has 32 cores and 64 threads, and it works in one or two-socket servers. Both of these Intel processors are special bespoke models that are not in the Intel ARK database.

Azure 42

Azure Virtualization Storage Benchmarking 42

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

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

MAY 7, 2019

I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server. The execution of SQL Server’s internal code is done using a mechanism called threads. When that happens, SQL Server makes a note of why the thread had to wait and this is called the wait type.

Servers 40

Servers Metrics Azure Tuning 40

Brendan Gregg

NOVEMBER 29, 2017

In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. The first was c3. 0% performance overhead.

Virtualization 111

Virtualization AWS Hardware Storage 111

Alex Russell

MAY 9, 2022

Only teams that master their systems can make intentional trade-offs. Panglossian nonsense. --> Organisations that serve their tools tread water no matter how advanced their technology, while groups that intentionally manage systems can succeed on any stack. [1]. Performance isn't a binary and there are no silver bullets.

Performance 86

Performance Latency Metrics Engineering 86

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

Smashing Magazine

OCTOBER 26, 2018

WordPress core developers used a system of hooks which allowed other developers to modify or extend certain functionalities. 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.

Cache 79

Cache Website Speed Database 79

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. So, apart from powering servers with renewable energy, what else can web developers do about climate change? You Can’t Manage What You Can’t Measure”.

Website Performance 74

Website Performance Website Energy Performance 74

Smashing Magazine

JANUARY 21, 2019

An API is the communication channel for an application to load data from the server. Note : Brad Frost’s “ Atomic Design ” is a great methodology for identifying these common patterns and building a reusable design system. Brad Frost identifies five distinct levels in atomic design for creating design systems. Large preview ).

Social Media 65

Social Media Database Media Website 65

Brendan Gregg

NOVEMBER 28, 2017

In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. The first was c3. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40