SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115

Tuning Servers Monitoring Hardware 115

HammerDB

JUNE 27, 2022

It enables the user to measure database performance and make comparative judgements about database hardware and software. These factors meant that often when looking for database performance information, the results for a particular combination of software and hardware were not available. What is HammerDB? Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Scalegrid

JANUARY 8, 2024

Understanding Multi-Cloud and Hybrid Cloud Cloud computing has revolutionized the IT industry, offering a host of advantages including cost-effectiveness, increased agility, and access to cutting-edge hardware. What is the primary benefit of multi-cloud solutions in comparison to hybrid cloud solutions? But what do these entail?

Strategy 147

Strategy Cloud Scalability Artificial Intelligence 147

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Percona

DECEMBER 27, 2022

Cluster-level encryption is a security measure that encrypts data stored in a cluster of servers or storage devices. . Cluster-level encryption can help protect data at rest and in motion when transmitted between servers in the cluster. Several RDBMSs, including Oracle, MySQL, and Microsoft SQL Server, support it. PostgreSQL.

Database 93

Database Storage Servers Strategy 93

All Things Distributed

MARCH 19, 2018

Amazon SageMaker training supports powerful container management mechanisms that include spinning up large numbers of containers on different hardware with fast networking and access to the underlying hardware, such as GPUs. Amazon SageMaker algorithms train larger models on more data than any other open-source solution out there.

Scalability 153

Scalability Hardware AWS Tuning 153

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. As I'm interested in the relative comparison I can just compare the total runtimes (the "real" time) for the same result.

Speed 112

Speed Java AWS Virtualization 112

ScaleOut Software

APRIL 22, 2020

A widely used technology called distributed caching meets this need by storing frequently accessed data in memory on a server farm instead of within a database. This speeds up accesses and updates while offloading back-end database servers. To accomplish this, distributed caches typically store each object on two (or more) servers.

Cache 52

Cache Storage Servers Database 52

ScaleOut Software

APRIL 22, 2020

A widely used technology called distributed caching meets this need by storing frequently accessed data in memory on a server farm instead of within a database. This speeds up accesses and updates while offloading back-end database servers. To accomplish this, distributed caches typically store each object on two (or more) servers.

Cache 52

Cache Storage Servers Database 52

Smashing Magazine

AUGUST 22, 2021

Latency can be roughly defined as the time it takes to send a packet from point A (say, the client) to point B (the server). This is one of the main reasons why content delivery networks (CDNs) exist: They place servers physically closer to the end user in order to reduce latency, and thus delay, as much as possible. and prior (a)).

Performance 107

Performance Network Latency Servers 107

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. 30.14% in the middle of the flame graph. Searching shows it was elsewhere as well for a total of 32.1%. us on Ubuntu.

Speed 52

Speed Java AWS Virtualization 52

HammerDB

OCTOBER 12, 2018

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. Historically MySQL has been positioned for supporting web-based applications this is in contrast to enterprise based database workloads that have been served by commercial databases such as Oracle, Db2 and SQL Server.

Best Practices 40

Best Practices Scalability Performance C++ 40

Brendan Gregg

AUGUST 8, 2017

Thankfully, I found some older linux-devel mailing list archives, rescued from server backups, often stored as tarballs of digests. It's time in some cgroup paths, but this server is not doing much disk I/O. My search was starting to feel cursed. But it was somehow missing from all of them. to the load average. Yes, I'd say so.

Latency 111

Latency Metrics C++ Systems 111

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. As I'm interested in the relative comparison I can just compare the total runtimes (the "real" time) for the same result.

Speed 40

Speed Java AWS Virtualization 40

Brendan Gregg

SEPTEMBER 5, 2017

Linux has been adding tracing technologies over the years: kprobes (kernel dynamic tracing), uprobes (user-level dynamic tracing), tracepoints (static tracing), and perf_events (profiling and hardware counters). Oracle VM Server is based on Xen. amazon"). I also wrote and published an entertaining SMF manifest that played music.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Highly Scalable

SEPTEMBER 18, 2012

A database should accommodate itself to different data distributions, cluster topologies and hardware configurations. In comparison with pure anti-entropy, this greatly improves consistency with a relatively small performance penalty. Data Placement. It can be considered as a kind of targeted anti-entropy.

Database 213

Database Latency C++ Scalability 213

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I will compare AWS Aurora with MySQL (Percona Server) 5.6 For my test, I need to choose: Aurora instance type and comparison. Aurora instance type and comparison. With faster disks (i.e.

Cache 48

Cache C++ AWS Airlines 48

The Morning Paper

NOVEMBER 15, 2020

Achieving 100 Gbps intrusion prevention on a single server , Zhao et al., Today’s paper choice is a wonderful example of pushing the state of the art on a single server. Moreover, Pigasus wants to do all this on a single server! Can you really do all this on a single server?? OSDI’20. Please do join us if you can.

Servers 128

Servers Hardware Latency Design 128

Scalegrid

JULY 13, 2020

The $47,500 licensing costs for Oracle Enterprise Edition is only for one CPU core, that ultimately has to be multiplied with the actual number of cores on the physical server. Comparison Overview. Oracle support for hardware and software packages is typically available at 22% of their licensing fees. . $104,310. PostgreSQL.

Open Source 244

Open Source Tuning C++ Database 244

Smashing Magazine

APRIL 29, 2021

Device Pixel Ratio (DPR) represents how a CSS pixel is translated to physical pixels on a hardware screen. Understanding the myriad of image format options out there today can be a confusing process, but you may find Cloudinary’s comparison of modern image formats helpful: There are plenty of format options for images. Large preview ).

Media 145

Media Network Metrics Mobile 145

Smashing Magazine

JANUARY 11, 2021

Alternatively, you can also use: Addy Osmani’s Chrome UX Report Compare Tool , Speed Scorecard (also provides a revenue impact estimator), Real User Experience Test Comparison or SiteSpeed CI (based on synthetic testing). It used to provide an insight into how quickly the server outputs any data. What does it mean?

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? It used to provide an insight into how quickly the server outputs any data. Large preview ). What does it mean?

Performance 145

Performance Cache Servers Network 145

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 104

Performance Cache Metrics Network 104