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

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.

Servers 40

Servers Network Database Systems 40

The Netflix TechBlog

DECEMBER 14, 2020

The mystery begins Towards the end of 2017, I was on a conference call to discuss an issue with the Netflix application on a new set top box. They supplied a script to automate the process. The role of a Partner Engineer at Netflix is to help device manufacturers launch the Netflix application on their devices. aka “Lollipop”.

Engineering 357

Engineering Code Open Source Hardware 357

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

Dynatrace

JUNE 15, 2023

Cloud application security is a combination of policies, processes, and controls that aim to reduce the risk of exposing cloud-based applications to compromise or failure from external or internal threats. This process can delay deployments or cause developers to skip security testing completely to meet project deadlines.

Cloud 169

Cloud Open Source Architecture Monitoring 169

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

Tim Kadlec

JUNE 21, 2022

HTTP/3 work started in 2012 with Google working on QUIC, adopted by IETF in 2017, RFC’s published in June 2022. No server push! The RSVP problem: HTTP/3 might be blocked on the network or may not be enabled on the server. So the browser will only try HTTP/3 if it’s certain the server supports it. What and Why?

Network 65

Network Mobile Google Cache 65

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 Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Adaptive query processing in SQL databases – Bob Ward and Conor Cunningham.

Engineering 40

Engineering Azure Best Practices Servers 40

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. Data analytics: With the right extensions and configurations, PostgreSQL can support analytical processing and reporting. PostgreSQL hasn’t just been a concern to its competitors; it’s swooped past most of them.

Open Source 80

Open Source Healthcare Social Media Database 80

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 83

Open Source Programming Database Servers 83

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. The Sort only has 19 rows to process, so it consumes only 1ms or so. Test Environment. There is a clustered primary key index on the Id column of the dbo.Votes table.

Servers 86

Servers Tuning Database Efficiency 86

Dotcom-Montior

JUNE 25, 2020

These certificates are then activated on the company’s website which ensures that a secure connection is always set up between the web browser and the web server. SSL certificates maintain the security of data between servers. This solution provides regular certificate expiry reminders by following the certificate monitoring process.

Monitoring 77

Monitoring Website Internet Internet 77

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

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. “.

Servers 90

Servers Media Cache Storage 90

The Morning Paper

JUNE 6, 2019

The Federated Averaging algorithm addresses one of the key challenges in making this practical: reducing the communication volume (by 10-100x) between the model server and the devices. Secure aggregation was introduced in a 2017 paper by Bonawitz et al., ‘ Practical secure aggregation for privacy-preserving machine learning.’

Systems 71

Systems Design Google Servers 71

Brendan Gregg

NOVEMBER 29, 2017

AWS EC2 uses a different image type and boot process for PV and HVM, as described on the [Linux AMI Virtualization Types] page. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. Things started to become confusing here for two reasons. 0% performance overhead.

Virtualization 111

Virtualization AWS Hardware Storage 111

MachMetrics

FEBRUARY 7, 2019

“1 out of 5 online shoppers will abandon their cart because the transaction process was too slow.” It is easy to check pages and make minor tweaks to coding, server config, or optimization features to see a significant improvement in loading time. Summing up. Page load speed is not a mythical beast that cannot be slain.

Speed 93

Speed Website Performance Website Mobile 93

Scalegrid

AUGUST 27, 2024

Key features of RabbitMQ, such as message acknowledgments, complex routing, and asynchronous processing, contribute to system reliability and performance. Use cases for RabbitMQ encompass areas like order processing in eCommerce, real-time notifications, and multiplayer gaming, showcasing its adaptability to different operational needs.

IoT 130

IoT Ecommerce Games Efficiency 130

Rigor

SEPTEMBER 11, 2019

Reading time 16 min Whether you’re a web performance expert, an evangelist for the culture of performance, a web engineer incorporating performance into your process, or someone new to the web performance entirely, you probably identify as curious, excited about new ideas, and always learning. The future of HTTP/2 server push.

Performance 89

Performance Education Google Website 89

Particular Software

AUGUST 8, 2017

Better for you The headline feature of SQL Persistence is its support for multiple engines, which currently includes Microsoft SQL Server, Oracle, and MySQL. Update Dec 5, 2017: SQL Persistence now also supports PostgreSQL too.) There, you can view all the DDL and DML scripts for Microsoft SQL Server , Oracle , and MySQL.

DevOps 40

DevOps Database Education Engineering 40

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

C++ Servers Code Efficiency 140

Brendan Gregg

NOVEMBER 28, 2017

AWS EC2 uses a different image type and boot process for PV and HVM, as described on the [Linux AMI Virtualization Types] page. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. Things started to become confusing here for two reasons. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40

Brendan Gregg

SEPTEMBER 5, 2017

There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). On Linux, containers are a combination of namespaces (restricting what a process sees) and cgroups (similar to Solaris resource controls). amazon").

Virtualization 76

Virtualization AWS Engineering Hardware 76

SQL Performance

MAY 13, 2020

Logical query processing handles query clauses in the following order: FROM>WHERE>GROUP BY>HAVING>SELECT>ORDER BY. By the way, this function was added in SQL Server 2017, so if you're running the code in an earlier version, feel free to replace this computation with an alternative computation of your choosing.)

C++ 143

C++ Code Design Servers 143

ACM Sigarch

FEBRUARY 23, 2018

Richard Thaler won the 2017 Nobel prize in Economics for his work on Behavioral Economics. How do we put processes in place so that we can move past our inherent psychological myopia? She is currently a Principal Hardware Architect at Cavium, working on ARM server processors.

Architecture 47

Architecture Cache Hardware Virtualization 47

The Symphonia

DECEMBER 6, 2017

We don’t recommend using this as a regular process for production use, but it might come in handy at development time. without web app servers?—?to Lambda is not a good solution for handling long-running stateful processes, and Step Functions is effectively in the same place it was a year ago. And again, this is a problem.

Serverless 40

Serverless Lambda AWS Traffic 40

SQL Performance

JULY 9, 2019

I posted a suggestion to improve SQL Server by adding support for nested window functions. 2 2017-09-18 88.80 Hopefully, this article will increase awareness of the true nested window functions feature, and cause people to turn to Microsoft and ask to add support for it in SQL Server. 10248 85 2017-07-04 440.00

Servers 83

Servers Availability Database Code 83

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. Network Connectivity: Establish a reliable network connection between the primary and replica servers.

Servers 52

Servers Database Availability Virtualization 52

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.

Servers 40

Servers Availability Software Software 40

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. Description.

IoT 61

IoT Servers Development Cache 61

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

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

SQL Performance

JULY 8, 2020

Unnesting/substitution of table expressions is a process of taking a query that involves nesting of table expressions, and as if substituting it with a query where the nested logic is eliminated. What actually happens is that the query parsing process produces an initial tree of logical operators closely reflecting the original query.

Servers 110

Servers Code Processing Performance 110

SQL Server According to Bob

FEBRUARY 13, 2020

​​​​ Another example would be backup to Azure Storage using the rest interface to read and ​​ write data to/from Azure Blob Storage. ​​​​ The flaw in the two-command approach was that you could issue the freeze and all the SQL Server workers got blocked waiting for a thaw.

Servers 40

Servers Availability Transportation Database 40

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 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. Why the difference?

Performance 81

Performance C++ Storage Servers 81