SQL Server According to Bob

JULY 17, 2018

When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 The parent process handles basic configuration activities and then forks the child process.

Servers 40

Servers Processing Software Engineering Traffic 40

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 110

Performance Latency Cache Virtualization 110

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

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

Brendan Gregg

NOVEMBER 28, 2017

AWS EC2 uses a different image type and boot process for PV and HVM, as described on the [Linux AMI Virtualization Types] page. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. Things started to become confusing here for two reasons. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40

Brendan Gregg

SEPTEMBER 5, 2017

There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). On Linux, containers are a combination of namespaces (restricting what a process sees) and cgroups (similar to Solaris resource controls). amazon").

Virtualization 76

Virtualization AWS Engineering Hardware 76

SQL Performance

AUGUST 14, 2019

The performance penalty is relevant only when the window function is optimized with row-mode processing operators. SQL Server 2019 introduces batch mode on rowstore support, so you can get batch-mode processing even if there's no columnstore indexes present on the data. Figure 1: Plan for Query 1, row-mode processing.

Best Practices 108

Best Practices Servers Database Azure 108

SQL Performance

JULY 24, 2022

SQL Server 2012 went out of all forms of official support about two weeks ago, on July 12 th. Best approaches for running totals – updated for SQL Server 2012. In the very first post on this site, I compared the performance of long-standing running totals methods with the new windowing functions added in SQL Server 2012.

Servers 66

Servers Strategy Availability Processing 66

The Symphonia

DECEMBER 6, 2017

We don’t recommend using this as a regular process for production use, but it might come in handy at development time. without web app servers?—?to Lambda is not a good solution for handling long-running stateful processes, and Step Functions is effectively in the same place it was a year ago. And again, this is a problem.

Serverless 40

Serverless Lambda AWS Traffic 40

SQL Server According to Bob

FEBRUARY 10, 2019

. · Failures occur from remote clients or sqlcmd executed directory on the server (/opt/mssql-tools/bin). SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. Server is a Superdome with lots of CPUs and RAM. Here is an example of a valid SQL Server login.

Servers 40

Servers Network Database Systems 40

SQL Performance

JULY 8, 2020

Unnesting/substitution of table expressions is a process of taking a query that involves nesting of table expressions, and as if substituting it with a query where the nested logic is eliminated. What actually happens is that the query parsing process produces an initial tree of logical operators closely reflecting the original query.

Servers 110

Servers Code Processing Performance 110

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

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

Dynatrace

JUNE 15, 2023

Cloud application security is a combination of policies, processes, and controls that aim to reduce the risk of exposing cloud-based applications to compromise or failure from external or internal threats. This process can delay deployments or cause developers to skip security testing completely to meet project deadlines.

Cloud 168

Cloud Open Source Architecture Monitoring 168

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 52

Performance Latency Cache Virtualization 52

The Netflix TechBlog

DECEMBER 14, 2020

The mystery begins Towards the end of 2017, I was on a conference call to discuss an issue with the Netflix application on a new set top box. They supplied a script to automate the process. The role of a Partner Engineer at Netflix is to help device manufacturers launch the Netflix application on their devices. aka “Lollipop”.

Engineering 352

Engineering Code Hardware Open Source 352

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

OCTOBER 14, 2020

In Part 4 of the series, which focused on optimization of derived tables, I described a process of unnesting/substitution of table expressions. The TL;DR version of substitution/unnesting of CTEs is that the process is the same as it is with derived tables. You can find the script that creates and populates PerformanceV5 here.

C++ 52

C++ Servers Code Efficiency 52

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

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. Network Connectivity: Establish a reliable network connection between the primary and replica servers.

Servers 52

Servers Database Availability Traffic 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Sharding in MongoDB is a technique used to distribute a database horizontally across multiple nodes or servers, known as “shards.” MongoDB distributes data across these shard servers to ensure an even distribution.

Best Practices 71

Best Practices Traffic Database Servers 71

Tim Kadlec

JUNE 21, 2022

HTTP/3 work started in 2012 with Google working on QUIC, adopted by IETF in 2017, RFC’s published in June 2022. No server push! The RSVP problem: HTTP/3 might be blocked on the network or may not be enabled on the server. So the browser will only try HTTP/3 if it’s certain the server supports it. What and Why?

Network 64

Network Mobile Google Cache 64

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. Advances in browser content processing. The Moto G4 , for example. Hard Reset.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. You can skip the WHERE clauses if you are running SQL Server 2017. Why the difference?

Performance 81

Performance C++ Storage Servers 81

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40

Servers Azure Engineering Java 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. Adaptive query processing in SQL databases – Bob Ward and Conor Cunningham.

Engineering 40

Engineering Azure Best Practices Servers 40

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. Data analytics: With the right extensions and configurations, PostgreSQL can support analytical processing and reporting. PostgreSQL hasn’t just been a concern to its competitors; it’s swooped past most of them.

Open Source 77

Open Source Healthcare Social Media Database 77

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. Treating these different processes as code will ensure that best practices are followed. Dynatrace news. with more being added continually.

Code 107

Code Infrastructure DevOps Serverless 107

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. In fact, PostgreSQL is so popular, 11.5% Oracle does offer discounts on their pricing, where you can receive a 10% discount if you purchase online.

Open Source 244

Open Source Tuning C++ 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. In theory, an existing code module or agent can be used to monitor a Lambda function if there’s a way to load it into the running Lambda process. What’s next.

Lambda 208

Lambda AWS Monitoring Serverless 208

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. looking out for MongoDB Inc.

Open Source 81

Open Source Programming Database Servers 81

Percona

JULY 7, 2023

In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers. When the primary server fails, a standby server takes over as the new primary.

Availability 83

Availability Open Source Architecture Database 83

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. were in the process of migrating to PostgreSQL and the last 14.1% using SQL Server, 17.3% are using public clouds. using MySQL, 10.0%

Database 185

Database Cloud Open Source Azure 185

SQL Server According to Bob

DECEMBER 10, 2018

SQL Server Books Online documents Instant File Initialization and the associated security considerations. SQL Server performs the following API calls when creating or extending (growing) data and log files. If the file is a log file (LDF) SQL Server always writes a known pattern (other than zeros) to the allocated space.

Servers 40

Servers Speed Database Software Engineering 40

Randon ASCII

FEBRUARY 16, 2021

Now, explorer.exe has many UI threads so it’s not like the entire process was hung, but one of its windows was definitely hung, it was causing hangs elsewhere, and this is bad. When my Python script started creating images the explorer.exe process would notice and immediately start trying to lay out icons. Symbol servers are good.

Monitoring 141

Monitoring Testing Code Servers 141

SQL Server According to Bob

FEBRUARY 13, 2020

​​​​ Another example would be backup to Azure Storage using the rest interface to read and ​​ write data to/from Azure Blob Storage. ​​​​ The flaw in the two-command approach was that you could issue the freeze and all the SQL Server workers got blocked waiting for a thaw.

Servers 40

Servers Availability Transportation Database 40