Scalegrid

MAY 13, 2020

It can scale towards a multi-petabyte level data workload without a single issue, and it allows access to a cluster of powerful servers that will work together within a single SQL interface where you can view all of the data. High performance, query optimization, open source and polymorphic data storage are the major Greenplum advantages.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

SQL Shack

AUGUST 17, 2020

In this article, we will discuss how to resolve I/O problems that is a very important point for the SQL Server troubleshooting. The storage subsystem is one of the significant performance factors for the databases. Detecting and identifying I/O problems in SQL Server can be a tough task for the database administrators (DBAs).

Servers 82

Servers Storage Database Performance 82

Scalegrid

MARCH 8, 2024

This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity. This isn’t merely about taking a full backup or enabling binary logging.

Database 162

Database Strategy Servers Best Practices 162

SQL Performance

JULY 19, 2022

Each log record has a fixed overhead so, sometimes, the Storage Engine breaks this rule by combining multiple changes into a single log record to reduce the total number of log records written to the log. There are between 70 and 100 log record types, depending on the version of SQL Server (there’s no documented list).

Servers 94

Servers Database Storage Engineering 94

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 This article will explain how to set up MySQL 8 as a replica from an existing MySQL 5.7 server with Percona XtraBackup. installed REPLICA: mysql8 (192.168.56.113) with Percona Server 8 and xtrabackup 8.0

Servers 103

Servers C++ Storage Systems 103

DZone

JULY 19, 2023

This article discusses the profound influence these elements have on IT operations within the utility and energy sector, providing a robust and adaptive infrastructure for the future. Before moving on to the main article, here is a pertinent case study that helps demonstrate the importance of such digital transformation.

Virtualization 130

Virtualization Scalability Energy Cloud 130

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario.

Azure 72

Azure Virtualization Servers Storage 72

Scalegrid

JANUARY 12, 2024

This article analyzes cloud workloads, delving into their forms, functions, and how they influence the cost and efficiency of your cloud infrastructure. These include popular technologies such as web servers and web applications, along with advanced solutions like distributed data stores and containerized microservices.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Percona

MARCH 13, 2023

In this article, we’ll explore the benefits of using Docker images for experimenting with serverless PostgreSQL and show you how to get started with them. Basically, you can view this as a PostgreSQL instance but without a storage layer Storage Broker Storage Broker is a coordination component between WAL Service and Pageserver.

Serverless 118

Serverless C++ Storage Latency 118

SQL Shack

DECEMBER 5, 2019

This article discusses the Forwarded Records and its performance issues for heap tables in SQL Server. Heap introduction and performance issues A page of 8KB is the smallest unit of storage in SQL Server. In each page of SQL Server, we have a 96-bytes header to store the system information.

Servers 53

Servers Performance Storage Systems 53

SQL Performance

SEPTEMBER 16, 2021

To finish up my short series of articles on latches, this time I’m going to discuss a few other latches in SQL Server you might see occasionally but don’t merit a complete article by themselves. The post SQL Server Latches – Other Latches To Know About appeared first on SQLPerformance.com. The LOG_MANAGER Latch.

Servers 57

Servers Storage Efficiency Database 57

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. “. 4 Socket, TPCC.

Servers 90

Servers Media Cache Storage 90

SQL Shack

SEPTEMBER 9, 2019

In this article, we will study in detail about the how SQL Server Index Fill factor works. Index Fill factor SQL Server Index Fill Factor is a percentage value to be filled data page with data in SQL Server. This option is available in index properties to manage data storage in the data pages. It […].

Benchmarking 56

Benchmarking Servers Performance Storage 56

SQL Performance

OCTOBER 7, 2020

For more background on these performance spools see my prior article. With those out of the way, this article is exclusively about Sorts and when they can rewind. Sorts use storage (memory and perhaps disk if they spill) so they do have a facility capable of storing rows between loop iterations. Row Count Spool. Remote Query.

Servers 106

Servers Cache Azure Performance 106

Percona

SEPTEMBER 12, 2023

this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. In this article, we will look into this enhancement, compare MySQL 5.7 This counter value is stored in memory and is not persistent across server restarts.

Servers 110

Servers Storage Database Open Source 110

Scalegrid

DECEMBER 6, 2023

In the digital age, data management has transformed from locally hosted servers to cloud solutions. All the tedious tasks such as storage, backups, and configuration are managed by an attentive crew so that you can concentrate on making your vacation special. Make sure to read our extensive article on DBaaS Pros and Cons !

Database 130

Database Cloud Hardware Storage 130

Scalegrid

APRIL 28, 2020

In this article, we are going to compare three of the most popular cloud providers, AWS vs. Azure vs. DigitalOcean for their database hosting costs for MongoDB® database to help you decide which cloud is best for your business. See performance tests to determine the impact of the Meltdown CPU kernel patch on your MongoDB servers.

Azure 344

Azure AWS Database Latency 344

Dynatrace

JULY 11, 2023

When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database. The problem with the IIS server access logs was the headers. This article was developed in conjunction with Robin Wyss. Just ask your Dynatrace account rep.

Database 153

Database Government Games Servers 153

Dynatrace

DECEMBER 16, 2021

Since December 10, days after a critical vulnerability known as Log4Shell was discovered in servers supporting the game Minecraft, millions of exploit attempts have been made of the Log4j 2 Java library, according to one team tracking the impact, with potential threat to millions more applications and devices across the globe.

Internet 258

Internet Internet Games Java 258

Percona

DECEMBER 28, 2022

In this article, I will explain why it is advisable to avoid long-running transactions on Aurora readers when executing frequent DDL operations on the Writer, or at least be aware of how a DDL can impact your Aurora readers. Aurora replicas connect to the same storage volume as the primary DB instance and support only read operations.

Storage 93

Storage Servers AWS Database 93

Scalegrid

JANUARY 8, 2024

Discover key insights and strategic advice in our article, designed to steer you toward the best cloud solution that fits your company’s priorities. This article will focus on the technology behind ScaleGrid’s Database-as-a-Service (DBaaS) solutions and how they align with multi-cloud and hybrid cloud structures.

Strategy 147

Strategy Cloud Scalability Artificial Intelligence 147

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 159

Virtualization Infrastructure Monitoring Cloud 159

Scalegrid

JANUARY 9, 2024

This article delivers direct insights on solid security frameworks, agile defensive tactics, and compliance adherence, providing the blueprint to reinforce your enterprise against the rigors of the cloud. What does strong enterprise cloud security entail, and how can you achieve it?

Strategy 130

Strategy Cloud Best Practices Government 130

Dynatrace

DECEMBER 16, 2020

This article explains what a software supply chain attack is, and how Dynatrace protects its customers against such attacks by applying: Risk management and business continuity planning. Every storage location involving data at rest is encrypted as well. Dynatrace news. Security controls in the software development life cycle (SDL).

Software 226

Software Software Development AWS 226

SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Improvements in SQL Server 2016. The subject of this post is the additional changes that are enabled for metadata-only from SQL Server 2016 onward.

Servers 63

Servers Database Testing Efficiency 63

Scalegrid

JANUARY 19, 2024

This article dives straight into what triggers a rollback in MongoDB, the risks it carries, and concrete steps you can take to both prevent and recover from one. Data-bearing members face a higher risk of encountering issues caused by rollbacks, compared to others who utilize different storage methods.

Database 130

Database Network Servers Monitoring 130

The Polyglot Developer

JULY 25, 2016

I’ve written a few articles about how I’m using my many Raspberry Pi units. Recently I wrote about using a Raspberry Pi as an automatic network backup server , but I didn’t talk about expanding the storage beyond the micro or standard sized SD card. What if you want to utilize a much larger USB hard drive or thumb drive?

Storage 40

Storage Network Servers Development 40

CSS Wizardry

MARCH 3, 2019

This includes CDNs, proxy servers, and the like. Once the 60 seconds is up, the browser will head back to the server to revalidate the file. It means ‘do no t serve a copy from cache until you’ve revalidated it with the server and the server said you can use the cached copy’. public and private. Cache-Control: no-cache.

Cache 264

Cache Latency Strategy Servers 264

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. Or even on a plane.

Performance 110

Performance Latency Cache Virtualization 110

CSS - Tricks

DECEMBER 23, 2020

In this article, we’ll go over how to set up Lighthouse CI and run it locally, then how to get it working as part of a CI workflow through GitHub Actions. Here’s the simplest configuration that will run and collect Lighthouse reports for a static website project, and upload them to temporary public storage. // lighthouserc.js

Performance 78

Performance Storage Servers Virtualization 78

CSS - Tricks

SEPTEMBER 21, 2020

There are two images sitting on a server, a large one and a small one. Rather than a file (like an image) needing to travel across the world, it comes from a server much geographically closer on a server designed for that job. Imagine images. Imagine the performance implications of that. The large one. Fair enough.

Website 97

Website Energy Storage Efficiency 97

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. This article is about batch mode bitmaps, which have a very different implementation. Background. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

Smashing Magazine

NOVEMBER 8, 2018

Sharing Data Among Multiple Servers Through AWS S3. Sharing Data Among Multiple Servers Through AWS S3. After the file is uploaded to a server on step 1, the file must be available to whichever server handles the request for steps 2 and 3, which may or may not be the same one for step 1. Leonardo Losoviz.

AWS 44

AWS Servers Storage Cloud 44

Smashing Magazine

SEPTEMBER 28, 2022

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. Client Side Rendering, Server Side Rendering And Jamstack. To run it, you have to make another API call to the server and retrieve any data you want to load. Jump to online workshops ?.

Cache 125

Cache Performance Servers Social Media 125

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

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Percona

OCTOBER 17, 2023

From that, this article is born. Dynamic WiredTiger tickets As a brief recap, WiredTiger tickets in MongoDB serve as the concurrency control mechanism within the WiredTiger storage engine. Our goal here is to review five new changes or implementations you should know in MongoDB 7.0. Without further ado, let’s get started.

Metrics 101

Metrics C++ Storage Database 101