Brendan Gregg

FEBRUARY 28, 2023

At USENIX SREcon22 APAC I gave the opening keynote on the future of computer performance, rounding up the latest developments and making predictions of where I see things heading. This talk originated from my updates to [Systems Performance 2nd Edition], and this was the first time I've given this talk in person! Or even on a plane.

Performance 110

Performance Latency Cache Virtualization 110

Brendan Gregg

FEBRUARY 28, 2023

At USENIX SREcon22 APAC I gave the opening keynote on the future of computer performance, rounding up the latest developments and making predictions of where I see things heading. This talk originated from my updates to Systems Performance 2nd Edition , and this was the first time I've given this talk in person!

Performance 52

Performance Latency Cache Virtualization 52

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. In a lot of cases, many DBAs have some flavor of monitoring tool that is already capturing performance data for them. NOTE : This process is not officially supported by SentryOne.

Azure 40

Azure Database Metrics Servers 40

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. Azure SQL Database and Azure Managed Instance have managed backups. This issue is valid for on-premises, IaaS, and partially for Azure SQL Managed Instance. Statistics.

Servers 49

Servers Azure Hardware Database 49

SQL Performance

MARCH 15, 2021

This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data. There is an XEvents Profiler built into modern versions of SSMS, with an equivalent extension for Azure Data Studio.

Servers 64

Servers Azure Best Practices Monitoring 64

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. How does this impact performance you may wonder? InvariantCulture. }

Servers 55

Servers Azure Hardware Network 55

SQL Server According to Bob

JUNE 22, 2016

Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. The three types of CMemThread partitioning and associated details are described in my previous post: [link]. A few are partitioned by NUMA node and fewer by CPU during their creation.

Servers 40

Servers Azure Software Engineering Design 40