SQL Performance

JANUARY 11, 2021

There are features many of us shy away from, like cursors, triggers, and dynamic SQL. There is no question they each have their use cases, but when we see a trigger with a cursor inside dynamic SQL, it can make us cringe (triple whammy). But, as with cursors, triggers, and dynamic SQL, they have their use cases.

Cache 59

Cache Tuning Database Performance 59

IO River

NOVEMBER 15, 2023

Let's break it down using a simple analogy:Imagine you own a special kind of mailbox. They check who's coming and going based on broad criteria, like the type of vehicle or the road they're using. What is WAF?‍WAF ‍WAF stands for Web Application Firewall. ‍This is where WAF comes in! ‍This is where WAF comes in!

Traffic 52

Traffic Network Logistics Architecture 52

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. Want to ensure a successful MySQL 5.7

Strategy 40

Strategy Storage Database Best Practices 40

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). Extended Events provides data about the individual execution of queries, while Query Store and the DMVs aggregate performance data.

C++ 74

C++ Database Servers Tuning 74

SQL Performance

MARCH 5, 2020

A few weeks ago, an interesting question was asked on the #SQLHelp hash tag on Twitter about the impact of execution plans on the ASYNC_NETWORK_IO wait type, and it generated some differing opinions and a lot of good discussion. To summarize: Focusing on ASYNC_NETWORK_IO waits alone as a tuning metric is a mistake. FILLER , t2.

Education 55

Education Servers Testing Tuning 55

IO River

NOVEMBER 2, 2023

Let's break it down using a simple analogy:Imagine you own a special kind of mailbox. They check who's coming and going based on broad criteria, like the type of vehicle or the road they're using. WAF stands for Web Application Firewall. Instead of just receiving letters, it also receives parcels, packages, and even gifts.

Traffic 40

Traffic Network Logistics Architecture 40

SQL Performance

DECEMBER 9, 2020

In Part 5 of my series on table expressions I provided the following solution for generating a series of numbers using CTEs, a table value constructor and cross joins: DECLARE @low AS BIGINT = 1001 , @high AS BIGINT = 1010 ; WITH. I’ll present the performance tests that I’ve done with my solution. There could be many others.

C++ 61

C++ Servers Testing Processing 61

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS.

Servers 49

Servers Azure Hardware Database 49

Percona

JANUARY 28, 2019

EverSQL (use code PERCONA-EVERSQL-10OFF for a 10% discount on the first billing cycle) is a platform that intelligently tunes your SQL queries by providing query optimization recommendations, and feedback on missing indexes. We’ll use the Stackoverflow data set again as we did in our first post.

Monitoring 42

Monitoring C++ Tuning Analytics 42

O'Reilly Software

APRIL 4, 2018

Google founders figured out smart ways to rank websites by analyzing their connection patterns and using that information to improve the relevance of search results. Google founders figured out smart ways to rank websites by analyzing their connection patterns and using that information to improve the relevance of search results.

Architecture 80

Architecture Scalability Google Operating System 80

Percona

AUGUST 27, 2018

Let us start with a disclaimer. This feature can help a lot if used correctly, and hopefully they will not deprecate or remove it after five minutes. Resource groups permit assigning threads running within MySQL to particular groups so that threads execute according to the resources available to this group. Not useful.

Tuning 44

Tuning Virtualization Testing Servers 44

Percona

AUGUST 10, 2018

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a high performance PostgreSQL database needed by demanding applications. What is autovacuum ?

Tuning 44

Tuning Cache Database Storage 44

SQL Performance

SEPTEMBER 2, 2021

SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT().

C++ 59

C++ Servers Testing Database 59

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

The Netflix TechBlog

JULY 26, 2021

Such a paradigm aspires to assist front-line operations personnel and stakeholders in “running the business”²; performing their tasks through means such as ad hoc analysis, decision-support, and tracking (of tasks, assets, schedules, etc). tactical) in nature.

Big Data 253

Big Data Government Analytics Processing 253

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

The Netflix TechBlog

APRIL 29, 2019

By Pythonistas at Netflix, coordinated by Amjith Ramanujam and edited by Ellen Livengood As many of us prepare to go to PyCon, we wanted to share a sampling of how Python is used at Netflix. We use and contribute to many open-source Python packages, some of which are mentioned below. what plan do you have?

Open Source 279

Open Source Network Infrastructure Big Data 279

The Netflix TechBlog

OCTOBER 18, 2022

by Jun He , Akash Dwivedi , Natallia Dzenisenka , Snehal Chennuru , Praneeth Yenugutala , Pawan Dixit At Netflix, Data and Machine Learning (ML) pipelines are widely used and have become central for the business, representing diverse use cases that go beyond recommendations, predictions and data transformations.

Java 202

Java Scalability Traffic Architecture 202