SQL Shack

AUGUST 25, 2020

In the previous article, An overview of distributed SQL Server Always On Availability Groups, we explored the concept of the distributed availability groups in SQL Server always on availability group. It is available from Windows Server 2016 and SQL Server 2017.

Availability 76

Availability Servers 76

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

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

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

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 84

Database Servers Innovation Open Source 84

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

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 Tuning C++ Database 244

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 Virtualization 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

The Netflix TechBlog

OCTOBER 14, 2024

the ipykernel process) of the jupyter-lab server process , which means the main event loop being injected by pystan is that of the ipykernel process, not the jupyter-server process. Blame The Network The next theory was that the network between the web browser UI (on the laptop) and the JupyterLab server was slow.

Latency 217

Latency Virtualization Traffic Processing 217

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

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

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

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

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 231

Lambda AWS Monitoring Serverless 231

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

Brendan Gregg

NOVEMBER 28, 2017

Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. This finally came to storage-optimized instance types in 2017 with the [i3 instance type], which used SR-IOV and the nvme storage driver. With a solution in hand for network performance, the next target was storage. ## 6. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 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 165

AWS Energy Automotive Traffic 165

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 189

Cloud Open Source Architecture Monitoring 189

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 Metrics Cache 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