SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. 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.

Tuning 67

Tuning Servers Database Best Practices 67

Brendan Gregg

SEPTEMBER 5, 2017

Here's some output from my zfsdist tool, in bcc/BPF, which measures ZFS latency as a histogram on Linux: # zfsdist. Tracing ZFS operation latency. Oracle VM Server is based on Xen. Many new tools can now be written, and the main toolkit we're working on is [bcc]. Hit Ctrl-C to end. ^C

Virtualization 76

Virtualization AWS Engineering Hardware 76

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. This server is spending about a third of its CPU cycles just checking the time! I've shared many posts about superpower observability tools, but often humble hacking is just as effective. 30.14% in the middle of the flame graph.

Speed 126

Speed Java AWS Virtualization 126

KeyCDN

JANUARY 31, 2019

With Bucharest being the capital and largest city of Romania, it makes for a great edge server location. The next closest active POP location to Bucharest was Istanbul which was still almost 900km away; this distance adds up in terms of latency. In 2017, the average speed was 21.33Mb/s ranking them 18th in the world.

Internet 48

Internet Internet Ecommerce Speed 48

KeyCDN

OCTOBER 24, 2018

With Helsinki being the capital and most populous municipality of Finland, it makes for a great edge server location. Although both countries are relatively close to one another, they are separated by a distance of approximately 500km, which adds up in terms of latency. This is a massive increase from year 2000 when only 37.2%

Internet 48

Internet Internet Speed Network 48

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. This server is spending about a third of its CPU cycles just checking the time! I've shared many posts about superpower observability tools, but often humble hacking is just as effective. 30.14% in the middle of the flame graph.

Speed 40

Speed Java AWS Virtualization 40

All Things Distributed

OCTOBER 2, 2017

In support of Amazon Prime Day 2017, the biggest day in Amazon retail history, DynamoDB served over 12.9 percent availability in the event of a server, a rack of servers, or an Availability Zone failure. Performant – DynamoDB consistently delivers single-digit millisecond latencies even as your traffic volume increases.

Internet 128

Internet Internet AWS Performance 128