SQL Shack

OCTOBER 6, 2020

In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances. Introduction SQL Server 2017 & 2019 works on the cross-platform operating system: Windows and Linux. You […].

Servers 52

Servers Availability Operating System Systems 52

Percona

AUGUST 4, 2023

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. For MySQL, both releases are made by the same company (Oracle), follow the same version numbering, and the Enterprise version is a superset of what is available in Community.

Database 98

Database Servers Innovation Open Source 98

SQL Server According to Bob

OCTOBER 26, 2017

Please check out these new resources for SQL Server 2017 and SQL Server on Linux and Docker: Brk2045 upgrade sql server 2017 (on prem, iaa-s and paas) from Bob Ward. Brk2051 sql server on linux and docker from Bob Ward. SQL Server 2017 Release Notes. SQL Server on Linux Release Notes.

Servers 40

Servers Azure Open Source Database 40

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 75

Virtualization AWS Engineering Hardware 75

Dynatrace

OCTOBER 17, 2019

We’re no longer living in an age where large companies require only physical servers, with similar and rarely changing configurations, that could be manually maintained in a single Datacenter. This will allow teams to start worrying about other things that have not been solved yet by the extensive tools already available.

Code 167

Code Infrastructure DevOps Cloud 167

Scalegrid

APRIL 2, 2019

These results are pretty on-par with a 2017 survey by the Uptime Institute which found that 65% of enterprise workloads were still running in data centers owned and operated by those enterprises. using SQL Server, 17.3% So, how are PostgreSQL users choosing to host the clusters that power their applications? are using public clouds.

Database 185

Database Cloud Open Source Azure 185

All Things Distributed

NOVEMBER 13, 2018

The AWS Europe (Milan) Region will have three Availability Zones and be ready for customers in early 2020. Currently we have 57 Availability Zones across 19 technology infrastructure Regions. Since then, AWS has added another PoP in Palermo in 2017. ENEL is one of the leading energy operators in the world. million unique visits.

AWS 164

AWS Energy Automotive Traffic 164

All Things Distributed

OCTOBER 25, 2018

The new AWS Africa (Cape Town) Region will have three Availability Zones and provide lower latency to end users across Sub-Saharan Africa. We already have 55 Availability Zones across 19 infrastructure regions that customers can use today. In 2017, we brought the Amazon Global Network to Africa, through AWS Direct Connect.

AWS 167

AWS Cloud Education Programming 167

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server. Installation and support of SSRS can be confusing.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

FEBRUARY 12, 2020

Curiously, SQL Server's query processor already supports an internal comparison operator IS, which uses the same semantics as the desired IS operator I described here. Unfortunately, this clause is not yet available in T-SQL. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. Figure 1: Plan for Query 1.

C++ 120

C++ Code Servers Database 120

SQL Performance

JULY 9, 2019

This feature is currently not available in T-SQL. I posted a suggestion to improve SQL Server by adding support for nested window functions. At the date of this writing, there's not much information available out there about the true standard nested window functions. 2 2017-09-18 88.80 10248 85 2017-07-04 440.00

Servers 83

Servers Availability Database Code 83

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115

Tuning Servers Monitoring Hardware 115

All Things Distributed

OCTOBER 2, 2017

We were pushing the limits of what was a leading commercial database at the time and were unable to sustain the availability, scalability and performance needs that our growing Amazon business demanded. In support of Amazon Prime Day 2017, the biggest day in Amazon retail history, DynamoDB served over 12.9 million requests per second.

Internet 111

Internet Internet AWS Performance 111

SQL Performance

AUGUST 11, 2021

One is using a function called DATE_BUCKET , which at the time of writing is only available in Azure SQL Edge. Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. 2017 343 495118.14 DATE_BUCKET. OrderValues.

Azure 139

Azure Code Database Servers 139

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

DECEMBER 11, 2019

Finally, I cover missing standard features related to NULL handling in T-SQL and suggest alternatives that are available in T-SQL. WHERE NOT ( shippeddate = '20190102' ) ; This query returns the following output: orderid shippeddate -- -- 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12.

Best Practices 117

Best Practices C++ Database Code 117

The Morning Paper

NOVEMBER 8, 2020

USENIX is a nonprofit organisation committed to making content and research freely available – both conference proceedings and the recorded presentations of their events. Back in 2017 the engineering team at Facebook had a problem. In Facebook’s implementation of NativeLoglet, seal simply sets a bit on a quorum of servers.

Virtualization 126

Virtualization Latency Storage Systems 126

SQL Server According to Bob

FEBRUARY 11, 2019

SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to assist in transaction log processing activities. You may find the number of log write workers has been increased to 8 when running newer releases of SQL Server to accommodate larger systems. Total number NUMA nodes * 2.

Servers 40

Servers Availability Software Software 40

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. With a solution in hand for network performance, the next target was storage. ## 6. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. You can skip the WHERE clauses if you are running SQL Server 2017. s = SUM ( T.

Performance 81

Performance C++ Storage Servers 81

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

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. In 2010, having seemingly gone all-in with the tenets of open source development , the company brought MongoDB to the market as an open source database server. 2017: MongoDB goes public, trading as MDB. Now, back to MongoDB itself.

Open Source 98

Open Source Programming Database Servers 98

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

The Symphonia

DECEMBER 6, 2017

Traffic shaping / canary deployment was pre-announced at Serverless Conf NYC in October, and this is now available. there’s no inline debugging available in the Lambda Console.) without web app servers?—?to That means that 3GB functions might not see a linear speed bump for primarily single threaded functions. We’re the experts!

Serverless 40

Serverless Lambda AWS Traffic 40

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. To address these challenges, architects must design robust and scalable MongoDB databases and adopt appropriate sharding strategies that can efficiently handle increasing workloads while ensuring continuous availability. What is sharding in MongoDB?

Best Practices 98

Best Practices Traffic Database Servers 98

Scalegrid

AUGUST 27, 2024

Task Distribution in Web Servers In web applications experiencing high traffic levels, it is crucial to allocate tasks effectively to avoid overwhelming the servers. As a potent message broker, RabbitMQ is pivotal in spreading tasks among various web servers to maintain equilibrium and optimize efficiency. RabbitMQ in Action.

IoT 130

IoT Ecommerce Games Scalability 130

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, With faster disks (i.e. MySQL on ec2.

Cache 72

Cache C++ AWS Airlines 72

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. How-to documentation is readily available. It’s well-suited for organizations that require mission-critical applications with high availability. Bugs and security vulnerabilities are identified more quickly.

Open Source 98

Open Source Healthcare Social Media Database 98

SQL Server According to Bob

FEBRUARY 13, 2020

​​ When the utility attempted to issue the thaw command the command would be queued, and the database could not return to an operational state until SQL Server was restarted. ​​ While the name can be any string it is commonly a Guid accommodating the ​​ uniqueness requirements.

Servers 40

Servers Availability Transportation Database 40

MachMetrics

JUNE 30, 2021

Daniel An, Google, 2017. According to Google SOASTA research, 2017 the probability of page bounce rate increases with increasing page loading time, because it greatly improves the user experience. You can make beautiful-looking websites with the supports of millions of themes & plugins available. That’s a big problem.”

Cache 78

Cache Speed Google Website 78

SQL Server According to Bob

FEBRUARY 22, 2018

Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not function as expected. SQL Server’s NewSequentialId () calls the Windows API UuidCreateSequential , which is limited in SQLPAL, prior to the CU 4 update. Server B may be generating uuids that sort before those from Server A.

Servers 40

Servers Software Engineering Database Network 40

SQL Performance

MARCH 17, 2020

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. It would be nice if SQL Server could push the aggregation down into the scan and just return distinct values from the column store directly. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

FEBRUARY 3, 2020

The downside to the latter is that, in SQL Server 2017, you cannot run this online… but you will be able to in 2019. Also note that in SQL Server 2019 this technique may not work so well , but you can build clustered columnstore indexes online there, so it may not matter as much.

Speed 113

Speed Processing Servers Storage 113

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. Like any hash join, an adaptive join reads all rows available on its build input and copies the required data into a hash table.

Servers 98

Servers Design Database Code 98

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. Even with the broken Java stacks, I noticed a big difference: On Ubuntu, there's a massive amount of CPU time in a libjvm call: os::javaTimeMillis().

Speed 103

Speed Java AWS Virtualization 103

Percona

DECEMBER 21, 2023

The global default can be set at server startup. Currently, the optimizer hint for the flag ‘ prefer_ordering_index’ is not yet available till version 8.2.0. The value of this variable is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled.

Efficiency 126

Efficiency Database Open Source Performance 126

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. instructions are available. Introduction.

Servers 67

Servers Testing Metrics Storage 67