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

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. What are some key characteristics of securing cloud applications? These alerts tend to slow down development.

Cloud 168

Cloud Open Source Architecture Monitoring 168

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. Network Trace. Network Layer Overloaded.

Servers 40

Servers Network Database Systems 40

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. The TLS + QUIC layer makes UDP safer to use, but a lot of networks will likely still block for awhile. No server push! The RSVP problem: HTTP/3 might be blocked on the network or may not be enabled on the server.

Network 64

Network Mobile Google Cache 64

The Symphonia

DECEMBER 6, 2017

without web app servers?—?to to a massively distributed CDN network a possibility. Serverless at re:Invent 2017 was originally published in The Symphonium on Medium, where people are continuing the conversation by highlighting and responding to this story. Building real apps needs more than that. We’re the experts!

Serverless 40

Serverless Lambda AWS Traffic 40

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. Modern network performance and availability. The Moto G4 , for example. Hard Reset.

Performance 124

Performance Network Cache Metrics 124

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

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. On that note, it’s worth calling out that there are multiple flavors of network throttling. Real usage data would be better, of course.

Speed 82

Speed Monitoring Testing Network 82

Brendan Gregg

JULY 4, 2021

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on.

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

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.

Open Source 81

Open Source Programming Database Servers 81

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. The idea is to use secondary servers on your infrastructure for either reads or other administrative solutions. Network Connectivity: Establish a reliable network connection between the primary and replica servers.

Servers 52

Servers Database Availability Traffic 52

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

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

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. We went from managing five EC2 instances in 2011 to around 1,000 in 2017. Dynatrace news. with more being added continually.

Code 107

Code Infrastructure DevOps Serverless 107

KeyCDN

JANUARY 31, 2019

Today we’re excited to announce that we’ve launched yet another POP location to help further supercharge our network’s content delivery speeds. With Bucharest being the capital and largest city of Romania, it makes for a great edge server location. Our newest point of presence has been launched in Bucharest, Romania!

Internet 48

Internet Internet Ecommerce Speed 48

MachMetrics

JUNE 30, 2021

Daniel An, Google, 2017. According to Google SOASTA research, 2017 the probability of page bounce rate increases with increasing page loading time, because it greatly improves the user experience. Role of web servers in page load time –. So, do web server really makes a difference? I believe web server speed does matter.

Cache 78

Cache Speed Google Website 78

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 167

AWS Energy Automotive Traffic 167

Dotcom-Montior

JUNE 25, 2020

These certificates are then activated on the company’s website which ensures that a secure connection is always set up between the web browser and the web server. SSL certificates maintain the security of data between servers. Between June 2017 and 2018, the total number of SSL certificates increased by a record 13.2

Monitoring 77

Monitoring Website Internet Internet 77

The Morning Paper

JUNE 6, 2019

The bulk of the paper is about the practicalities of running these algorithms at scale across a large fleet of devices: managing device availability, coordinating activity over unreliable networks and devices, building and deploying training workflows, and troubleshooting when things go wrong. Federated Averaging. ” Secure Aggregation.

Systems 71

Systems Design Google Servers 71

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 In DevTools, the Network inspector helps us see what the first webpage is doing too.

Cache 92

Cache Social Media Media Website 92

KeyCDN

OCTOBER 24, 2018

Today we’re excited to announce that we’ve launched yet another POP location to help further supercharge our network’s content delivery speeds. With Helsinki being the capital and most populous municipality of Finland, it makes for a great edge server location. of the population were Internet users. What’s Next?

Internet 48

Internet Internet Speed Network 48

SQL Server According to Bob

FEBRUARY 13, 2020

​​ When the utility attempted to issue the thaw command the command would be queued, and the database could not return to an operational state until SQL Server was restarted. ​​ While the name can be any string it is commonly a Guid accommodating the ​​ uniqueness requirements.

Servers 40

Servers Availability Transportation Database 40

MachMetrics

FEBRUARY 7, 2019

Facebook took notice of the 3-second abandonment statistic and declared in August 2017 that information feed updates with slow-loading links will be shown reduced in the newsfeed: “With this update, we’ll soon take into account the estimated load time of a webpage that someone clicks to from any link in News Feed on the mobile app.

Speed 93

Speed Website Performance Website Mobile 93

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 104

Performance Cache Metrics Network 104

Abhishek Tiwari

DECEMBER 1, 2017

At re:Invent 2017, Amazon Web Services (AWS) announced Amazon Time Sync Service which provides a highly accurate and reliable global time reference. Although a Spanner database runs across multiple servers located across multiple datacenters, TrueTime makes it semantically indistinguishable from a single-server database.

AWS 55

AWS Google Database Virtualization 55

Rigor

MARCH 20, 2018

I recently was asked the following question by an online retailer: “Why should I invest in monitoring the user experience when I already have monitoring for our database, infrastructure, app server, and network?”. Instead of asking that question, I asked them this: “Are you a network or hosting provider?

Monitoring 40

Monitoring Retail Ecommerce Infrastructure 40

Smashing Magazine

JULY 29, 2019

Failing that, we are usually able to connect to home or public WiFi networks that are on fast broadband connections and have effectively unlimited data. The speed of mobile networks, too, varies considerably between countries. As for mobile network connection type, 84.7% Kyrgyzstan, Kazakhstan and Ukraine follow at $0.27, $0.49

Cache 97

Cache Google Mobile Network 97

Alex Russell

OCTOBER 22, 2017

We constrain ourselves to a real-world baseline device + network configuration to measure progress. — Alex Russell (@slightlylate) October 4, 2017. Budgets are scaled to a benchmark network & device. Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways.

Performance 68

Performance Benchmarking Network Mobile 68

Alex Russell

MARCH 31, 2022

De-duplication can prevent multiple copies on disk, but we're out of luck on reducing network costs. and SFTP -ing one's dependencies to the server are gone. Multiple factors contribute, including the pain of updates on slow networks and devices, systems that are out of disk space, and harmful interactions with AV software.

Cache 82

Cache Government Traffic Network 82

Enprowess

JANUARY 12, 2022

Twitter Lite PWA : It was integrated as the standard User Interface in 2017. IBM OpenWhisk, Microsoft Azure, AWS Lambda, and Google Cloud Functions are famous names that provide server-less services. It is a distributed and open ledger technology that gives secure online transactions removing all the middlemen in the network.

Blockchain 59

Blockchain IoT Development Serverless 59

The Morning Paper

JANUARY 19, 2020

STELLA: report from the SNAFU-catchers workshop on coping with complexity , Woods 2017, Coping with Complexity workshop. Today’s choice is a report from a 2017 workshop convened with that title, and recommended to me by John Allspaw – thank you John! Take a trivial example with three components A, B, and C.

C++ 50

C++ Systems Software Software 50

Rigor

SEPTEMBER 11, 2019

His keynote address from O’Reilly Fluent 2017, Reflecting on 20 years on the web , is a must-see. He served as the Editor-in-Chief of Smashing Magazine until October 2017 when he passed the baton to the remarkable Rachel Andrew. The future of HTTP/2 server push. MDN (Mozilla Developers Network) @MozDevNet.

Performance 89

Performance Education Google Website 89

Percona

JANUARY 14, 2019

Public API as -a-service has become a good business model: examples include social networks like Facebook/Twitter, messaging as a service like Twilio, and even credit card authorization platforms like Marqeta. To simulate text messages I have used ~3 billion of reddit comments (10 years from 2007 to 2017), downloaded from pushshift.io.

Database 40

Database Analytics Blockchain Healthcare 40

SQL Performance

SEPTEMBER 2, 2021

SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT().

C++ 59

C++ Servers Testing Database 59

KeyCDN

NOVEMBER 8, 2018

Varonis) In 2017 there was a 13 percent overall increase in reported system vulnerabilities. This allows you to restrict the access to your account by IP (/32) or network (e.g. /24). Moreover, here are a few alarming security facts over the past couple of years: 21 percent of all files are not protected in any way.

Transportation 47

Transportation Website Google Infrastructure 47

Brendan Gregg

AUGUST 8, 2017

Thankfully, I found some older linux-devel mailing list archives, rescued from server backups, often stored as tarballs of digests. 90491 N|rnberg (Germany) Consulting+Networking+Programming+etc'ing 42. It's time in some cgroup paths, but this server is not doing much disk I/O. Network I/O? to the load average.

Latency 111

Latency Metrics C++ Systems 111