SQL Performance

FEBRUARY 22, 2021

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. I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us.

Latency 57

Latency Servers Monitoring Systems 57

Brendan Gregg

JUNE 3, 2021

It was 2005, and I felt like I was in the eye of a hurricane. I was an independent performance consultant and Sun Microsystems had just released DTrace, a tool that could instrument all software. This gave performance analysts like myself X-ray vision. You can't make this stuff up. DTraceToolkit v0.96

Open Source 40

Open Source Code Engineering Technology 40

Brendan Gregg

MARCH 16, 2024

I'm sure this delivered large performance improvements and I wouldn't try arguing against it. 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. But I'd rather the cost be zero, of course!

Java 145

Java Cache Google Hardware 145

The Agile Manager

SEPTEMBER 30, 2013

Technocracy was, too: "best practice" was derived from people performing narrowly defined tasks in rigid processes that yielded poor quality products at a high cost. Frederick Taylor defined and measured performance down to the task level. In the 1980s, it seemed we were on the cusp of a revolution in management.

Education 45

Education Best Practices Retail Network 45

Dynatrace

DECEMBER 22, 2021

With observability, teams can understand what part of a system is performing poorly and how to correct the problem. Traces provide performance data about tasks that are performed by invoking a series of services. The key is knowing what is the root cause of the performance issue. Observability platforms provide context.

Artificial Intelligence 178

Artificial Intelligence Metrics Architecture DevOps 178

SQL Server According to Bob

JANUARY 11, 2020

As ​​ the ​​ administrator of a SQL Server 2005 installation, ​​ you will find that ​​ visibility into ​​ the ​​ SQL Server ​​ I/O ​​ subsystem ​​ has been ​​ significantly increased.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JULY 9, 2021

The British Standards Institution (2005) defines inclusive design as : “The design of mainstream products and/or services that are accessible to, and usable by, as many people as reasonably possible. without the need for special adaptation or specialized design.”. If you switched to a lighter blue or white font within the 4.5

Website 145

Website Mobile Design Testing 145

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.

Virtualization 111

Virtualization AWS Hardware Storage 111

Smashing Magazine

SEPTEMBER 16, 2021

And there is such a strategy — though it will seem almost ridiculous in its simplicity, maybe even crazy to those of us who haven’t spent years carefully developing ever more advanced skills and technologies. It looked realistic in 2004 but the rule was already irrelevant by 2005. So we added this constraint to our sanity check.

Automotive 138

Automotive Website Social Media Design 138

Smashing Magazine

MAY 17, 2021

Performance is a core feature of our company, Instant Domain Search —it’s in the name. 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. Beau Hartshorne. 2021-05-17T11:30:00+00:00. 2021-05-17T14:40:42+00:00.

Google 93

Google Analytics Serverless Metrics 93

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

SQL Server According to Bob

DECEMBER 18, 2018

Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The “forced flush” changes in SQL Server avoid flushes, when possible, in order to improve performance on non-optimized Fua file systems. Performance points of reference: The following charts highlight the increase in performance.

Servers 90

Servers Media Cache Storage 90

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.

Virtualization 40

Virtualization AWS Hardware Storage 40

IO River

NOVEMBER 2, 2023

‍You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. Sign 01 - Use of proprietary technologiesOne of the primary signs of becoming a victim of vendor lock-in is when you're using proprietary technologies by vendors.

Lambda 52

Lambda AWS Cache Website 52

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. With our focused investment in performance and scale, simply upgrading to SQL 2016 could bring 25% performance improvement. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

The Agile Manager

JANUARY 31, 2016

The ecosystem strategy takes this even further, combining unrelated capabilities under one roof (eBay buying Skype in 2005, SAP developing HANA in 2010, Facebook buying Oculus in 2014), often justifiable if only because digital commerce is still in its infancy and nobody is really sure what's going to work and what's not.

Blockchain 40

Blockchain Retail Social Media Airlines 40

IO River

NOVEMBER 2, 2023

You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. Later on, your service might require security, and you might use AWS Web Application Firewall, which directly integrates with Amazon CloudFront to help secure your service.

Lambda 52

Lambda AWS Cache Website 52