SQL Performance

SEPTEMBER 17, 2019

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. SSRS 2008 brought that component into the reporting service module. Tuning Options. Tuning SSRS is much like any other application.

Tuning 67

Tuning Servers Database Best Practices 67

Percona

APRIL 14, 2023

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Consolidate workloads: In the past, you might have wanted to split out additional replicas or cluster nodes to process specific types of workloads, such as those related to reporting. If needed, you can spin up a backup.

Database 83

Database Serverless Tuning Cloud 83

Dynatrace

JULY 24, 2023

We will also explore the evolution of DevOps automation and the significance of data-driven answers in unlocking streamlined, automated DevOps and SRE processes. Business process automation Business process automation is the foundation for improving operational efficiency.

DevOps 219

DevOps Traffic Efficiency Servers 219

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. The Sort only has 19 rows to process, so it consumes only 1ms or so. The parallel column store aggregate push down result of 57 million rows processed in 7ms (using 40ms of CPU) is remarkable, especially considering the hardware. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

JUNE 21, 2019

Prior to SQL Server 2012, the maximum server memory value only applied to the bufferpool, so customers needed to limit the amount of memory the bufferpool could use to save memory for the operating system and other processes. Part of that process is his Index Optimize procedure, which can take additional parameters to update statistics.

Servers 49

Servers Azure Hardware Database 49

Percona

JANUARY 14, 2019

Processed 4.15 Processed 4.15 Processed 8.19 Processed 8.19 Processed 4.15 Processed 3.05 Processed 8.19 toDate(max(created_utc))??????count()?? count()?? ? 2006-01-01 ? 2018-05-31 ? 4148248585 ? ???????????????????????????????????????????????????????????????????? 1 rows in set. Elapsed: 11.554 sec.

Database 40

Database Analytics Blockchain Healthcare 40

Smashing Magazine

JUNE 3, 2022

Here are some examples: Neue Haas Grotesk (1956), Helvetica (1957), Arial (1982), Bau (2002), Akkurat (2004), Aktiv Grotesk (2010), Acumin (2015), Real (2015); Frutiger (1976), Myriad (1992), Monotype SST (2017), Squad (2018), Silta (2018); Collis (1993), Novel (2008), Elena (2010), Permian (2011), Lava (2013). Stay tuned!

Performance 111

Performance Design Best Practices Testing 111