Remove Cache Remove Definition Remove Servers Remove Tuning
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. His version can be used for the plan cache – the only challenge there is the information is transient, so you may not capture every query that uses a particular index.

Tuning 137
article thumbnail

Migrating Netflix to GraphQL Safely

The Netflix TechBlog

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 353
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 Connection Pooling: Part 2 – PgBouncer

Scalegrid

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. How Does PgBouncer Work?

Cache 246
article thumbnail

Impact of Querying Table Information From information_schema

Percona

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache 98
article thumbnail

Mundane Improvements, Big Impact

Tim Kadlec

The cache hit was very low (a topic for another day), and whenever the server had to provide a fresh version of the page, it was taking an unacceptably long time more often than not. Synthetic tests, even properly tuned to match device and network characteristics, only occasionally surfaced the issue.

Tuning 69
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40
article thumbnail

A use case for sp_prepare / sp_prepexec

SQL Performance

So when their compiled application sends ad hoc queries to SQL Server, particularly as a prepared statement, and when we don't have the freedom to add or change indexes, several tuning opportunities are immediately off the table. We'd definitely prefer to change the query, or the indexes, if we could. Let's try a plan guide.

Cache 59