article thumbnail

Site reliability done right: 5 SRE best practices that deliver on business objectives

Dynatrace

This shift is leading more organizations to hire site reliability engineers to guarantee the reliability and resiliency of their services. How site reliability engineering affects organizations’ bottom line SRE applies the disciplines of software engineering to infrastructure management, both on-premises and in the cloud.

article thumbnail

SQL Server on Linux: Why Do I Have Two SQL Server Processes

SQL Server According to Bob

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 Bob Dorr – Principle SQL Server Software Engineer.

Servers 40
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

How It Works: BULK INSERT (BCP) TDS Traffic

SQL Server According to Bob

The BCP.exe client honors the batch size and each batch submits the internal command ‘INSERT BULK’, which you can see in a trace of your SQL Server and shows up as BULK INSERT in the CMD column of dm_exec_requests. BCP.exe submits commands over the TDS (Tabular Data Stream) connection to the SQL Server. Disconnect.

Traffic 40
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

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. “. The Back Story.

Servers 90
article thumbnail

SQL Mysteries: Why is my SQL Server experiencing lots of 17830 (TCP 10054) errors?

SQL Server According to Bob

Unfortunately, the timings were always small and not something the SQL Server engine was doing, instead the client was closing the connection. In fact, I was able to break the reproduction down to a single connection using an idle SQL Server so there was no impact from other workloads. Powershell Script.

Servers 40
article thumbnail

Sponsored Post: Etleap, PerfOps, InMemory.Net, Triplebyte, Stream, Scalyr

High Scalability

Triplebyte lets exceptional software engineers skip screening steps at hundreds of top tech companies like Apple, Dropbox, Mixpanel, and Instacart. For heads of IT/Engineering responsible for building an analytics infrastructure , Etleap is an ETL solution for creating perfect data pipelines from day one. Who's Hiring?

Java 116
article thumbnail

O’Reilly serverless survey 2019: Concerns, what works, and what to expect

O'Reilly

More than a fifth of the respondents work in the software industry—skewing results toward the concerns of software companies, and helping explain the preponderance of those with software engineering roles. This scaling takes away the worry from random and unexpected traffic spikes or big seasonal traffic.