SQL Performance

JANUARY 23, 2020

The queues component of our methodology comes from Performance Monitor counters, which provide a view of system performance from a resource standpoint.". However, some seem to have missed Davidson's point regarding the importance of resources and rely almost entirely on waits to present a picture of query performance and system health.

Tuning 115

Tuning Servers Monitoring Hardware 115

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. 2006-01-01

Database 40

Database Analytics Blockchain Healthcare 40

Brendan Gregg

NOVEMBER 29, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. The first was c3.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Server According to Bob

JANUARY 11, 2020

© ​​ 2006 ​​ Microsoft Corporation. KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? ​​ All rights reserved.

Servers 40

Servers Cache Database Media 40

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. The first was c3.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

SEPTEMBER 25, 2020

Back in 2006, I complained via multiple Connect items about the lack of visibility of the default values for parameters in the catalog views. Here’s the only item I’ve found that made it to the new feedback system.). I recently answered a question on Stack Overflow about this problem, and it took me down memory lane.

Code 42

Code C++ Database Servers 42

Highly Scalable

MARCH 10, 2015

Most of this article represents an overview of the results published by retailers and researchers who built practical decision making and optimization systems combining abstract economic models with data mining methods. The most typical use cases for this problem are recommender systems, personalized search results ranking, and targeted ads.

Retail 152

Retail C++ Analytics Metrics 152