SQL Performance

JULY 3, 2019

However, in this case the application didn't use stored procedures for access to the database, and all of the code was generated by an ORM. The documentation for TransactionScope pretty quickly ruled that out as a possible cause of this. The application enlisting a SqlTransaction() on the connection.

Servers 64

Servers Hardware Code Virtualization 64

HammerDB

DECEMBER 5, 2020

First of all it has always been clear in the HammerDB documentation that the TPROC-C/TPC-C and TPROC-H/TPC-H workloads have not been ‘real’ audited and published TPC results instead providing a tool to run workloads based on these specifications.

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 109

Availability Database Open Source Hardware 109

Abhishek Tiwari

DECEMBER 13, 2017

This is a question recently asked and explored by a team of Google researchers led by Jeff Dean with a major focus on database indexes. This has far-reaching implications how future data systems and algorithms will be designed. Can machine learning-based data structures i.e. learned data structures replace traditional data structures?

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Instead of worrying about infrastructure management functions, such as capacity provisioning and hardware maintenance, teams can focus on application design, deployment, and delivery. Simplicity.

Serverless 279

Serverless AWS Lambda Storage 279

Dotcom-Montior

DECEMBER 8, 2021

ITSM defines how teams design, create, and deliver their services. The IT service catalog is typically a database or resource that an organization creates to provide users with information on their operational services and offerings. Software services still require physical devices and hardware for them to function.

Social Media 90

Social Media Monitoring Latency DevOps 90

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

The Morning Paper

MARCH 3, 2020

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. NSDI’20. This paper is a real joy to read. Requirements.

Database 106

Database AWS Network Design 106

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. From AWS documentation , Amazon EBS is an easy-to-use, scalable, high-performance block-storage service designed for Amazon EC2.

Cloud 120

Cloud Serverless AWS Storage 120

All Things Distributed

OCTOBER 8, 2014

We are introducing native support for document model like JSON into DynamoDB, the ability to add / remove global secondary indexes, adding more flexible scaling options, and increasing the item size limit to 400KB. We designed DynamoDB to operate with at least 99.999% availability. NoSQL and Flexibility: Document Model.

Availability 145

Availability Performance Scalability AWS 145

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.” And there are tools for archiving and indexing prompts for reuse, vector databases for retrieving documents that an AI can use to answer a question, and much more. of users and 3.9% of nonusers.

Open Source 108

Open Source Artificial Intelligence Google Infrastructure 108

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

AUGUST 18, 2023

Why not just create another database on the same instance? We split databases by function/team to give each team full autonomy over their schema, And if someone screws up, it breaks their cluster, not all databases. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance.

Programming 86

Programming Servers Database Hardware 86

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Where a high availability design once worked well, it can no longer keep up with more complex requirements. The same changes made in the primary database are made in the replicas.

Availability 85

Availability Open Source Architecture Database 85

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. First released in 2009, it is the most used NoSQL database and has been downloaded more than 325 million times. The bigger the database, the bigger the damage from a leak.

Database 81

Database Servers Storage Strategy 81

All Things Distributed

JANUARY 18, 2012

a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. Today is a very exciting day as we release Amazon DynamoDB , a fast, highly reliable and cost-effective NoSQL database service designed for internet scale applications. Amazon DynamoDB â?? By Werner Vogels on 18 January 2012 07:00 AM.

Scalability 167

Scalability Database Ecommerce Latency 167

SQL Server According to Bob

JULY 13, 2016

desktop machine (I won’t tell you the hardware details. This is effectively the same as if you had used the full install and picked the features of Database Engine Services and Client Connectivity SDK as the two components to install. Go install it”. So I proceeded to install SQL Server 4.20 on my Windows NT 3.1 It would scare you).

Servers 40

Servers Media Engineering Virtualization 40

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. If you don’t have well-designed and small columns for this composite primary key, it could enlarge all of your secondary indexes. Additionally, MySQL 8.0

Strategy 40

Strategy Storage Database Best Practices 40

SQL Performance

JANUARY 23, 2020

The approach was influential in the design of the SQL Sentry performance dashboard, which presents waits flanked by queues (key resource metrics) to deliver a comprehensive view of server performance. Recently, a SentryOne customer contacted me about performance concerns with their SentryOne database. The Top Queries That Weren't.

Tuning 115

Tuning Servers Monitoring Hardware 115

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

Percona

DECEMBER 14, 2022

In the database world there are essentially two types of database operations: Online Transaction Processing , OLTP : Online transaction processing applications have high throughput and are insert- or update-intensive in database management. There’s actually more documented. OLTP vs OLAP. Let’s get back to basics.

Database 92

Database Analytics Storage Processing 92

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

Testsigma

FEBRUARY 6, 2020

Documents like requirements documents, design documents, code are reviewed and review comments are provided at early stages of Software Lifecycle. The internal structure and design of the code are known to the user; hence all the logical paths are tested under White Box testing. White Box Testing.

Software 69

Software Software Testing Scalability 69

Alex Russell

APRIL 29, 2021

Apple's policy against browser engine choice adds years of delays beyond the (expected) delay of design iteration, specification authoring, and browser feature development. is access to hardware devices. This allows customisation and use of specialised features without custom, proprietary software for niche hardware.

Media 145

Media Games Education Engineering 145

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

O'Reilly

OCTOBER 11, 2022

We’ll see it in the processing of the thousands of documents businesses handle every day. However, one thing should be obvious: to fill a prescription, you need to access many different kinds of data, in many different databases. Our current set of AI algorithms are good enough, as is our hardware; the hard problems are all about data.

Games 116

Games Healthcare Processing Retail 116

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

The Netflix TechBlog

FEBRUARY 13, 2020

There is a potential benefit in reusing the hardware in place for video compression/decompression. Image decoding in hardware may not be a primary motivator, given the peculiarities of OS dependent UI composition, and architectural implications of moving uncompressed image pixels around.

Code 212

Code Metrics Efficiency Open Source 212

Alex Russell

MARCH 6, 2021

Unless a site is installed to the home screen as a PWA , any single page is just another in a series of documents that users experience as a river of links. Hardware Past As Performance Prologue. Chip design choices and silicon economics are the defining feature of the still-growing Performance Inequality Gap. Mind The Gap.

Performance 124

Performance Network Cache Metrics 124

Alex Russell

JUNE 20, 2020

built-in relational SQL database engines. In each quantum of time, hardware and OS vendors press ahead, adding features. As OS and hardware deployed base integrate these components, the set of what most computers can do is expanded. This is often determined by hardware integration and device replacement rates.

Hardware 55

Hardware Games Java Media 55

SQL Performance

MARCH 8, 2021

The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. This uses hardware, typically a crystal oscillator, that produces ticks at a very high constant rate regardless of processor speed, power settings, or anything of that nature. Alternate designs.

Servers 95

Servers Tuning Architecture Processing 95

Percona

AUGUST 27, 2018

MySQL 8 introduced a feature that is explained only in a single documentation page. assigning to a specific CPU) is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth. Currently, CPU affinity (i.e., The outcome may surprise some readers.

Tuning 45

Tuning Virtualization Testing Servers 45

Smashing Magazine

JANUARY 6, 2020

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. Map design decisions against performance budget and the priorities defined early on.

Performance 145

Performance Cache Network Metrics 145

High Scalability

NOVEMBER 25, 2019

To help our customers manage ongoing data explosion, we have designed many of the core components over the last few years. Document store. Egnyte Connect as the content collaboration and data management platform is used by thousands of customers as the single Secure Content Platform for all of their document management needs.

Architecture 52

Architecture Cache Azure Storage 52

Smashing Magazine

JANUARY 7, 2019

Performance isn’t just a technical concern: it matters, and when baking it into the workflow, design decisions have to be informed by their performance implications. Without a strong alignment between dev/design and business/marketing teams, performance isn’t going to sustain long-term. Setting Realistic Goals.

Performance 104

Performance Cache Metrics Network 104