SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

HammerDB

OCTOBER 23, 2023

With a simple example such as this, it would not necessarily be expected for the additional network traffic to be significant between the 2 approaches. However, with more complex application logic this network round trip soon becomes a key focus area for improving performance. On MySQL, we saw a 1.5X performance advantage.

Benchmarking 62

Benchmarking Database Network C++ 62

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

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

Percona

APRIL 17, 2023

It is common to see a value of “ 0″ ( or sometimes “10” ) on database servers, telling the kernel to prefer to swap to memory for better response times. 20-30% is a good general default for “dirty_ratio,” but on large-memory database servers, this can be a lot of memory.

Best Practices 52

Best Practices Design Tuning Database 52

HammerDB

APRIL 19, 2023

As database performance is heavily influenced by the performance of storage, network, memory, and processors, we must understand the upper limit of these key components. There are several ways to find out this information with the easiest way being by referring to the documentation. For storage, FIO is generally used. 4.22 %usr 38.40

Performance 54

Performance Benchmarking Cache Storage 54

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. When you have multiple copies of your data on different database servers — or even better, in different data centers worldwide — replication provides a high level of fault tolerance in case of a disaster.

Database 79

Database Servers Storage Strategy 79

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

Testsigma

FEBRUARY 3, 2021

Mobiles have different models, screen resolutions, operating systems, network types, hardware configurations, etc. Also, how to test the hardware of the mobile phone itself, is it supporting all the software as it should? Let us have a look at the most popular types of mobile testing for applications and hardware.

Mobile 82

Mobile Testing Hardware C++ 82

Smashing Magazine

JANUARY 11, 2021

Networking, HTTP/2, HTTP/3 OCSP stapling, EV/DV certificates, packaging, IPv6, QUIC, HTTP/3. You can download the spreadsheet as Google Sheets, Excel, OpenOffice document or CSV. In the end, it’s not the load events or server response times that define the experience, but the perception of how snappy the interface feels.

Performance 145

Performance Cache Media Metrics 145

CSS - Tricks

AUGUST 18, 2020

Even if you render components on the server and hydrate them on the client, it still churns because component hydration is computationally expensive. When even a bit of React can be a problem on devices slow and fast alike, using it is an intentional choice that effectively excludes people with low-end hardware. I think JSX is great.

Performance 101

Performance Mobile Servers Code 101

Smashing Magazine

APRIL 29, 2021

Lazy-load offscreen images (reduce network contention for key resources). For low impact to First Input Delay : Avoid images causing network contention with other critical resources like CSS and JS. This approach ensures that the browser can allocate the correct amount of space in the document while the image is loading.

Media 145

Media Network Metrics Mobile 145

Alex Russell

MARCH 6, 2021

Thanks to progress in networks and browsers (but not devices), a more generous global budget cap has emerged for sites constructed the "modern" way: ~100KiB of HTML/CSS/fonts and ~300-350KiB of JS (compressed) is the new rule-of-thumb limit for at least the next year or two. Modern network performance and availability.

Performance 124

Performance Network Cache Metrics 124

The Morning Paper

MARCH 3, 2020

Physalia is designed to offer consistency and high-availability, even under network partitions. In fact, each key needs to be available at only three points in the network: the AWS EC2 instance that is the client of the volume, the primary copy, and the replica copy. A Physalia installation, or colony , is made up of many cells.

Database 106

Database AWS Network Design 106

Smashing Magazine

JANUARY 6, 2020

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? It used to provide an insight into how quickly the server outputs any data. What does it mean? 300ms RTT, 1.6

Performance 145

Performance Cache Network Metrics 145

All Things Distributed

APRIL 5, 2012

From tax preparation to safe social networks, Amazon RDS brings new and innovative applications to the cloud. Intelligent Social network - Facilitate topical Q&A conversations among employees, customers and our most valued super contributors. Teachers can interact with their colleagues in professional learning networks.

Innovation 146

Innovation AWS Education Network 146

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 desktop machine (I won’t tell you the hardware details. There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use.

Servers 40

Servers Media Engineering Virtualization 40

Alex Russell

OCTOBER 22, 2017

We constrain ourselves to a real-world baseline device + network configuration to measure progress. Budgets are scaled to a benchmark network & device. This isn’t true (more on that in a follow-up post), and sites which are built this way implicitly require more script in each document (e.g., for router components).

Performance 68

Performance Benchmarking Network Mobile 68

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 103

Performance Cache Metrics Network 103

Brendan Gregg

SEPTEMBER 5, 2017

Linux has been adding tracing technologies over the years: kprobes (kernel dynamic tracing), uprobes (user-level dynamic tracing), tracepoints (static tracing), and perf_events (profiling and hardware counters). There's a lot about Linux containers that isn't well documented yet, especially since it's a moving target.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Testsigma

FEBRUARY 6, 2020

Documents like requirements documents, design documents, code are reviewed and review comments are provided at early stages of Software Lifecycle. Security Testing- Security of the application from the point of view of the network, data, system and the application is tested. Manual and Automation Testing.

Software 69

Software Software Testing Scalability 69

HammerDB

FEBRUARY 25, 2021

When we have multiple CPU cores on both the benchmark client and database server it is crucial that these database sessions run independently of each other at the same time, in parallel. The following is an example from TPROC-C from SQL Server. and the following from TPROC-H. select top 100. where p_partkey = ps_partkey. Glue language.

Programming 67

Programming Benchmarking Virtualization C++ 67

Dotcom-Montior

OCTOBER 12, 2017

EasyTravel demo application on AWS server. LoadView scripting tool Easystep on AWS server. Firewall on AWS server. AWS server security policy. Add inbound and outbound windows firewall rule on test server for port 8079. Link to my Easytravel demo application hosted on AWS server: [link]. Installation.

AWS 40

AWS Tuning Monitoring Servers 40

VoltDB

MAY 2, 2017

We recently received a question from a customer who was looking for a quick way to repurpose some VoltDB production servers to create a disaster recovery site. Say you have five VoltDB servers in production, with k-factor=2, and no disaster site. You want to shift some of these servers to create a disaster recovery site.

Hardware 40

Hardware Database Servers Tuning 40

Alex Russell

JUNE 20, 2020

full TCP/IP & UDP networking, including local network discovery. Java arrived with a focus on structured programming (including threads), GUI controls , networking, device access, and graphics. Absent compelling content and attentive security and performance focus, it soon retreated to the server. [6]. floppy/CD/DVD).

Hardware 55

Hardware Games Java Media 55

Dynatrace

AUGUST 5, 2019

While most of our cloud & platform partners have their own dependency analysis tooling, most of them focus on basic dependency detection based on network connection analysis between hosts. What is the network traffic going to be between services we migrate and those that have to stay in the current data center?

Cloud 31

Cloud Traffic Database Network 31

Dotcom-Montior

DECEMBER 8, 2021

Systems, web applications, servers, devices, etc., Software services still require physical devices and hardware for them to function. Like Slack, Microsoft is a real-time communication application that offers features like online messaging, video chat, and document sharing. It is an unavoidable fact. Asset Management.

Social Media 90

Social Media Monitoring Latency DevOps 90

High Scalability

NOVEMBER 25, 2019

To add elasticity, reliability and durability, these data centers are connected to Google Cloud platform using high speed, secure Google Interconnect network. Document store. Application Servers. Apache FTP server. Tens of petabytes of data stored in our servers and other object stores such as GCS, S3 and Azure Blobstore.

Architecture 52

Architecture Cache Azure Storage 52

Abhishek Tiwari

JULY 12, 2018

These nodes and edges require a good amount of compute and storage which is typically distributed across a large number servers either running in the cloud or your own data center. A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable.

Latency 63

Latency Analytics Scalability Engineering 63

O'Reilly

NOVEMBER 28, 2023

If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” A year after the first web servers became available, how many companies had websites or were experimenting with building them? Until AI reaches 100%, it’s still in the process of adoption.

Open Source 108

Open Source Artificial Intelligence Google Infrastructure 108

Smashing Magazine

AUGUST 22, 2021

As we will see, QUIC and HTTP/3 indeed have great web performance potential, but mainly for users on slow networks. If your average visitor is on a fast cabled or cellular network, they probably won’t benefit from the new protocols all that much. An often used metaphor is that of a pipe used to transport water. Congestion Control.

Performance 105

Performance Network Latency Servers 105

O'Reilly

OCTOBER 11, 2022

As a trend, it’s not performing well on Google; it shows little long-term growth, if any, and gets nowhere near as many searches as terms like “Observability” and “Generative Adversarial Networks.” We’ll see it in the processing of the thousands of documents businesses handle every day. We’ll see it in customer service.

Games 116

Games Healthcare Processing Retail 116