article thumbnail

An approach to index tuning – Part 2

SQL Performance

In my last post , I started to outline the process I go through when tuning queries – specifically when I discover that I need to add a new index, or modify an existing one. This is where index tuning becomes an art. Step 6: Testing. Once we have that data, we can move on to the next steps in the process.

Tuning 137
article thumbnail

Heap Memory In Java Applications Performance Testing

DZone

To completely fine-tune the java performance bottlenecks for high performance my answer is YES. Java memory management is a significant challenge for every performance engineer and Java developer, and a skill that needs to be acquired to have Java applications properly tuned.

Java 305
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52
article thumbnail

Migrating Critical Traffic At Scale with No Downtime?—?Part 1

The Netflix TechBlog

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 approach has a handful of benefits.

Traffic 339
article thumbnail

Three priorities for driving operational resilience in financial services in the U.K. using PRA SS1/21

Dynatrace

The three most pertinent requirements are the need for tracking impact tolerances, business service mapping, and testing critical services. Testing using synthetic monitoring enables firms to fine-tune the parameters of individual tests.

Tuning 221
article thumbnail

The Dynatrace journey toward DORA compliance

Dynatrace

The regulation covers areas like Information and Communication Technology (ICT) risk management, third-party risk, digital operational resilience testing, and reporting of major ICT-related incidents to competent authorities. The Dynatrace data-centric approach ensures compliance isn’t a burden; it’s an opportunity to fine-tune operations.

Tuning 239
article thumbnail

Tuning PostgreSQL Database Parameters to Optimize Performance

Percona

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. For testing purposes, let’s increase this to 256MB and see if there is any impact on cost.

Tuning 58