SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

SQL Performance

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. This article explores the batch data normalized representation, explains why not all eight-byte data types can fit within 64 bits, and shows an example of how all this affects batch-mode performance. Why the difference?

Performance 81

Performance C++ Storage Servers 81

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

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

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.

IoT 61

IoT Servers Development Cache 61

SQL Performance

AUGUST 14, 2019

GetNums ( 1 , @rows_per_partition ) AS RPP ; Our pitfall has both a logical side to it with a potential logical bug as well as a performance side with a performance penalty. The performance penalty is relevant only when the window function is optimized with row-mode processing operators. Now for the catch.

Best Practices 108

Best Practices Servers Database Azure 108

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

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

Virtualization 76

Virtualization AWS Engineering Hardware 76

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

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

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.

Servers 75

Servers Engineering Efficiency Retail 75

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 174

Cloud Open Source Architecture Monitoring 174

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

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. In Ninja, this job is performed by an Android Thread. aka “Lollipop”.

Engineering 352

Engineering Code Hardware Open Source 352

The Symphonia

DECEMBER 6, 2017

Correspondingly, 3GB functions should see a 2x CPU performance improvement over 1.5GB Lambdas, but this is through doubling the number of cores the function has access to, rather than double the virtualized time-slices. We don’t recommend using this as a regular process for production use, but it might come in handy at development time.

Serverless 40

Serverless Lambda AWS Traffic 40

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance. MongoDB distributes data across these shard servers to ensure an even distribution.

Best Practices 73

Best Practices Traffic Database Servers 73

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. Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

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

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

Rigor

SEPTEMBER 11, 2019

Reading time 16 min Whether you’re a web performance expert, an evangelist for the culture of performance, a web engineer incorporating performance into your process, or someone new to the web performance entirely, you probably identify as curious, excited about new ideas, and always learning. Rick Byers.

Performance 89

Performance Education Google Website 89

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. It’s reliable, robust, feature-rich, and performant.

Open Source 80

Open Source Healthcare Social Media Database 80

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. We’re talking about a few hundred milliseconds, but this can have a considerable performance impact when cold starts occur too often. Dynatrace has offered a Lambda code module for Node.js

Lambda 215

Lambda AWS Monitoring Serverless 215

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

Smashing Magazine

JANUARY 7, 2019

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Web performance is a tricky beast, isn’t it? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? Vitaly Friedman.

Performance 103

Performance Cache Metrics Network 103

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

JULY 7, 2023

It enables businesses and organizations to meet uptime and service level objectives, protect business-critical data, and maintain performant databases. Failover: This functionality is all about switching — in both unplanned and planned situations — from a failed primary server to a standby server.

Availability 85

Availability Open Source Architecture Database 85

Randon ASCII

FEBRUARY 16, 2021

I don’t generally do random analysis of strangers’ performance problems but the case sounded interesting so I thought I’d take a look. Freya shared an ETW trace of what was happening on her machine and I took a look using Windows Performance Analyzer (WPA). Then when I resumed the process it would do all of the work.

Monitoring 141

Monitoring Testing Code Servers 141

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 108

Code Infrastructure DevOps Serverless 108

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% Performance followed in fourth with 10.9%

Database 185

Database Cloud Open Source Azure 185

Smashing Magazine

AUGUST 10, 2023

The tooling to get a report with details from the time it takes to establish a server connection to the time it takes for the full page to render is out there. Large preview ) I don’t know about you, but it often feels like I’m missing something when measuring page speed performance. The key word here is “monitoring” performance.

Speed 81

Speed Monitoring Testing Network 81

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. The Sort only has 19 rows to process, so it consumes only 1ms or so.

Servers 86

Servers Tuning Database Efficiency 86

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 ). DtcGetTransactionManager contacts the host, performing a remote registry access to determine the connection and proxy information. Once the connection to SQL Server is established the APP executes the odbc!

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. Pedro makes it his mission to help customers with SQL Server Performance.

Engineering 40

Engineering Azure Best Practices Servers 40

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. There are a wide range of tools and extensions for every conceivable scenario, like performance profiling, auditing, etc. Oracle Ease of Use.

Open Source 244

Open Source Tuning C++ Database 244

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. This is a just a presentation decision—the Concat and joins are still present in the code run by the SQL Server execution engine.

Servers 98

Servers Design Database Code 98