SQL Performance

SEPTEMBER 17, 2019

For years SSRS was bundled with the installation of SQL Server, which helped add to some of the confusion around licensing and support for the product, so beginning with SSRS 2017, the installation package for Reporting Services is a separate download. Tuning Options. Tuning SSRS is much like any other application.

Tuning 67

Tuning Servers Database Best Practices 67

Dynatrace

FEBRUARY 25, 2021

since 2017, and many customers have used it with great success while we collected requirements for the next iteration of our Lambda extension. Stay tuned?for Gartner predicts that by 2025, 50% of all global enterprises will have deployed serverless function platforms as a service (fPaaS), up from only 20% today. functionality?in

Lambda 278

Lambda AWS Monitoring Serverless 278

The Netflix TechBlog

MAY 1, 2019

In late 2017, we received some critical feedback from the brothers on the Stranger Things 2 audio mix: in some scenes, there was a reduced sense of where sounds are located in the 5.1-channel For example, have you ever seen a TV show where the video and audio were a little out of sync?

Engineering 274

Engineering Network Media Entertainment 274

Brendan Gregg

SEPTEMBER 5, 2017

Both Xen and KVM have had many performance and security improvements, and workloads can now be tuned to run at almost bare metal speeds (say, a 3% loss or less). If that seems wildly unacceptable, note that you can tune overcommit on Linux to not do this, and behave more like Solaris (see sysctl vm.overcommit_memory).

Virtualization 75

Virtualization AWS Engineering Hardware 75

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. Query Store 2017 to the Rescue.

Tuning 115

Tuning Servers Monitoring Hardware 115

SQL Server According to Bob

SEPTEMBER 25, 2017

Scott Guthrie and Rohan Kumar officially made the announcement today at Ignite that SQL Server 2017 will be generally available on October 2nd, 2017. Andrew Brust also wrote a very nice article detailing out all the great new features that come with SQL Server 2017. Check out ScottGu’s blog post at: [link].

Servers 40

Servers Availability Tuning Database 40

SQL Server According to Bob

SEPTEMBER 27, 2017

Please check out a new blog post I created detailing how SQL Server 2017 is Fast, Built-In. How we keep you fast and tuned with Adaptive Query Processing and Automatic Tuning. Look for more details on my blog post and the SQL Server Blog about some of these concepts and new features for performance for SQL Server 2017.

Servers 40

Servers Tuning Database Cloud 40

The Netflix TechBlog

OCTOBER 19, 2020

By 2017, open source projects like Open-Tracing and Open-Zipkin were mature enough for use in polyglot runtime environments at Netflix. Our engineering teams tuned their services for performance after factoring in increased resource utilization due to tracing.

Infrastructure 237

Infrastructure Transportation Storage Open Source 237

The Netflix TechBlog

JULY 1, 2019

An example console output showing surface cache over budget errors During brainstorming with our platform team, we came across an internal bug report from 2017 that described a similar issue to what we were seeing?—?surfaces those running the 2017 SDK?—?also The SNG files have a relatively large download size at ~1.5MB each.

Cache 166

Cache Design Testing Development 166

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at [Kernel Recipes] in 2017 and have shared the full story here. ## 1. The default size is 128 Kbytes, and people shouldn't be tuning below 8 Kbytes. A microservice team asked me for help with a mysterious issue. They claimed that the ZFS file system was consuming 30% of CPU capacity.

Cache 141

Cache Cloud Code Java 141

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 million requests per second. All of this is done for you automatically and with zero downtime so that you can focus on your customers, your applications, and your business.

Internet 110

Internet Internet AWS Performance 110

Percona

JANUARY 17, 2019

Here is a summary of the queries: Simple queries: select count(*) from ontime where flightdate > '2017-01-01'. sec) mysql> select count(*) from ontime where flightdate > '2017-01-01'; + -+ | count(*) | + -+ | 5660651 | + -+ 1 row in set (2 min 48.81 select avg(DepDelay/ArrDelay+1) from ontime.

Cache 72

Cache C++ AWS Airlines 72

Brendan Gregg

SEPTEMBER 25, 2021

[both hands]: /blog/2021-05-23/what-is-observability.html [What is Observability]: /blog/2021-05-23/what-is-observability.html [Ftrace version]: [link] [CPU flame graphs]: /FlameGraphs/cpuflamegraphs.html [Linux performance tools]: /linuxperf.html [Linux tunables]: /blog/2015-03-03/performance-tuning-linux-instances-on-ec2.html

Speed 103

Speed Java AWS Virtualization 103

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. From migrations, database design, and architecture … to performance assessment and tuning … to proactive monitoring and management of your databases — you’re covered. Free from vendor lock-in.

Open Source 98

Open Source Healthcare Social Media Database 98

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. Finding a small number of distinct values might seem like quite a specific requirement, but I have come across it fairly frequently over the years, usually as part of tuning a larger query. Test Environment. Final Thoughts.

Servers 86

Servers Tuning Database Efficiency 86

KeyCDN

JANUARY 31, 2019

As for Romania, it covers an area of over 238,000 square kilometers and as of 2017 had a population of almost 20 million. In 2017, the average speed was 21.33Mb/s ranking them 18th in the world. As of 2016, Bucharest alone had a population of over 1.83 million people. million Romanian eCommerce users who spend an average of $237.38

Internet 48

Internet Internet Ecommerce Speed 48

Percona

APRIL 12, 2023

2017: MongoDB goes public, trading as MDB. So if they can’t beat ‘em in the DBaaS space, they often feel like they have to join ‘em — to the tune of total stack sharing or some proprietary arrangement. Some might say this marked the beginning of MongoDB’s “cloud push” escalation.)

Open Source 98

Open Source Programming Database Servers 98

Scalegrid

AUGUST 27, 2024

The software also extends capabilities allowing fine-tuning consumption parameters through QoS (Quality of Service) prefetch limits catered toward balancing load among numerous consumers, thus preventing overwhelming any single consumer entity. References RabbitMQ Case Studies RabbitMQ in IoT Solutions Videla, A., & Williams, J.

Ecommerce 130

Ecommerce IoT Games Scalability 130

SQL Server According to Bob

JANUARY 12, 2018

I’d love to focus on SQL Server 2017 and SQL Server on Linux, but I’m open to hearing anything you want to talk about (or if you want to talk about my Dallas Cowboys or Texas Rangers that works). Follow the PASS Facebook page at [link] to get more updates on how to tune in.

Social Media 40

Social Media Servers Media Tuning 40

SQL Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Experience SQL Server 2017: The Modern Database Platform – Bob Ward.

Engineering 40

Engineering Azure Best Practices Servers 40

O'Reilly Software

APRIL 4, 2018

The data shape will dictate capacity planning, tuning of the backbone, and scalability analysis for individual components. As Tyler Akiadu, from Google, explained in his Strata NY 2017 presentation, “ Foundations of streaming SQL ”: “Streams are the in-motion form of data, both bounded and unbounded.” At least once? At most once?

Architecture 80

Architecture Scalability Google Operating System 80

KeyCDN

OCTOBER 24, 2018

According to Wikipedia , the average connection speed in Q1 of 2017 was 20.5Mbps. Alternatively, If you would like to request a POP in a certain location or a new feature please let us know on our feature requests community page and stay tuned for more exciting announcements. This is a massive increase from year 2000 when only 37.2%

Internet 48

Internet Internet Speed Network 48

Particular Software

DECEMBER 14, 2020

ServiceControl Management has been storing license files here since November 2017 , so your license file is already installed there. Stay tuned for it. ServiceControl Management and ServiceControl instances are always looking at the same license data. Everything should Just Work™. at your next available upgrade window.

Azure 52

Azure Transportation Tuning Processing 52

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 123

Performance Design Best Practices Testing 123

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at Kernel Recipes in 2017; it is an old story that's worth resharing here. The default size is 128 Kbytes, and people shouldn't be tuning below 8 Kbytes. A microservice team asked me for help with a mysterious issue. They claimed that the ZFS file system was consuming 30% of CPU capacity.

Cache 52

Cache Cloud Java Code 52

SQL Performance

MAY 7, 2019

Understanding what these mean and how to investigate them is critical so you don’t succumb to what I call ‘knee-jerk performance tuning’ and waste time and effort trying to fix a problem that isn’t actually a problem. A better way is to track waits over small intervals, say half an hour, and a script to do that is here. Waits Resources.

Servers 40

Servers Metrics Azure Tuning 40

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at [Kernel Recipes] in 2017; it is an old story that's worth resharing here. ## 1. The default size is 128 Kbytes, and people shouldn't be tuning below 8 Kbytes. A microservice team asked me for help with a mysterious issue. They claimed that the ZFS file system was consuming 30% of CPU capacity.

Cache 40

Cache Cloud Code Java 40

Alex Russell

MARCH 31, 2022

Like every other successful platform, the web operates on a finely tuned understanding of risk and trust , and deprecations are particularly explosive. [2] The idea was floated in 2017 , aired in concrete form for more than a year , and our friends at Mozilla spoke warmly of it. Trust Falls #. WebKit even implemented the change.

Cache 89

Cache Government Traffic Network 89

Brendan Gregg

SEPTEMBER 25, 2021

[both hands]: /blog/2021-05-23/what-is-observability.html [What is Observability]: /blog/2021-05-23/what-is-observability.html [Ftrace version]: [link] [CPU flame graphs]: /FlameGraphs/cpuflamegraphs.html [Linux performance tools]: /linuxperf.html [Linux tunables]: /blog/2015-03-03/performance-tuning-linux-instances-on-ec2.html

Speed 40

Speed Java AWS Virtualization 40

Randon ASCII

APRIL 17, 2018

When you own all of the code then this may involve some back of the envelope estimates, competitive benchmarking, or intuition tuned by experience. Another instance of this problem was hit in November 2017 and is described here. The JetBrains/intellij developers also encountered this problem and worked around it in the same way.

Monitoring 43

Monitoring C++ Code Processing 43

O'Reilly

JULY 25, 2023

To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022. This choice also inspired me to call my project Swift Papers.

Programming 98

Programming Code Design Benchmarking 98

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. This helps identify potential issues and fine-tune the partitioning strategy. It’s a pretty common question around here, so let’s see what we can do about that. So, What is MySQL Partitioning? Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

John McCalpin

JANUARY 22, 2018

A peculiar throughput limitation on Intel’s Xeon Phi x200 (Knights Landing) Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC.

Latency 40

Latency Hardware Code Testing 40

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. of the “adjusted peak performance”, there is no longer a significant upside to performance tuning.

Latency 40

Latency Hardware Code Testing 40

SQL Performance

SEPTEMBER 2, 2021

I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT(). He spent a lot of time fine-tuning this CLR function to efficiently parse a string. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1.

C++ 46

C++ Servers Testing Performance 46

The Netflix TechBlog

FEBRUARY 13, 2024

Stay tuned — our next post will develop sequential testing procedures for count data. A total of 66 out of 100 A/A simulations falsely rejected the null hypothesis. This is a manifestation of “peeking”, and much has been written about the downside risks of this practice (see, for example, Johari et al.

Testing 246

Testing Software Software Metrics 246

Rigor

SEPTEMBER 11, 2019

His keynote address from O’Reilly Fluent 2017, Reflecting on 20 years on the web , is a must-see. He served as the Editor-in-Chief of Smashing Magazine until October 2017 when he passed the baton to the remarkable Rachel Andrew. Most recently, he launched a fantastic new HTML5 Mastery… course. Vitaly Friedman. Doug Sillars.

Performance 89

Performance Education Google Website 89