DZone

JANUARY 8, 2024

This article provides an overview of Azure's load balancing options, encompassing Azure Load Balancer, Azure Application Gateway, Azure Front Door Service, and Azure Traffic Manager. Each of these services addresses specific use cases, offering diverse functionalities to meet the demands of modern applications.

Azure 275

Azure Scalability Traffic Performance 275

DZone

NOVEMBER 29, 2023

As I mentioned in my previous article Part 1 , let's explore how such a transition can be effectively managed. The Monolithic Challenge Imagine a scenario where you have a large-scale, monolithic system - possibly a bulky C# console application or an extensive SQL Server stored procedure.

Systems 286

Systems C++ Scalability Architecture 286

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. In this article I focus on windowing and NULL-related improvements. I’ll be using the sample database TSQLV6 in the examples in this article. Conclusion and Other T-SQL Improvements in SQL Server 2022. This release has a number of T-SQL improvements.

Servers 145

Servers C++ Code Database 145

SQL Shack

AUGUST 27, 2021

In this article, we will take a glance at the fundamentals of SQL Server statistics and discover their interaction with the query processing steps with simple examples. Getting Started with SQL Server statistics SQL Server statistics are one of the key inputs for the query optimizer during generating a query plan.

Servers 109

Servers Processing Performance 109

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 112

Servers Best Practices Database Open Source 112

SQL Shack

AUGUST 23, 2021

In this article, we will go through some details about SQL Server statistics. The first step into SQL Server statistics The query plan is a set of instructions that describes how a query will be executed by the database engine. The query plans are created by the query optimizer in SQL Server and it requires […].

Servers 109

Servers Database Engineering Performance 109

SQL Performance

SEPTEMBER 21, 2022

Even SQL Server stores some flag-based data using bitwise representation. Setting the server configuration option “ user options” using bitwise representation. Prior to SQL Server 2022, T-SQL had minimal support for bit manipulation. Querying the current session’s state of session options with the @@OPTIONS function.

Servers 122

Servers C++ Code Cache 122

SQL Shack

OCTOBER 12, 2020

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Introduction We might have sensitive data in our SQL database such as customers’ credit card details, bank account details, social security numbers, and medical history.

Servers 105

Servers Availability Database 105

SQL Shack

AUGUST 17, 2021

This article intends to give information about the SQL Server filtered indexes and their performance impacts. Introduction Indexes are the special data structures that help to improve the performance of the queries in SQL Server.

Servers 110

Servers Performance 110

DZone

JANUARY 3, 2024

The Raspberry Pi is one example of a small, low-cost device that is embracing this idea, even though it has traditionally been associated with powerful servers and expensive computers.

Virtualization 313

Virtualization Education Media Hardware 313

SQL Shack

OCTOBER 14, 2021

This article explores the Causality tracking option in the SQL Server Extended Events session(XEvents) and its usefulness in troubleshooting performance issues. Introduction to SQL Server Extended Events(XEvent) The SQL Server Extended event (XEvent) is a lightweight tool to collect data for troubleshooting.

Servers 99

Servers Performance Monitoring 99

SQL Shack

DECEMBER 12, 2023

This article explains some of the popular SQL Server monitoring tools and techniques. Database monitoring: a quick reminder Database monitoring is a set of tools and techniques used to create and maintain an application infrastructure that is highly available and performs at high speed.

Monitoring 52

Monitoring Servers Speed Database 52

SQL Shack

NOVEMBER 23, 2021

This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019. Introduction SQL Server uses Dynamic Random Access Memory (D-RAM) buffer pool for caching data pages retrieved from the disk. The buffer cache stores the page and writes back to disk only if it is modified.

Servers 93

Servers Cache Availability Performance 93

SQL Shack

NOVEMBER 17, 2021

This article aims to provide some beneficial tips about SQL Server extended events that make it easier to create and use event sessions. Introduction SQL Server extended events is a performance monitoring tool that has the ability to collect various event data of the SQL Server.

Servers 89

Servers Monitoring Performance 89

DZone

SEPTEMBER 25, 2023

It is the second of a series of articles that is built on top of that project, representing experiments with various statistical and machine learning models, data pipelines implemented using existing DAG tools, and storage services, both cloud-based and alternative on-premises solutions.

Storage 258

Storage AWS Architecture Cloud 258

SQL Shack

FEBRUARY 17, 2021

In this article, we are going to talk about the modes of transactions in SQL Server. SQL Server can operate 3 different transactions modes and these are: […].

Servers 111

Servers Database Monitoring 111

SQL Shack

DECEMBER 2, 2021

In this article, we will learn some query hints and trace flags that impact the query performance and also influence the SQL Server query optimizer’s default execution plan generation algorithm.

Servers 90

Servers Performance 90

SQL Shack

DECEMBER 29, 2021

In this article, we will learn how we can detect which operations cause to fill up SQL Server tempdb through the dynamic management views. What is SQL Server tempdb used for? Tempdb is one of the system databases, that is used by many activities in SQL Server to temporarily store data. Such as when a […].

Servers 100

Servers Monitoring Database Systems 100

SQL Shack

AUGUST 27, 2020

In this article, we will learn some basic tips for SQL Server performance tuning. Tuning the SQL Server performance will help to access data faster so the applications data interaction performances will enhance. SQL Server […].

Tuning 114

Tuning Servers Performance Database 114

Percona

DECEMBER 8, 2023

In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. The only value currently accepted is GroupReplication.

Servers 86

Servers Virtualization Open Source Scalability 86

SQL Shack

SEPTEMBER 29, 2020

In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups. Previously, to access data from […].

Servers 99

Servers Availability Virtualization Database 99

SQL Shack

OCTOBER 12, 2021

In this article, we will learn how to monitor SQL Server blocking issues with different methods. How does a blocking occur in SQL Server? SQL Server uses the lock mechanism to protect […]. In relational databases, numerous user transactions are processed concurrently.

Servers 79

Servers Monitoring Database Processing 79

SQL Shack

JULY 15, 2020

In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations. You should go through the following articles and build the infrastructure before proceeding with this article.

Servers 69

Servers Availability Virtualization Infrastructure 69

SQL Shack

SEPTEMBER 6, 2021

In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled. Introduction SQL Server Stored procedures are the make-ready T-SQL codes that can be executed again and again by the database users to perform data manipulation commands and data definition commands.

Servers 90

Servers Database Code Performance 90

SQL Shack

FEBRUARY 10, 2021

In this article, we will talk about fundamental details of the transactions in SQL Server. Introduction A transaction is the logical work unit that performs a single activity or multiple activities in a database. Transactions may consist of a single read, write, delete, or update operations or a combination of these.

Servers 110

Servers Database Performance Monitoring 110

SQL Shack

MAY 12, 2021

This article intends is to give helpful SQL Server performance tuning advice to those who want to learn performance tuning. Me: There is no doubt, SQL Server performance tuning issues are very […].

Tuning 101

Tuning Servers Performance Database 101

SQL Shack

SEPTEMBER 28, 2020

In this article, we will explore a new SQL Server 2019 feature which is Scalar UDF (scalar user-defined) inlining. Scalar UDF inlining is a member of the intelligent query processing family and helps to improve the performance of the scalar-valued user-defined functions without any code changing.

Servers 107

Servers Programming Code Software 107

Dynatrace

FEBRUARY 11, 2020

OneAgent knows where to connect for further runtime configuration and where to send data because the installer itself is pre-configured to connect to the exact tenant and server that it’s downloaded from. But what if your environment grows and you decide to distribute data between two Dynatrace servers?

Servers 156

Servers Tuning Systems Availability 156

SQL Shack

OCTOBER 26, 2020

In this article, we will explore, how we can increase SQL Server performance with the help of the wait statistics. Wait statistics are one of the most important indicators to identify performance issues in SQL Server.

Servers 109

Servers Performance Monitoring 109

Speed Curve

FEBRUARY 5, 2024

Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience. I mean, why wouldn't we?

Servers 58

Servers Cache Retail Benchmarking 58

Smashing Magazine

MAY 16, 2022

Rethinking Server-Timing As A Critical Monitoring Tool. Rethinking Server-Timing As A Critical Monitoring Tool. In the world of HTTP Headers, there is one header that I believe deserves more air-time and that is the Server-Timing header. Setting Server-Timing. Sean Roberts. 2022-05-16T10:00:00+00:00.

Servers 92

Servers Monitoring Cache Network 92

CSS - Tricks

MARCH 6, 2019

There is Server-Side Rendering (SSR, like this WordPress site is doing) and Client-Side Rendering (CSR, like a typical React app). My favorite part of the article is the infographic table they post at the end of it. The Client/Server Rendering Spectrum by Chris Coyier ( @chriscoyier ). Unfortunately, it's a PNG. See the Pen.

Servers 109

Servers Performance 109

SQL Shack

JANUARY 5, 2021

In this article, we will explore how the ORDER BY statement affects the query performance and we will also learn some performance tips related to sorting operations in SQL Server. The duration and resource (CPU and memory) consumption of the sort operation will change depending on the number of rows to be sorted. In this […].

Servers 104

Servers Performance 104

SQL Shack

JULY 15, 2020

In this article, we will talk about the deadlocks in SQL Server, and then we will analyze a real deadlock scenario and discover the troubleshooting steps. In general, we can find out various theoretical advice and examples about the deadlock problems on the web but, in this article, we will tackle a true deadlock story […].

Servers 110

Servers Performance 110

SQL Shack

AUGUST 27, 2021

This article explores Persist sampling rate feature for automatic SQL Server statistics update. Introduction DBA should always focus on the optimal database performance as it is directly related to the application’s performance. Indexes help DBA to optimize queries based on the user data requirements. […].

Servers 109

Servers Database Monitoring Performance 109

DZone

APRIL 30, 2020

Following on my previous article. Run your own Video Conference Service with Jitsi , I started looking for a reliable solution to monitor my instance that runs Jitsi. I needed basic information on RAM, CPU, Disk, Networking, and I/O to assess the performance bottleneck for the serve.

Monitoring 159

Monitoring Servers Hardware Open Source 159

SQL Shack

OCTOBER 14, 2020

In this 32nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances. A brief overview of SQL Server Patches It is a recommended practice to apply the regular update to the SQL Server with the service pack (SP) […].

Servers 86

Servers Availability Processing 86