Brendan Gregg

NOVEMBER 28, 2017

Virtualized in Software**: While this can support an unmodified guest OS, many operations are emulated and slow. It's using software and coordination between the hypervisor and guest to improve performance. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40

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

Dynatrace

JUNE 15, 2023

Incorporating cloud application security practices is an effective way for organizations to avoid application security risks, ensure a smoothly running software development lifecycle (SDLC), and establish an overall strong security posture. However, open source software is often a vector for security vulnerabilities.

Cloud 168

Cloud Open Source Architecture Monitoring 168

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

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

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

Brendan Gregg

SEPTEMBER 5, 2017

They use third-party software like Docker or Kubernetes to simplify their administration. There are workarounds: I can use the perf_events cgroup ID, provided the container software is configuring it (they do). Oracle VM Server is based on Xen. There have been security vulnerabilities, just like there are with any software.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. Many open source proponents, including the Open Source Initiative (OSI) , do not consider software under the SSPL to be open source. We agree with the OSI’s determination that any software under the SSPL cannot be open source.

Open Source 81

Open Source Programming Database Servers 81

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

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

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 ). MariaDB Server, on the other hand, is a fork of MySQL 5.5.

Open Source 52

Open Source Servers Storage Scalability 52

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.

Performance 52

Performance Latency Hardware Storage 52

SQL Server According to Bob

FEBRUARY 22, 2018

Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not function as expected. SQL Server’s NewSequentialId () calls the Windows API UuidCreateSequential , which is limited in SQLPAL, prior to the CU 4 update. Server B may be generating uuids that sort before those from Server A.

Servers 40

Servers Software Engineering Database Network 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. Software Update License & Support (annual). $0. In fact, PostgreSQL is so popular, 11.5% Advanced Security. $0. Not available. Not available.

Open Source 244

Open Source Tuning C++ Database 244

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Despite all its upside, PostgreSQL software presents such challenges. PostgreSQL software supports synchronous streaming replication, asynchronous streaming replication, and logical replication.

Availability 82

Availability Open Source Architecture Database 82

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. What is PostgreSQL used for? It’s used for data management (shocker), application development, and data analytics. Is PostgreSQL enterprise-ready?

Open Source 77

Open Source Healthcare Social Media Database 77

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

Servers 40

Servers Processing Software Engineering Traffic 40

SQL Server According to Bob

DECEMBER 18, 2018

The SQL Server Host Extension provides file level integrity. Bob Dorr – Principal Software Engineer SQL Server. Bob Dorr – Principal Software Engineer SQL Server. For that an explicit fsync on a file descriptor for the directory is also needed.”.

Servers 40

Servers Software Engineering Engineering Software 40

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

DECEMBER 18, 2018

I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article. SQL Server does NOT do this, in fact I made sure SQL Server on Linux does not allow this to occur. This issue does NOT impact SQL Server database, log and backup files.

Servers 40

Servers Media Cache Software Engineering 40

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 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. 0 to Hero: Troubleshooting SQL Server Performance Made Easy – Pedro Lopes.

Engineering 40

Engineering Azure Best Practices Servers 40

All Things Distributed

NOVEMBER 13, 2018

Since then, AWS has added another PoP in Palermo in 2017. This includes: Enterprises such as Decysion, Docebo, Eataly, Edizioni Conde Nast, ENEL, Ferrero, GEDI Gruppo Editoriale, Imperia & Monferrina, Lamborghini, Mediaset, Navionics, Pirelli, Pixartprinting, SEAT Pagine Gialle, Tagetik Software, and Vodafone Italy.

AWS 167

AWS Energy Automotive Traffic 167

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Software-based clocksources could fix those issues and provide accurate monotonically-increasing time.

Speed 126

Speed Java AWS Virtualization 126

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

SQL Server According to Bob

JULY 31, 2018

Update Oct 2018 – SQL Server 2019 CTP 2.0. SQL Server 2019 changes the DELTE On CLOSE behavior used on Linux installations. Bob Dorr – Principal Software Engineer SQL Server. The downside of using unlink or remove, and keeping the file descriptor open, is that the file becomes hidden. Restart the VM.

Servers 40

Servers Software Engineering Systems Monitoring 40

Randon ASCII

FEBRUARY 16, 2021

So, 20 seconds arranging icons didn’t seem plausible and I assumed that the root cause would be some weird shell extension or other third-party software, but eventually I tried to reproduce the bug in the simplest way possible. Symbol servers are good. If you are on Windows then make sure you are using symbol servers.

Monitoring 141

Monitoring Testing Code Servers 141

SQL Server According to Bob

JANUARY 29, 2017

FEB 1, 2017 UPDATE – CHANGE ACCEPTED. Bob Dorr – Principal Software Engineer SQL Server. This is really a neat experience and I can truly see our use of LLDB driving more advancements for everyone. This revision was automatically updated to reflect the committed changes. Changed prior to commit: [link] Repository: [link].

Servers 40

Servers Programming Media Open Source 40

MachMetrics

DECEMBER 14, 2019

How fast is the average time to first byte (server delay)? In 2017, mobile internet usage passed desktop as the majority. Obviously, the key phrase there is ‘fully loaded’ A lot of that time is behind the scenes scripts, tracking software, advertisements, etc. How long is the average server delay?

Best Practices 105

Best Practices Speed Mobile Google 105

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

Particular Software

MARCH 15, 2021

For NServiceBus systems, our SQL Persistence package allows you to use whatever flavor of SQL works best for you, supporting dialects for Microsoft SQL Server, MySQL, PostgreSQL, and Oracle. SQL Server Always Encrypted SQL Persistence 6.1 The other was added in October 2017 and is compatible with PostgreSQL. SQL Persistence 6.1

Transportation 52

Transportation Azure Database Servers 52

The Morning Paper

JANUARY 19, 2020

STELLA: report from the SNAFU-catchers workshop on coping with complexity , Woods 2017, Coping with Complexity workshop. “Coping with complexity” is about as good a three-word summary of the systems and software challenges facing us over the next decade as I can imagine. A digression on complexity budgets.

C++ 50

C++ Systems Software Software 50

Rigor

SEPTEMBER 11, 2019

Rick is a software engineer on the Google Chrome team, “leading an effort to make the web just work for developers.” His keynote address from O’Reilly Fluent 2017, Reflecting on 20 years on the web , is a must-see. The future of HTTP/2 server push. Rick Byers. Rick Byers. You can follow Max on Twitter @ firt.

Performance 89

Performance Education Google Website 89

CSS - Tricks

APRIL 1, 2021

A 2017 study by Akamai says as much when it found that even a 100ms delay in page load can decrease conversions by 7% and lose 1% of their sales for every 100ms it takes for their site to load which, at the time of the study, was equivalent to $1.6 But those are things I did in image editing software. Are things better?

Cache 92

Cache Social Media Media Website 92

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Software-based clocksources could fix those issues and provide accurate monotonically-increasing time.

Speed 40

Speed Java AWS Virtualization 40

Particular Software

AUGUST 8, 2017

Better for you The headline feature of SQL Persistence is its support for multiple engines, which currently includes Microsoft SQL Server, Oracle, and MySQL. Update Dec 5, 2017: SQL Persistence now also supports PostgreSQL too.) There, you can view all the DDL and DML scripts for Microsoft SQL Server , Oracle , and MySQL.

DevOps 40

DevOps Database Education Engineering 40

Enprowess

JANUARY 12, 2022

Twitter Lite PWA : It was integrated as the standard User Interface in 2017. Technology helps companies offer their software services to customers quickly, creating personalized experiences. IBM OpenWhisk, Microsoft Azure, AWS Lambda, and Google Cloud Functions are famous names that provide server-less services. Image Source.

Blockchain 59

Blockchain IoT Development Serverless 59