article thumbnail

An approach to index tuning – part 1

SQL Performance

A performance tuning engagement can end up taking many turns as you work through it – it all depends on what is showing up as the problem and what the data tells you. One of my favorite parts of tuning is working with indexes and, as I was thinking about this post, I was tempted to label index tuning as an "easier" task… but it really isn't.

Tuning 130
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. Once we have that data, we can move on to the next steps in the process. Once we have that data, we can move on to the next steps in the process.

Tuning 137
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

Tech Transforms podcast: SBOMs and the mission for federal government cybersecurity – down to the software supply chain

Dynatrace

After pushing for a faster timeline, the White House told the government it had 60 days to issue a minimum definition of SBOMs. In this episode, Friedman explained the challenges with this process, namely balancing perspectives from across government and industry. SBOM is one of them.” government.

article thumbnail

Dynatrace SaaS release notes version 1.241

Dynatrace

To stay tuned, keep an eye on our release notes. Remediation tracking now enables you to view the risk assessment for the process groups affected by a vulnerability. The title size of a tile has been moved from the dashboard definition to the dashboard metadata definition and included in the advanced settings UI for dashboards.

Tuning 185
article thumbnail

Evolving from Rule-based Classifier: Machine Learning Powered Auto Remediation in Netflix Data…

The Netflix TechBlog

Operational automation–including but not limited to, auto diagnosis, auto remediation, auto configuration, auto tuning, auto scaling, auto debugging, and auto testing–is key to the success of modern data platforms. In this way, no human intervention is required in the remediation process. Multi-objective optimizations. user name).

Tuning 210
article thumbnail

Support of OpenTelemetry metrics with enhanced AI capabilities

Dynatrace

With the announcement at KubeCon Europe , most components (specification, APIs, SDKs) that create, collect, and process OpenTelemetry metrics now have the complete set of OpenTelemetry metrics functionality and are ready for use. Metrics are stored for easy analysis on dashboards, definition of service level objectives, and more.

Metrics 222
article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. SHMMAX is a kernel parameter used to define the maximum size of a single shared memory segment a Linux process can allocate. Be aware of differing definitions. SHMMAX / SHMALL.

Tuning 55