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

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

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

The Netflix TechBlog

JULY 1, 2019

While web browsers and mobile phones have gigabytes of memory available for graphics, our devices are constrained to mere MBs. Each device running the Netflix TV application has a limited surface cache pool available so the rendering engine tries to maximize the usage of the cache as much as possible. those running the 2017 SDK?—?also

Cache 167

Cache Design Testing Development 167

All Things Distributed

OCTOBER 2, 2017

We were pushing the limits of what was a leading commercial database at the time and were unable to sustain the availability, scalability and performance needs that our growing Amazon business demanded. In support of Amazon Prime Day 2017, the biggest day in Amazon retail history, DynamoDB served over 12.9 million requests per second.

Internet 110

Internet Internet AWS Performance 110

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. How-to documentation is readily available. It’s well-suited for organizations that require mission-critical applications with high availability. Bugs and security vulnerabilities are identified more quickly.

Open Source 98

Open Source Healthcare Social Media Database 98

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. 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.

Open Source 98

Open Source Programming Database Servers 98

Brendan Gregg

SEPTEMBER 25, 2021

Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. html [60s checklist]: /Articles/Netflix_Linux_Perf_Analysis_60s.pdf [re:Invent talk]: [link] [recommendation]: [link] [Nitro]: /blog/2017-11-29/aws-ec2-virtualization-2017.html

Speed 103

Speed Java AWS Virtualization 103

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. Here is a summary of the queries: Simple queries: select count(*) from ontime where flightdate > '2017-01-01'. With faster disks (i.e. AWS Aurora (based on MySQL 5.6)

Cache 72

Cache C++ AWS Airlines 72

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Having a wide range of tools available is generally speaking a good thing when tuning queries. Test Environment. The cost threshold for parallelism is set to 50.

Servers 86

Servers Tuning Database Efficiency 86

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. This support ensures flexibility in how messages are handled across different scenarios.

IoT 130

IoT Ecommerce Games Scalability 130

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

Particular Software

DECEMBER 14, 2020

ServiceControl Management has been storing license files here since November 2017 , so your license file is already installed there. At startup, ServiceControl Management will check to see if there’s a newer version available and if there is it will prompt you to download it. Stay tuned for it. Everything should Just Work™.

Azure 52

Azure Transportation Tuning Processing 52

Smashing Magazine

JUNE 3, 2022

There are many typefaces, and many of them are very similar or are nearly identical to previous or contemporary versions available. We want to allow accessibility via OpenType or stylistic options with the typeface, so they are available to use if needed. Stay tuned! These points could be extended to language support as well.

Performance 123

Performance Design Best Practices Testing 123

Alex Russell

MARCH 31, 2022

The best available proxy data also suggests that shared caches would have a minimal positive effect on performance. Like every other successful platform, the web operates on a finely tuned understanding of risk and trust , and deprecations are particularly explosive. [2] There's plenty of space for caching most popular frameworks.

Cache 89

Cache Government Traffic Network 89

SQL Performance

MAY 7, 2019

These threads are created when SQL Server starts, depending on the number of processor cores available for SQL Server to use. The waiter list , which has all the threads that are basically stuck, waiting for a particular resource to become available. Waits Resources. You can get to the library at [link].

Servers 40

Servers Metrics Azure Tuning 40

Brendan Gregg

SEPTEMBER 25, 2021

Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource xen tsc hpet acpi_pm $ cat /sys/devices/system/clocksource/clocksource0/current_clocksource xen Ok, so it's defaulted to xen, which we saw in the flame graph (the tower ends with pvclock_clocksource_read()).

Speed 40

Speed Java AWS Virtualization 40

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. But still, I liked how Moment.js

Programming 98

Programming Code Design Benchmarking 98

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. The diagnosis is that file notification buffers are allocated out of pool memory ( ExAllocatePoolWithTag ) and then filled with the available notification data.

Monitoring 43

Monitoring C++ Code Processing 43

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. This helps identify potential issues and fine-tune the partitioning strategy.

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

The Netflix TechBlog

FEBRUARY 13, 2024

The remainder of this post discusses the first paper above, which was published at KDD ’22 (and available on ArXiV ). If you are curious about the technical details of the sequential tests for quantiles developed here, you can learn all about the math in our KDD paper ( also available on arxiv ).

Testing 248

Testing Software Software Metrics 248

Percona

JANUARY 14, 2019

To simulate text messages I have used ~3 billion of reddit comments (10 years from 2007 to 2017), downloaded from pushshift.io. With the latest ClickHouse version, all of these features are available, but some of them may not perform fast enough. This is all true for ClickHouse, however, we may be able to live with it for our task.

Database 48

Database Analytics Blockchain Healthcare 48