SQL Shack

APRIL 21, 2020

This article will cover some essential techniques for SQL query tuning. Query tuning is a very wide topic to talk about, but some essential techniques never change in order to tune queries in SQL Server. Particularly, it is a difficult issue for those who are a newbie to SQL query tuning or who are thinking […].

Tuning 92

Tuning Servers Performance 92

DZone

SEPTEMBER 25, 2019

The application was running on a GNU/Linux OS, Java 8, Tomcat 8 application server. Proxy Error The proxy server received an invalid response from an upstream server. Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request GET /.

Tuning 173

Tuning Java Traffic AWS 173

The Netflix TechBlog

MAY 4, 2023

Migrating Critical Traffic At Scale with No Downtime — Part 1 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Hundreds of millions of customers tune into Netflix every day, expecting an uninterrupted and immersive streaming experience. This technique facilitates validation on multiple fronts.

Traffic 347

Traffic Latency Tuning Systems 347

DZone

OCTOBER 1, 2023

As a distributed database, your data is partitioned into “shards” which are then allocated to one or more servers. Because of this sharding, a read or write request to an Elasticsearch cluster requires coordinating between multiple nodes as there is no “global view” of your data on a single server.

Open Source 257

Open Source Tuning Analytics Scalability 257

SQL Shack

NOVEMBER 23, 2020

In this article, we will talk about the query tuning features that were announced with SQL Server 2019. Introduction Sometimes, tuning the queries can be a tough task for database developers or administrators.

Tuning 76

Tuning Servers Database Development 76

SQL Shack

MAY 8, 2020

In this article, we will continue to learn essential techniques of the SQL Server query tuning with practical examples. Query tuning is a bit complicated issue and if any database programmer wants to be successful on this topic, they can start with learning these basic methods to improve their skill.

Tuning 86

Tuning Servers Database Performance 86

Dynatrace

JULY 2, 2019

For instance, alert me when an error 999 is detected in application server logs or any HTTP 500 error from the web server access log. If the code triggers an unexpected “connectionTimeOutException”, there is no “catch” so the application server will catch it and return an HTTP error. How to fine-tune failure detection.

Tuning 116

Tuning Artificial Intelligence Code Java 116

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

Scalegrid

MARCH 23, 2020

While its use and importance has decreased as the inbuilt replication options improved on PostgreSQL server side, this still remains a valuable option for older versions of PostgreSQL. Follow these steps to set up Pgpool-II, enable the connection pool services you need, and connect to your PostgreSQL server. At a glance. How it works.

Cache 264

Cache Servers Architecture Processing 264

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. This article will cover many areas that database administrators need to be aware of in order to properly license, recover, and tune a Reporting Services installation.

Tuning 67

Tuning Servers Database Best Practices 67

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 157

Servers Tuning Systems Availability 157

SQL Shack

DECEMBER 8, 2020

Gaining experience in SQL query tuning can be very difficult and complicated for database developers or administrators. For this reason, in this article, we will work on a case study and we are going to learn how we can tune its performance step by step. In this fashion, we will understand well how to approach […].

Tuning 91

Tuning Servers Database Performance 91

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

Dynatrace

APRIL 23, 2024

When operational disruptions strike—whether it’s a rogue server or a cyberattack—Dynatrace services remain in harmony. Imagine a dashboard that whispers, “Hey, there’s a vulnerability brewing in Server Room B.” The Dynatrace data-centric approach ensures compliance isn’t a burden; it’s an opportunity to fine-tune operations.

Tuning 256

Tuning Strategy Servers Technology 256

The Netflix TechBlog

SEPTEMBER 18, 2024

message IdempotencyToken ( Timestamp generation_time, String token ) At Netflix, client-generated monotonic tokens are preferred due to their reliability, especially in environments where network delays could impact server-side token generation. Either or both may be required by backing storage engines to de-duplicate mutations.

Latency 261

Latency Storage Cache Efficiency 261

The Netflix TechBlog

JUNE 14, 2023

Before GraphQL: Monolithic Falcor API implemented and maintained by the API Team Before moving to GraphQL, our API layer consisted of a monolithic server built with Falcor. A single API team maintained both the Java implementation of the Falcor framework and the API Server. To launch Phase 1 safely, we used AB Testing.

Traffic 358

Traffic Latency Cache Metrics 358

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 106

Servers Tuning Scalability Performance 106

Dynatrace

JUNE 16, 2022

A centralized approach to WAF uses a single firewall to protect many application servers against large-scale distributed attacks. Conversely, a decentralized approach protects application servers using multiple firewalls to protect against attacks that may have penetrated the network. More time for vulnerability management.

Tuning 233

Tuning Cloud Open Source Network 233

Percona

MARCH 1, 2023

EXPLAIN ANALYSE is a big boon to query tuning. EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. But before going with the MySQL Community Edition, you should look at Percona Server for MySQL. Why Percona Server for MySQL? And Percona Server for MySQL is free.

Servers 124

Servers Open Source Tuning C++ 124

Scalegrid

JULY 13, 2020

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. The $47,500 licensing costs for Oracle Enterprise Edition is only for one CPU core, that ultimately has to be multiplied with the actual number of cores on the physical server. Compare Ease of Use.

Open Source 244

Open Source Tuning C++ Database 244

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.

Servers 107

Servers Availability Database Open Source 107

Dynatrace

AUGUST 29, 2023

Dynatrace has announced that it has successfully achieved the Google Cloud Ready – Cloud SQL designation for Cloud SQL, Google Cloud’s fully-managed, relational database service for MySQL, PostgreSQL, and SQL Server.

Google 216

Google Cloud Design Programming 216

Dynatrace

OCTOBER 7, 2020

Stay tuned for an upcoming blog series where we’ll give you a more hands-on walkthrough of how to ingest any kind of data from StatsD, Telegraf, Prometheus, scripting languages, or our integrated REST API. Stay tuned. Dynatrace unlocks over 200 new technology integrations.

Open Source 261

Open Source Metrics Analytics Tuning 261

Dynatrace

FEBRUARY 14, 2022

Multiple Prometheus servers might be required, creating significant maintenance efforts. Alternatively, if you’re already using a Prometheus Server to gather data from your distributed systems, you can now seamlessly make this data work for you in Dynatrace as well—use your Prometheus server as the endpoint for scraping metrics.

Technology 229

Technology Technology Metrics Infrastructure 229

Scalegrid

OCTOBER 17, 2019

Using a connection pool in each module is hardly efficient: Even with a relatively small number of modules, and a small pool size in each, you end up with a lot of server processes. You either need an extra server (or 3), or your database server(s) must have enough resources to support a connection pooler, in addition to PostgreSQL.

Architecture 200

Architecture Database Latency Servers 200

Dynatrace

FEBRUARY 22, 2021

More than 50% of the Synthetic-enabled ActiveGates used by our customers are deployed on Linux servers. Stay tuned for more upcoming improvements related to private synthetic monitoring. Here’s a sneak peek of what we’re working on: Support for Amazon Linux 2 and SUSE Enterprise Linux Server 15. What’s next.

Monitoring 204

Monitoring Tuning Network Operating System 204

The Netflix TechBlog

AUGUST 22, 2019

Running a canary for each change and testing the AMI in production allows us to capture insights around impact on Windows updates, script changes, tuning web server configuration, among others. We can easily test server tuning changes, software upgrades, and other modifications to the runtime environment.

DevOps 211

DevOps AWS Tuning Infrastructure 211

Dynatrace

MAY 4, 2021

So, you start your investigation on the frontend server service which shows an increased failure rate with every second request failing for a couple of hours. When selecting the cart-checkout service in PurePath view, you see that the service fails with an internal server error. Stay tuned for the general availability of trace ingest.

Cloud 264

Cloud Java Tuning Monitoring 264

Dynatrace

SEPTEMBER 17, 2020

This meant sacrificing all the benefits of your enterprise LDAP server (for example, a single authentication point or central point for password management that provides additional services, such as password policies and expiration). With this approach, you can easily adjust your code to apply new possibilities.

Games 262

Games Tuning Innovation Servers 262

The Netflix TechBlog

MARCH 5, 2024

That’s particularly true of our GRPC clients and servers, where request cancellations due to timeouts interact with reliability features such as retries, hedging and fallbacks. Operational simplicity Service owners often reach out to us with questions about excessive pause times and for help with tuning.

Latency 238

Latency Java Tuning Efficiency 238

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 139

Tuning Cache Servers Benchmarking 139

Scalegrid

NOVEMBER 20, 2019

times higher when the index creation happened on the master server. Stay tuned for my follow-on blog post with more details! By running index creation directly on the MySQL master, we could experience only 60% of the throughput that was achieved by running index creation on the MySQL slave through a rolling operation.

Best Practices 239

Best Practices Latency Tuning Database 239

Dynatrace

MAY 21, 2024

The settings on the General tab remain unchanged and govern the privacy settings executed on the server side ( masking at storage ), offering a second layer of control. To fine-tune your masking settings, select the entity you want to adjust and leverage the entity-specific settings.

Government 221

Government Storage Tuning Monitoring 221

SQL Shack

MARCH 4, 2021

Introduction Sometimes, query tuning operations can get very challenging and complicated in SQL Server. With the SQL Server 2016, a new feature Query Store has been introduced and this feature […].

Tuning 71

Tuning Servers Performance 71

Scalegrid

MARCH 4, 2019

from these database reporters, and CouchDB, Berkeley DB, Microsoft SQL Server, Redshift, Firebase, Elasticsearch, and InfluxDB users combined our Other category at 2.4%. DB-Engines Ranking – Trend Popularity report places these leaders in the top 5, but Oracle keeps hold at number one and Microsoft SQL Server at number 3.

Database 255

Database Metrics Systems Strategy 255

The Netflix TechBlog

NOVEMBER 11, 2022

On the client’s side, a request is sent to the streaming server to obtain the protected encrypted digital content. The backbone of DRM is the use of digital licenses, which specify a set of usage rights for the digital content and contain the permissions from the owner to stream the content via an on-demand streaming service.

C++ 322

C++ Metrics Tuning Strategy 322

SQL Server According to Bob

SEPTEMBER 9, 2019

I recall when we were tuning the sp_reset_connection (which releases the database lock and acquires it again) command we tested rates in excess of 250,000/sec to ensure the partitioned database lock scaled: [link]. Bob Dorr – Principal Software Engineer SQL Server.

Servers 103

Servers Database Scalability Tuning 103