SQL Performance

APRIL 13, 2020

In my last post , I started to outline the process I go through when tuning queries – specifically when I discover that I need to add a new index, or modify an existing one. This is where index tuning becomes an art. To begin with, I often have at least two variations of an index that I want to test, sometimes more.

Tuning 137

Tuning Cache Metrics Testing 137

Alex Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. I decided to publish a few parts here to see if anything triggers a discussion. – Cloud. – Agile. – Continuous Integration.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

SQL Performance

DECEMBER 9, 2020

Testing different base table cardinalities is just one dimension to try. I’ll present the performance tests that I’ve done with my solution. Let’s proceed to performance testing. I tested my solutions in SQL Server 2019 Enterprise edition. Here’s the dummy table definition: CREATE TABLE dbo.

C++ 114

C++ Servers Testing Processing 114

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

SQL Performance

DECEMBER 9, 2020

Testing different base table cardinalities is just one dimension to try. I’ll present the performance tests that I’ve done with my solution. Let’s proceed to performance testing. I tested my solutions in SQL Server 2019 Enterprise edition. Here’s the dummy table definition: CREATE TABLE dbo.

C++ 61

C++ Servers Testing Processing 61

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Much of my testing was on Linux 4.14.11 Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar. and 4.14.12

Performance 75

Performance Benchmarking Cache Tuning 75

Brendan Gregg

FEBRUARY 8, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Much of my testing was on Linux 4.14.11 Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar. and 4.14.12

Performance 40

Performance Benchmarking Cache Tuning 40