SQL Performance

MARCH 17, 2020

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Cost" column shows the optimizer's cost estimate for each query as reported on the test system. BountyAmount.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

MAY 1, 2020

I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. Change the Target Recovery Time of a Database. databases AS d.

C++ 58

C++ Database Servers Storage 58

All Things Distributed

APRIL 19, 2010

Werner Vogels weblog on building scalable and robust distributed systems. Here are the laurels given by the editors: Debuting in November 2008, Amazons entry into the CDN market quickly became a major player. a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. All Things Distributed.

Media 60

Media AWS Storage Big Data 60

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

SQL Performance

OCTOBER 29, 2019

In order to use Query Store and Extended Events, you have to configure them in advance – either enabling Query Store for your database(s), or setting up an XE session and starting it. [ dbid ] ) AS [ Database Name ] , REPLACE ( REPLACE ( LEFT ( t. [ SELECT TOP ( 50 ) DB_NAME ( t. [

C++ 74

C++ Database Servers Tuning 74

SQL Performance

APRIL 26, 2019

If so, you may have heard about the Azure SQL Database DTU calculator , and you may have also read about how it has been reverse engineered by Andy Mallon. Database – Log Bytes Flushed/sec. When I looked through the SentryOne database, I found that 3 of the 4 counters were already being captured by default.

Azure 40

Azure Database Metrics Servers 40

SQL Performance

SEPTEMBER 6, 2022

Let’s look at some examples using a fresh database. 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. USE master ; -- Create a new test database. -- COLLATE clause only to remind people it exists.

Database 98

Database Testing Storage Servers 98

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

O'Reilly Software

OCTOBER 23, 2018

Technology systems are difficult to wrangle. Our systems grow in accidental complexity and complication over time. The product management team states what must be done to solve the problem, and the architect describes how to realize that vision in a system. To do so, we borrow metaphors from roles in other industries.

Strategy 100

Strategy Architecture Technology Technology 100

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. This system has one AMD EPYC 7502P 32-core processor and 512GB of RAM. The price per QphH for this system is 0.34 That is a higher score, but this system used two Intel Xeon Platinum 8180 28-core processors (that had a total of 56C/112T) and 512GB of RAM. In this case, 6,716.88/64

Servers 52

Servers Benchmarking Virtualization Architecture 52

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). In addition, there are fewer resources, plugins, libraries, third-party tools, and sources of support available than for other, more established database systems.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. I always check backups first when looking at a new system. When looking at backups, I check for recovery model and the current history of backups for each database. DBCC CHECKDB.

Servers 49

Servers Azure Hardware Database 49

O'Reilly

JULY 25, 2023

And if I switch tabs to view a paper from 2008, then a song from 2008 could start up. To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022.

Programming 98

Programming Code Design Benchmarking 98

SQL Server According to Bob

JANUARY 26, 2017

Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest. That is to ensure your database is encrypted at the file level.

Servers 40

Servers Database Azure Cache 40

SQL Performance

JULY 16, 2019

This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile. You might be asking why you should care about all of this as a SQL Server Database professional? Figure 2: AMD EPYC Rome Processor. How is This Relevant for SQL Server? There are many reasons!

Servers 46

Servers Hardware Architecture Retail 46

The Agile Manager

FEBRUARY 28, 2017

There are people behind the systems to which we're bound today. Ten years ago, I was leading an inception for a company replacing their fleet maintenance systems. More modestly, we can simply license technology to replace major portions of legacy systems, and train or hire experts in that technology.

Strategy 40

Strategy Java Code Systems 40

SQL Server According to Bob

JANUARY 11, 2020

​​​​ Note:​​ The BID/SNI ​​ Trace for the ​​ SQL Server (SQL 2008’ish ​​ days) used to require ETW setup and a restart of SQL Server. ​​ ​​ Start by ​​ determining ​​ what is registered on your system.

Network 40

Network Servers Processing Software Engineering 40

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. Processed 4.15

Database 48

Database Analytics Blockchain Healthcare 48