Percona

FEBRUARY 24, 2023

Usage reduction: What to look for to reduce PostgreSQL cloud costs The first step in cost reduction is to use what you need and not more. Usage reduction is a continuous process. Marked in red in Figure 1 is a server with less than 30% of CPU usage. Don’t pay for capacity you don’t use or need.

Cloud 118

Cloud Serverless AWS Storage 118

Percona

SEPTEMBER 1, 2023

While much information has been published on this topic over the years, I wanted to break down some of the more critical settings that anyone can implement with no guesswork required. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server.

Tuning 52

Tuning Database Performance Hardware 52

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented.

Servers 95

Servers Tuning Architecture Processing 95

SQL Performance

APRIL 8, 2021

This is the second part of a five-part series taking a deep dive into the way SQL Server row mode parallel plans start up. SQL Server executes a query through a process known as a query scan. The query scan object also maintains state information, and exposes other operator-specific methods needed during execution.

Storage 94

Storage Transportation Engineering Processing 94

The Morning Paper

SEPTEMBER 10, 2019

Broadly, these can be categorized as: reporting and dashboarding, embedded statistics in pages, time-series monitoring, and ad-hoc analysis. Procella: unifying serving and analytical data at YouTube Chattopadhyay et al., VLDB’19. Well, I say the future, but “ Procella has now been in production for multiple years. are divided.

Analytics 75

Analytics Latency Cache Google 75

SQL Server According to Bob

JANUARY 11, 2020

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 White Paper is for informational purposes only.

Servers 40

Servers Cache Media Hardware 40