SQL Performance

FEBRUARY 22, 2021

I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us. The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests , sys.dm_exec_sessions , and sys.dm_exec_connections.

Latency 57

Latency Servers Monitoring Systems 57

Rigor

JANUARY 13, 2020

This book is about performance problems and the various technologies created to fight them. Podjarny presents a series of increasingly larger-scope solutions to each issue, including client-side techniques and RESS (Responsive + Server Side). High Performance Browser Networking. Time is Money. Responsive and Fast. The Art of SEO.

Performance 75

Performance Social Media Website Website Performance 75

Brendan Gregg

MARCH 16, 2024

2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. We may get there with future technologies I'll cover later. Back-end servers. But I'd rather the cost be zero, of course!

Java 145

Java Cache Google Hardware 145

Smashing Magazine

MAY 17, 2021

I founded Instant Domain Search in 2005 and kept it as a side-hustle while I worked on a Y Combinator company (Snipshot, W06), before working as a software engineer at Facebook. Over time, we’ve evolved through a variety of static site generators, JavaScript frameworks, and server technologies. We still have a lot of work to do!

Google 95

Google Analytics Serverless Metrics 95

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link]. Follow-up.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

KeyCDN

MARCH 28, 2019

Features Simple and fast routing engine Comes with its own CLI Powerful template system (Blade) Good documentation CakePHP CakePHP is one of the first PHP frameworks to be released back in 2005. Phoenix uses a combination of tried and true technologies with the fresh ideas of functional programming.

Programming 77

Programming Website Scalability Design 77

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. 0% performance overhead.

Virtualization 111

Virtualization AWS Hardware Storage 111

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40