SQL Performance

APRIL 8, 2020

This article is the first in a series about the fundamentals of table expressions in T-SQL. I will mainly focus on four types of named table expressions, which are known in T-SQL as derived tables, common table expressions (CTEs), views, and inline table-valued functions (inline TVFs). They are all named table expressions.

C++ 143

C++ Azure Database Servers 143

Percona

OCTOBER 18, 2023

With proprietary databases, customers often get used to having constant technical support from their vendors, especially if the organization they work for lacks in-house expertise. These vendors often provide integrated stacks that include the database, application server, and other components that seamlessly integrate.

Open Source 93

Open Source Database Hardware Strategy 93

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. 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. Test Environment. Test Environment. Row Store Clustered Index.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

IO River

NOVEMBER 15, 2023

It acts like a shield for web applications, ensuring that only legitimate requests get through.When talking about how and where WAF operates, we refer to the OSI Model. ‍This rulebook is a dynamic entity that can be customized or managed through vendors.Custom Rules‍‍Let's get into custom rules first. How do you stay ahead?

Traffic 52

Traffic Network Logistics Architecture 52

SQL Performance

JULY 11, 2019

Last year, I got together with one of my dev teams at SentryOne – they call themselves the SQL Injectors – to talk about the possibility of replicating Plan Explorer functionality inside of Azure Data Studio. How You Get It. Connecting to SQL Server 2012 or better, or Azure SQL Database. or better).

Azure 90

Azure Servers Tuning Operating System 90

Dynatrace

MAY 22, 2019

Proudly announcing the release of Dynatrace user sessions queries. User sessions queries is a powerful tool that increases your analytics capabilities exponentially. User Session Query Language (USQL) makes it easy to segment, aggregate, and filter data in whatever way best meets your business requirements.

Analytics 104

Analytics Tuning Metrics Programming 104

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented.

Servers 95

Servers Tuning Architecture Processing 95

SQL Performance

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). Extended Events provides data about the individual execution of queries, while Query Store and the DMVs aggregate performance data. Example Scenario.

C++ 74

C++ Database Servers Tuning 74

IO River

NOVEMBER 2, 2023

It acts like a shield for web applications, ensuring that only legitimate requests get through.When talking about how and where WAF operates, we refer to the OSI Model. This rulebook is a dynamic entity that can be customized or managed through vendors.Custom Rules‍‍Let's get into custom rules first. It's an ongoing, iterative process.

Traffic 40

Traffic Network Logistics Architecture 40

SQL Performance

DECEMBER 9, 2020

At the time of writing, T-SQL doesn’t provide such a built-in tool, but one can always hope and vote for such a tool to be added in the future. I experimented with varying cardinalities of the base CTE, starting with 2 and advancing in a logarithmic scale, squaring the previous cardinality in each step: 2, 4, 16 and 256.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

APRIL 6, 2020

DDL); and, it captures events using local time (our servers are Eastern and obey DST). So, even if the default trace is disabled, we can still pull data from the files using the following query (with adjustments to show the data in UTC): ; WITH dst AS. ( HostName , App = CASE WHEN ApplicationName LIKE N'%Management Studio%Query%'.

Servers 61

Servers Tuning Database 61

HammerDB

APRIL 19, 2023

Know your target platform Everything starts with knowing the target. Know your target platform Everything starts with knowing the target. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error.

Performance 54

Performance Benchmarking Cache Storage 54

SQL Performance

MAY 7, 2019

Back in 2014, I started a series of blog posts here to talk about specific wait types and what they do and don’t mean. I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server. SQL Server also keeps track of how long the thread has to wait.

Servers 40

Servers Azure Metrics Tuning 40

SQL Performance

AUGUST 15, 2019

Last year, I got together with one of my dev teams here – they call themselves the SQL Injectors – to talk about the possibility of replicating SentryOne Plan Explorer functionality inside of Azure Data Studio. How You Get It. Connecting to SQL Server 2012 or better, or Azure SQL Database. or better).

Azure 50

Azure Servers Tuning Operating System 50

The Morning Paper

MARCH 10, 2020

You get good at what you practice. This benchmark can synthetically generate more precise key-value queries that represent the reads and writes of key-value stores to the underlying storage system. Getting a key requires combining all previously stored deltas using a user-provided combine function. FAST’20.

Benchmarking 59

Benchmarking Storage Cache Open Source 59

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. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. So, What is MySQL Partitioning?

Strategy 40

Strategy Storage Database Best Practices 40

Percona

DECEMBER 20, 2018

Linux OS Tuning for MySQL Database Performance. In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud.

Database 40

Database Tuning Performance AWS 40

SQL Performance

DECEMBER 9, 2020

At the time of writing, T-SQL doesn’t provide such a built-in tool, but one can always hope and vote for such a tool to be added in the future. I experimented with varying cardinalities of the base CTE, starting with 2 and advancing in a logarithmic scale, squaring the previous cardinality in each step: 2, 4, 16 and 256.

C++ 61

C++ Servers Testing Processing 61

SQL Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Spend a day getting immersed in technology with Andrew.

Engineering 40

Engineering Azure Best Practices Servers 40

SQL Performance

SEPTEMBER 2, 2021

SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT().

C++ 59

C++ Servers Testing Database 59

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 White Paper is for informational purposes only.

Servers 40

Servers Cache Media Hardware 40

HammerDB

OCTOBER 12, 2018

Historically MySQL has been positioned for supporting web-based applications this is in contrast to enterprise based database workloads that have been served by commercial databases such as Oracle, Db2 and SQL Server. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. 10 rows in set (0.02

Best Practices 40

Best Practices Scalability Performance C++ 40

The Netflix TechBlog

APRIL 29, 2019

Content is placed on the network of servers in the Open Connect CDN as close to the end user as possible, improving the streaming experience for our customers and reducing costs for both Netflix and our Internet Service Provider (ISP) partners. Our Infrastructure Security team leverages Python to help with IAM permission tuning using Repokid.

Open Source 279

Open Source Network Infrastructure Big Data 279

The Netflix TechBlog

DECEMBER 17, 2019

If the process is terminated, it can resume after the last completed chunk without needing to start from scratch. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. As transaction logs typically have limited retention, they aren’t guaranteed to contain the full history of changes.

Database 212

Database Traffic Transportation Open Source 212

The Netflix TechBlog

DECEMBER 17, 2019

If the process is terminated, it can resume after the last completed chunk without needing to start from scratch. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. As transaction logs typically have limited retention, they aren’t guaranteed to contain the full history of changes.

Database 197

Database Traffic Transportation Open Source 197