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. Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The key specifications for the Lsv2 series virtual machines are shown in Table 1.

Azure 42

Azure Virtualization Storage Benchmarking 42

The Symphonia

DECEMBER 6, 2017

Correspondingly, 3GB functions should see a 2x CPU performance improvement over 1.5GB Lambdas, but this is through doubling the number of cores the function has access to, rather than double the virtualized time-slices. Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for.

Serverless 40

Serverless Lambda AWS Traffic 40

SQL Performance

JULY 8, 2020

In my examples I’ll use sample databases called TSQLV5 and PerformanceV5. The outer query then filters from those three orders only those that were placed on or after July 8 th , 2017. This query generates the following output: orderid orderdate -- - 10250 2017-07-08 (1 row affected). Example for performance reasons.

Servers 110

Servers Code Performance Processing 110

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 98

Availability Open Source Architecture Database 98

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2017: MongoDB goes public, trading as MDB.

Open Source 98

Open Source Programming Database Servers 98

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Database architects working with MongoDB encounter specific challenges related to database systems and system growth.

Best Practices 98

Best Practices Traffic Database Servers 98

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. TrueTime was introduced to support Spanner - Google’s globally distributed, and synchronously-replicated database. Spanner: Google’s Globally Distributed Database ??.

AWS 55

AWS Google Database Virtualization 55

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. TPC-H Benchmark Results with SQL Server 2017. HPE has already submitted a new official TPC-H result on SQL Server 2017 for a single-socket, HPE Proliant DL325 Gen10 1U server that was 743,750 QphH@1000GB. TPC-E Benchmark Results with SQL Server 2017. More total PCIe lanes and bandwidth.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Percona Community

JUNE 8, 2018

Since summer 2017, Amazon RDS supports encryption at rest using AWS Key Management Service (KMS) for db.t2.small medium database instances, making the feature now available to virtually every instance class and type. small and db.t2.medium micro, every other instance class now supports native encryption at rest using KMS.

Virtualization 40

Virtualization AWS Database Availability 40

SQL Server According to Bob

APRIL 24, 2018

I also started my career developing on UNIX systems with C++ and databases like Ingres. Last October we released SQL Server 2017 including support for Linux and Docker Containers. docker pull microsoft/mssql-server-linux:2017-latest. As I moved to other jobs, the PC was becoming very popular as was the Windows Operating System.

Servers 40

Servers Internet Internet Open Source 40

Smashing Magazine

DECEMBER 22, 2021

Their design tools database features tools for everything from UI design and prototyping, to user flow and handoff, design systems and versioning. To help us do better, UX Planet published a four-part article series on streamlining the checkout experience back in 2017 which is still gold for everyone working on a checkout flow today.

Mobile 136

Mobile Airlines Design Strategy 136

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. It also enables geographically distributed databases for disaster recovery.

Servers 52

Servers Database Availability Traffic 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. top(1) showed that only the Cassandra database was consuming CPU. This was much worse many years ago on Xen virtual machine guests.

Speed 40

Speed Java AWS Virtualization 40

Alex Russell

APRIL 29, 2021

WebGL 2 launched for other platforms on Chrome and Firefox in 2017. Now in development in WebKit after years of radio silence, WebXR APIs provide Augmented Reality and Virtual Reality input and scene information to web applications. The underlying graphics capabilities from OpenGL ES 3.0

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

FEBRUARY 13, 2020

​​​​ A utility would issue the dbcc freeze to stop the I/O activity for the database. ​​ 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.

Servers 40

Servers Availability Transportation Database 40

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. Microsoft SQL Server Database Engine Input/Output Requirements. product: Virtual Disk.

Servers 90

Servers Media Cache Storage 90