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

DZone

FEBRUARY 12, 2024

Poorly optimized queries can lead to slow response times and increased load on the database server, negatively impacting user experience and system performance. Optimizing complex MySQL queries is crucial when dealing with large datasets, such as fetching data from a database containing one million records or more.

Performance 161

Performance Database Strategy Efficiency 161

DZone

JANUARY 3, 2022

An access log is generated by the web server to log the details about the request that it has processed. While doing any performance analysis, these logs play an important role. Most people are aware of the application server log but many of them are not aware of the web server/load balancer access log.

Performance 246

Performance Servers Code Availability 246

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. Introduction One day a rooky database administrator has said to me: Understanding and solving SQL performance issues require an enormous amount of work.

Tuning 101

Tuning Servers Performance Database 101

Dynatrace

NOVEMBER 30, 2023

Over the years, I have watched and written about online retail and e-commerce IT performance. Below is a Dynatrace honeycomb chart depicting the performance of the synthetics tests tracked by the Dynatrace Business Insights team. This had the effect of dramatically speeding up its performance and reducing support costs.

Retail 229

Retail Social Media Performance Benchmarking 229

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

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.

Servers 104

Servers Performance 104

SQL Shack

APRIL 14, 2020

SQL Server Performance Tuning can be a difficult assignment, especially when working with a massive database where even the minor change can raise a significant impact on the existing query performance. Performance Tuning always plays a vital role in database performance as well as product performance.

Tuning 88

Tuning Hardware Servers Performance 88

SQL Shack

NOVEMBER 1, 2021

In this article, we will explore how we can use SQL Server extended events to monitor query performance in SQL Server. Introduction Monitoring the query performance is one of the important diagnosis methods to uncover poorly performing queries. However, sometimes this can be a bit of struggling activity.

Monitoring 87

Monitoring Servers Performance 87

DZone

MAY 31, 2022

However, to tactically assess the website's performance , it needs to be measured in a well-thought-out manner. Core Web Vitals is a key performance metric that analyzes the website's performance by investigating the data and provides a strategic platform to scale up the website's user experience.

Performance Testing 244

Performance Testing Testing Performance Website Performance 244

SQL Shack

APRIL 19, 2021

In this article, we’ll show a process for SQL Server performance tuning, and several tools, tips and techniques you can use to monitor performance and take the necessary steps to improve it. SQL Server is a common platform for enterprise-grade database workloads.

Tuning 70

Tuning Servers Performance Database 70

Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 273

Servers Monitoring Availability Programming 273

Percona

OCTOBER 10, 2023

Why choose Percona Server for MongoDB? The difference between Percona Server for MongoDB and MongoDB CE is that we strive to provide a gap-closing set of features for users who want to use MongoDB in production. Why release Percona Server for MongoDB 7 now? which was released as Percona Server for MongoDB RC 7.0.2-1.

Availability 99

Availability Servers Database Open Source 99

Dynatrace

OCTOBER 23, 2023

Secondly, determining the correct allocation of resources (CPU, memory, storage) to each virtual machine to ensure optimal performance without over-provisioning can be difficult. This presents a challenge for IT operations teams, specifically in identifying and addressing performance issues or planning how to prevent future issues.

Efficiency 222

Efficiency Virtualization Hardware Performance 222

InfoQ

JANUARY 26, 2024

Discord optimized its platform to serve over one million online users in a single server while maintaining a responsive user experience. By Rafal Gancarz

Servers 114

Servers Tuning Scalability Performance 114

SQL Shack

OCTOBER 7, 2020

In this article, we will learn how to use Apache JMeter to perform a load test on SQL Server. This test type enables us to measure the application behaviors under specific conditions so that it enables us to observe a variety of resource consumptions (CPU, memory, latency, response times, etc) and it also helps to […].

Servers 115

Servers Testing Performance Latency 115

DZone

OCTOBER 26, 2021

Database Availability Group (DAG) is a built-in framework in Microsoft Exchange Server that uses continuous replication and failover clustering to ensure high availability and site resilience. In DAG, there is one active server and a copy of the database on the active server is replicated across all passive servers.

Servers 188

Servers Database Availability Performance 188

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. For example, suppose that prior to SQL Server 2022 you had the following query: SELECT. So far so good. FROM T1 INNER JOIN T2 ON T1.

Servers 142

Servers Testing C++ Code 142

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 123

Performance Hardware Tuning Storage 123

DZone

SEPTEMBER 20, 2019

How does this Peak Perform? php” file that sits quietly until it is invoked by a top-level web server like Nginx+PHP-FPM or Apache mod_php. php” file that sits quietly until it is invoked by a top-level web server like Nginx+PHP-FPM or Apache mod_php.

Servers 100

Servers Performance Java Programming 100

SQL Shack

APRIL 15, 2024

The purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL Server. Introduction The performance tuning aims to optimize and reduce the response time of the queries so that we can provide fast and reliable access to data for the […]

Tuning 52

Tuning Performance Servers Monitoring 52

SQL Shack

JUNE 16, 2020

When dealing with SQL Server performance tuning waits, we may see RESOURCE_SEMAPHORE waits along with other related monitoring that indicates memory as a possible pain point for our server (such as the below image that shows memory being one of the top waits overall).

Tuning 75

Tuning Servers Performance Monitoring 75

SQL Shack

SEPTEMBER 29, 2020

In this article, we will learn the Delayed Durability feature that helps to improve transaction log file write throughput in SQL Server. Therefore, the transaction completion time becomes more important for the performance of the OLTP databases. […].

Servers 98

Servers Performance Database Processing 98

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. When undertaking any sort of performance optimisation work, one of the very first things we learn is that before you can improve performance you must first measure it. Browsers now even have performance audits built right in.

Servers 87

Servers Performance Metrics Database 87

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 83

Servers Database Open Source Scalability 83

Dynatrace

OCTOBER 17, 2023

In the recently published Gartner® “ Critic al Capabilities for Application Performance Monitoring and Observability,” Dynatrace scored highest for the IT Operations Use Case (4.15/5) This is accomplished by using service monitoring and anomaly detection for early-warning notifications of performance issues.” 5) in the Gartner report.

Monitoring 234

Monitoring Artificial Intelligence Performance Analytics 234

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. This can negatively impact performance and cause delays.

Servers 112

Servers Best Practices Database Open Source 112

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. Instead, starting with SQL Server 2022 you simply use the SET_BIT function.

Servers 122

Servers C++ Code Cache 122

Tim Kadlec

APRIL 10, 2023

There was a comment on Twitter today from Rafael Gonzaga expressing disappointment in what he sees as a tendency to focus on the frontend solely in performance discussions, while neglecting the server-side aspect. When the rule was first brought up, frontend performance wasn’t really a thing that people did.

Performance 111

Performance Servers Mobile Metrics 111

Percona

MARCH 1, 2023

EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. Adding ANALYSE causes the query to execute, and the numbers returned to report the real numbers of the query’s performance. Why Percona Server for MySQL? And Percona Server for MySQL is free.

Servers 117

Servers Open Source Tuning C++ 117

DZone

APRIL 9, 2020

What Causes Performance Issues. Insufficient server sizing or incorrect architecture. Solution — Site Optimization Framework shows how to boost your website performance. I often found that there are issues observed post-implementation due to not following the best practices recommended by Adobe. High CPU utilization.

Website Performance 258

Website Performance Website Performance Cache 258

HammerDB

FEBRUARY 27, 2024

adds performance enhancements for the SQL Server TPROC-H workload in the form of partitioning for the orders and lineitem tables as well as the option to create advanced statistics. HammerDB v4.10 Enabling Partitioning and Advanced Statistics These can be selected with a checkbox in the GUI. Summary HammerDB v4.10

Servers 62

Servers Performance 62

SQL Shack

JUNE 25, 2021

In this article, we will focus on one major SQL Server performance issue that we may experience during heavy data insertion in a table. Introduction SQL Server allocates some memory from the operating system, and this is because it is designed to do all read and modification operations in memory instead of on disk.

Tuning 64

Tuning Servers Performance Operating System 64

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 104

Performance Monitoring Traffic Database 104

Scalegrid

AUGUST 26, 2020

While Microsoft offers their own Azure Database product, there are other alternatives available that may be able to help you improve your MySQL performance. In this blog post, we compare Azure Database for MySQL vs. ScaleGrid MySQL on Azure so you can see which provider offers the best throughput and latency performance. Throughput.

Azure 299

Azure Benchmarking Database Latency 299

SQL Shack

OCTOBER 14, 2021

Even non-encrypted databases hosted on the same SQL Server instance would have some performance degradation because of […]. It also encrypts the tempdb database to secure your data in a temporary space. The process of encryption and decryption adds additional overhead to the database system.

Servers 79

Servers Performance Database Systems 79

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. Conclusion and Other T-SQL Improvements in SQL Server 2022. This release has a number of T-SQL improvements. STRING_SPLIT.

Servers 145

Servers C++ Code Database 145