John McCalpin

APRIL 2, 2020

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). Here I assumed a particular analytical function for the amount of memory traffic as a function of cache size to scale the bandwidth time.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

Dean Hume

APRIL 24, 2018

Without effective caching on the client, the server will see an increase in workload, more CPU usage and ultimately increased latency for the end user. CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). This is where service workers can make a difference.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Without effective caching on the client, the server will see an increase in workload, more CPU usage and ultimately increased latency for the end user. CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). This is where service workers can make a difference.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Without effective caching on the client, the server will see an increase in workload, more CPU usage and ultimately increased latency for the end user. CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). This is where service workers can make a difference.

Energy 40

Energy Cache Traffic Website 40

SQL Performance

SEPTEMBER 17, 2019

SSRS 2008 brought that component into the reporting service module. Caches of report results are stored in the ReportServerTempDB database and I/O performance can become an issue here. To tune for a slow report, that usually means you need to create indexes for that specific report or tune the code within the report.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. SET NOCOUNT , XACT_ABORT ON ; -- Prevent plan caching for this procedure. -- See [link]. Notice the lack of a check at 1250 due to the code quirk I mentioned.

Database 98

Database Storage Testing Servers 98

Percona

JUNE 4, 2023

MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. MySQL is one of the most popular open source RDBMS used by organizations of all sizes due to its reliability, scalability, and performance.

Open Source 52

Open Source Servers Storage Scalability 52