Dynatrace

JANUARY 15, 2020

Having released this functionality in an Preview Release back in September 2019, we’re now happy to announce the General Availability of our Citrix monitoring extension. Citrix is a sophisticated, efficient, and highly scalable application delivery platform that is itself comprised of anywhere from hundreds to thousands of servers.

Latency 37

Latency Performance Virtualization Infrastructure 37

SQL Performance

OCTOBER 7, 2020

Sorts use storage (memory and perhaps disk if they spill) so they do have a facility capable of storing rows between loop iterations. The Sort operator’s rewind behaviour may seem strange, but it has been this way from (at least) SQL Server 2000 to SQL Server 2019 inclusive (as well as Azure SQL Database). Sort Rewinds.

Servers 106

Servers Cache Azure Performance 106

O'Reilly

NOVEMBER 12, 2019

Rather than buying racks and racks of servers that need to handle the maximum potential traffic and be idle most of the time, it seems that serverless’ method of paying by compute is proving to be beneficial to the bottom lines of organizations. The third stand-out issue was “no server maintenance.” 1 reported benefit.

Serverless 88

Serverless Architecture FinTech Infrastructure 88

High Scalability

DECEMBER 21, 2018

swardley: X : What's going to happen in cloud in 2019? ” And in most main­stream ap­pli­ca­tion­s, you should be able to get there with server­less. And if you know someone with hearing problems they might find Live CC useful. 202,157 flights tracked! Me : Nothing special. If you plan for it.

Internet 137

Internet Internet Scalability Serverless 137

Scalegrid

NOVEMBER 29, 2023

Data Center Dynamics highlights a significant uptick in DBaaS adoption, growing from 40% to 45% between 2019 and 2020. This blog post will explore some of the major challenges in database management that businesses can expect, especially when transitioning from traditional database servers. Your data will always be intact.

Healthcare 130

Healthcare Hardware Database Scalability 130

Dynatrace

JULY 8, 2020

Event objects are not typical log events ; they are produced by the API Server and not included in the logs produced by the cluster. 2019 CNCF Survey , complexity (38%) and monitoring (32%) are ranking among the top 5 challenges in using, deploying, and managing containers. .

Infrastructure 206

Infrastructure Monitoring Cloud Metrics 206

SQL Performance

MARCH 17, 2020

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. It would be nice if SQL Server could push the aggregation down into the scan and just return distinct values from the column store directly.

Servers 86

Servers Tuning Database Efficiency 86

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

Percona Community

MAY 4, 2020

Wed) Level: Intermediate Abstract MariaDB Server 10.4 has been out for some time now (June 2019) and it has many new features, some of which MySQL does not have. Feature-wise, it is important to know what MariaDB Server 10.4 (Wed) • New Delhi 8:30 a.m.

Servers 52

Servers Storage Engineering Systems 52

The Morning Paper

NOVEMBER 8, 2020

replacing Paxos with Raft), or they could be shims over external storage systems. A minimal Loglet needs to provide totally ordered, durable storage via the shared log API. In Facebook’s implementation of NativeLoglet, seal simply sets a bit on a quorum of servers. Reconfiguration.

Virtualization 126

Virtualization Latency Storage Systems 126

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 103

Performance Latency Cache Virtualization 103

SQL Performance

FEBRUARY 3, 2020

The downside to the latter is that, in SQL Server 2017, you cannot run this online… but you will be able to in 2019. ( DROP_EXISTING = ON , DATA_COMPRESSION = COLUMNSTORE_ARCHIVE ON PARTITIONS ( 1 TO 7 ) , DATA_COMPRESSION = COLUMNSTORE ON PARTITIONS ( 8 ) -- in 2019, CCI can be ONLINE = ON as well. )

Speed 113

Speed Processing Servers Storage 113

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

The Morning Paper

OCTOBER 4, 2020

The study is based on one of the world’s first commercial 5G network deployments (launched in April 2019), a 0.5 Three different 5G phones are used, including a ZTE Axon10 Pro with powerful communication (SDX 50 5G modem) and compute (Qualcomm Snapdragon TM855) capabilities together with 256GB of storage. km university campus.

Energy 130

Energy Latency Performance Network 130

Smashing Magazine

AUGUST 23, 2019

2019-08-23T13:30:59+02:00. 2019-08-23T13:06:42+00:00. The idea presented here is now to load only so many bytes of a progressive JPEG from the server that you can quickly get an impression of the image content. With Ajax, however, this is possible, provided that the server delivering the image supports HTTP Range Requests.

Network 104

Network Servers Programming Code 104

The Morning Paper

JANUARY 26, 2020

This week we’ll be looking at a selection of papers from the 2019 edition of the ACM Symposium of Cloud Computing ( SoCC ). Second, Reverb enables speculative bug fix analysis … Third, Reverb supports wide-area debugging for applications whose server-side components use event-driven architectures. The problem.

Programming 86

Programming Servers Network Latency 86

SQL Performance

NOVEMBER 13, 2019

Never mind the likelihood for this to happen in practice in SQL Server; if I run the query again, theoretically, the row with id 2 could be assigned with row number 3 and the row with id 11 could be assigned with row number 2. So apparently the window order clause is mandatory for the ROW_NUMBER function in SQL Server.

Servers 104

Servers C++ Storage Performance 104

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 88

Availability Open Source Architecture Database 88

Smashing Magazine

NOVEMBER 8, 2018

Sharing Data Among Multiple Servers Through AWS S3. Sharing Data Among Multiple Servers Through AWS S3. 2019-04-29T18:34:58+00:00. 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.

AWS 45

AWS Servers Storage Cloud 45

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. The SQL Server lock manager keeps track of the number of locks held by the current transaction. Testing environment. This seems like an oversight.

Database 98

Database Testing Storage Servers 98

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. PostgreSQL has powerful and advanced features, including asynchronous replication, full-text searches of the database, and native support for JSON-style storage, key-value storage, and XML.

Open Source 83

Open Source Healthcare Social Media Database 83

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

Smashing Magazine

JANUARY 15, 2019

2019-01-15T13:30:32+01:00. 2019-04-29T18:34:58+00:00. So, apart from powering servers with renewable energy, what else can web developers do about climate change? This includes the work done by the server, the client and the intermediary communications networks that transmit data between the two. Jack Lenox.

Website Performance 74

Website Performance Website Energy Performance 74

SQL Performance

APRIL 27, 2020

Many of the newer features we have in SQL Server were initially launched in Azure SQL Database, including (but not limited to) Always Encrypted, Dynamic Data Masking, Row Level Security, and Query Store. The basic tier provides up to 5 DTUs with standard storage. vCore Pricing Tier. GB per vCore. HyperScale Database.

Azure 55

Azure Database Serverless Hardware 55

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. The worldwide ASP 18 months ago was ~$300USD , so the average performance in the deployed fleet can be represented by a $300 device from mid-2019. So what did $150USD fetch in 2019?

Performance 127

Performance Network Metrics Cache 127

Percona

JULY 15, 2023

Let’s test the following equivalent query: mysql> SELECT AVG(price) FROM products WHERE create_time BETWEEN '2019-10-01' AND '2019-11-01'; + + | AVG(price) | + + | 202.982582 | + + mysql> EXPLAIN SELECT AVG(price) FROM products WHERE create_time BETWEEN '2019-10-01' AND '2019-11-01'G 1.

Virtualization 80

Virtualization Speed Database Efficiency 80

Percona

JULY 3, 2023

However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. The exact point at which a table will benefit from partitioning depends on the application.

Storage 87

Storage Database Performance Open Source 87

Percona

DECEMBER 20, 2018

We look forward to providing you with even better articles, news and information in 2019. As 2018 moves into 2019, let’s take a quick look back at some of the most popular posts on the blog this year. So I started a couple of instances to test Percona Server for MySQL under this CPU. Fsync Performance on Storage Devices.

Database 41

Database Tuning Performance AWS 41

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Since then, Microsoft has changed the naming of this series to Lsv2.

Azure 42

Azure Virtualization Storage Benchmarking 42

CSS - Tricks

JULY 18, 2019

That could potentially save a ton of server requests and precious bytes when waiting for a page to load. No more wondering how much storage is left on your server! Hey it doesn't hurt there is a 20% discount right now with DISCOUNT20 until July 31st, 2019. You get an unlimited amount of space to store anything you need.

Performance 41

Performance Storage Speed Servers 41

SQL Performance

NOVEMBER 30, 2021

SQL Server has a cost-based optimizer that uses knowledge about the various tables involved in a query to produce what it decides is the most optimal plan in the time available to it during compilation. Whether the page is dirty or not (a dirty page has changes on it that haven’t yet been written back to durable storage). ) ; GO.

Efficiency 54

Efficiency Servers Database Cache 54

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

AUGUST 27, 2021

When you enable one of the two forms of versioning, SQL Server uses a mechanism called versioning to preserve pre-change versions of a record in the version store in tempdb. This special-purpose storage is made up of append-only allocation units and is only used for version store operations.

Database 56

Database Storage Availability Servers 56

Smashing Magazine

MARCH 28, 2019

2019-03-28T10:30:39+01:00. 2019-04-29T18:34:58+00:00. Because server technology is rarely understood by the people who own websites, it’s easy for them to mistakenly think they can save money there. You build an amazing website that aims to do exactly what your client wanted, but the server technology is holding it back.

Website 48

Website Servers Design Virtualization 48

HammerDB

JUNE 27, 2022

Given the increasing importance of open source and the widespread use of HammerDB, the TPC adopted HammerDB in 2019 and now hosts the project on GitHub. As a result, HammerDB was able to scale beyond other database workload applications. Adoption by the TPC. Usage and industry adoption. Supported Databases.

Benchmarking 63

Benchmarking Open Source C++ Cache 63

The Morning Paper

DECEMBER 3, 2019

Each instance is a full stack service in its own right, with front-end GUI components, a back-end server and data storage, and all the code necessary to coordinate them. Declarative assembly of web applications from predefined concepts De Rosso et al., I chose this paper to challenge my own thinking.

Open Source 52

Open Source Programming Speed Software 52

Smashing Magazine

SEPTEMBER 27, 2019

2019-09-27T12:00:59+02:00. 2019-09-27T10:38:23+00:00. In our case, it should be possible to add new entries into localStorage (that this application is using as storage) from the input field without the list, while the list still renders the entries from localStorage even if the input field is missing. Denys Mishunov.

Storage 69

Storage Testing Processing Code 69