Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers. This was a chance to talk about other things I've been working on, such as the present and future of hardware performance.

Performance 121

Performance Latency Hardware Storage 121

Percona

AUGUST 4, 2023

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. in 2017; after that, major releases came every one to two years, with MariaDB 10.6 It is worth noting both MySQL and MariaDB have Community and Enterprise versions.

Database 98

Database Servers Innovation Open Source 98

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

The Netflix TechBlog

OCTOBER 27, 2023

When this happens, usually a k8s cloud-controller provided by the cloud vendor will detect that the actual server, in our case an EC2 Instance, has actually gone away, and will in turn delete the k8s node object. Where Do Lost Nodes Come From? Nodes can go away for any reason, especially in “the cloud”. UDP packet?

Hardware 234

Hardware Cloud Servers Code 234

SQL Server According to Bob

MARCH 18, 2018

SQL Server is designed to scale across the spectrum of small machines to enterprise class servers. The changes made in SQL Server 2017 CU4 improve resource usage on smaller machines, such as a VM or Container used for testing and development. For SQL Server 2017 CU4 the small environment threshold is 2GB.

Servers 40

Servers Best Practices Software Engineering Operating System 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. 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. Hope to see you there. Microsoft.

Servers 40

Servers Tuning Database Cloud 40

Brendan Gregg

SEPTEMBER 5, 2017

Oracle VM Server is based on Xen. I came up with a great demo where I could break Solaris 9 and 10 servers in the same way, then demonstrate how it would take an hour and a reboot cycle to fix Solaris 9, but minutes and no reboot to fix Solaris 10. amazon"). I also wrote and published an entertaining SMF manifest that played music.

Virtualization 75

Virtualization AWS Engineering Hardware 75

SQL Performance

AUGUST 14, 2019

SQL Server 2016 introduces the batch-mode Window Aggregate operator, which removes the performance penalty part of the pitfall, but prior to SQL Server 2019 this operator is used only if you have a columnstore index present on the data. 2017-07-04 10248 440.00 2017-07-05 10249 1863.40 2017-07-08 10250 1552.60

Best Practices 108

Best Practices Servers Database Azure 108

High Scalability

NOVEMBER 30, 2018

during the 2017-18 academic year, on top of a 3.3% ” @emileifrem : Adobe used 125 MongoDB servers to run their activity feed. It was replaced by 48 Cassandra servers. servers of Neo4j. They'll love it and you'll be their hero forever. million : concurrent Fortnite players; 6.2 decline the year before.".

Internet 28

Internet Internet Scalability Blockchain 28

SQL Performance

SEPTEMBER 12, 2019

As an example with our task, suppose that you don't realize that the grouping element is determined implicitly, and you come up with the following query: SELECT shipperid , [ 2017 ] , [ 2018 ] , [ 2019 ] FROM Sales. So you're expecting to see only three rows in the result. 830 rows affected).

Best Practices 103

Best Practices C++ Code Design 103

Dynatrace

JUNE 15, 2023

If your application runs on servers you manage, either on-premises or on a private cloud, you’re responsible for securing the application as well as the operating system, network infrastructure, and physical hardware. The financial services sector alone saw a surge in web application and API attacks of 257% from 2021 to 2022.

Cloud 245

Cloud Open Source Architecture Monitoring 245

Scalegrid

JULY 13, 2020

Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. PostgreSQL is an open source object-relational database system with over 30 years of active development. In fact, PostgreSQL is so popular, 11.5%

Open Source 244

Open Source C++ Tuning Database 244

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. Lambda functions are often used as back ends for static, single-page applications, and many customers asked for the same level of insights they get when running Dynatrace against a regular web server.

Lambda 278

Lambda AWS Monitoring Serverless 278

SQL Shack

OCTOBER 6, 2020

In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances. Introduction SQL Server 2017 & 2019 works on the cross-platform operating system: Windows and Linux. You […].

Servers 52

Servers Availability Operating System Systems 52

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. Description.

IoT 61

IoT Servers Development Cache 61

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 103

Performance Latency Cache Google 103

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. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server. Installation and support of SSRS can be confusing.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

JULY 8, 2020

I should stress that in practice, there’s no actual process in which SQL Server converts the original query string with the nested logic to a new query string without the nesting. As mentioned, SQL Server will attempt to unnest table expressions, but will avoid the unnesting if it stumbles into an unnesting inhibitor.

Servers 110

Servers Code Performance Processing 110

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT.

C++ 111

C++ Database Servers Code 111

SQL Performance

JANUARY 10, 2020

Earlier this week, Microsoft announced SQL Server 2019 Cumulative Update #1. To update your local Docker image: docker pull mcr.microsoft.com/mssql/server: 2019 -latest. Build a slipstreamed installer once ( Randolph West explains this process for 2017 here ), and use that for consistency across your environment.

Servers 52

Servers Testing Processing 52

Dynatrace

OCTOBER 17, 2019

We’re no longer living in an age where large companies require only physical servers, with similar and rarely changing configurations, that could be manually maintained in a single Datacenter. We went from managing five EC2 instances in 2011 to around 1,000 in 2017. Dynatrace news. with more being added continually.

Code 167

Code Infrastructure DevOps Cloud 167

Scalegrid

APRIL 2, 2019

These results are pretty on-par with a 2017 survey by the Uptime Institute which found that 65% of enterprise workloads were still running in data centers owned and operated by those enterprises. using SQL Server, 17.3% So, how are PostgreSQL users choosing to host the clusters that power their applications? are using public clouds.

Database 185

Database Cloud Open Source Azure 185

SQL Performance

FEBRUARY 12, 2020

Curiously, SQL Server's query processor already supports an internal comparison operator IS, which uses the same semantics as the desired IS operator I described here. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. Consider the following query as an example: SELECT orderid , shippeddate FROM Sales.

C++ 120

C++ Code Servers Database 120

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. Background. The Query Optimizer. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

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

SQL Performance

DECEMBER 11, 2019

WHERE NOT ( shippeddate = '20190102' ) ; This query returns the following output: orderid shippeddate -- -- 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. WHERE shippeddate IS NOT NULL ; This query generates the following output: orderid shippeddate -- -- 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12.

Best Practices 117

Best Practices C++ Database Code 117

SQL Performance

JULY 9, 2019

I posted a suggestion to improve SQL Server by adding support for nested window functions. 2 2017-09-18 88.80 Hopefully, this article will increase awareness of the true nested window functions feature, and cause people to turn to Microsoft and ask to add support for it in SQL Server. 10248 85 2017-07-04 440.00

Servers 83

Servers Availability Database Code 83

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

SQL Performance

AUGUST 11, 2021

Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. SQL Server Management Studio already has IntelliSense support, as shown in Figure 1: Figure 1: Intellisence support for DATE_BUCKET in SSMS. 2017 343 495118.14

Azure 139

Azure Code Database Servers 139

SQL Server According to Bob

DECEMBER 11, 2017

SQL Server 2019 CTP2. SQL Server 2019 adds broad support for distributed transactions (both MSDTC/OLE-TX and XA) to SQL Server on Linux. You can establish and use transactions between Linux and Linux or Linux and Windows instances of SQL Server or your application. Configuring MSDTC for SQL Server on Linux: [link].

Servers 40

Servers Database Software Engineering Engineering 40

All Things Distributed

NOVEMBER 13, 2018

Since then, AWS has added another PoP in Palermo in 2017. ENEL is using AWS to transform its entire business, closing all of their data centers by 2018, migrating workloads from over 6,000 on-premises servers onto AWS in nine months, and using AWS IoT services to better manage and understand energy consumption.

AWS 164

AWS Energy Automotive Traffic 164

Alex Russell

MARCH 6, 2021

TL;DR: A lot has changed since 2017 when we last estimated a global baseline resource per-page resource budget of 130-170KiB. To update our global baseline from 2017, we want to update our priors on a few dimensions: The evolved device landscape. The Moto G4 , for example. Here begins our 2021 adventure. Hard Reset.

Performance 127

Performance Network Mobile Metrics 127

All Things Distributed

OCTOBER 25, 2018

In 2017, we brought the Amazon Global Network to Africa, through AWS Direct Connect. What would have taken two weeks on local servers now only takes a few minutes. In 2015, we expanded our presence in the country, opening an AWS office in Johannesburg. Since then, we have seen an acceleration in AWS adoption.

AWS 167

AWS Cloud Education Programming 167

SQL Server According to Bob

FEBRUARY 11, 2019

SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to assist in transaction log processing activities. You may find the number of log write workers has been increased to 8 when running newer releases of SQL Server to accommodate larger systems.

Servers 40

Servers Availability Software Software 40

SQL Server According to Bob

APRIL 24, 2018

When I joined Microsoft in 1993, I would embark on a 25 year journey working only on Windows laptops and Windows Server computers. Last October we released SQL Server 2017 including support for Linux and Docker Containers. So here in this blog post, I will show you my journey in taking the SQL Server Mac Challenge.

Servers 40

Servers Internet Internet Open Source 40

SQL Server According to Bob

FEBRUARY 10, 2019

SQL Server 2017 introduced a small change to SQL Server’s default worker thread calculation, accounting for smaller environments. When running on smaller environments SQL Server reduces the worker target. On small environments SQL Server always uses 256 as the target.

Servers 40

Servers Design Systems 40

SQL Server According to Bob

DECEMBER 26, 2017

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Q uick XE Trace ’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release. Here is an example using the SQL Server SSMS 2017 against my SQL 2016 server.

Servers 40

Servers Software Engineering Engineering Availability 40