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. We recommend that you use the current SQL Server system views instead. Why this is a problem.

Latency 57

Latency Servers Monitoring Systems 57

All Things Distributed

SEPTEMBER 20, 2013

Combined with the rise of data warehouse workloads, where there is often significant redundancy in the values stored in columns, and database models based on column oriented storage took off. The first practical modern implementation is probably C-Store by Stonebraker, et al.

Storage 87

Storage Hardware Cache C++ 87

Brendan Gregg

MARCH 16, 2024

The problem is that this system has a default libc that has been compiled without frame pointers, so any stack walking stops at the libc layer, producing a partial stack that's missing the application frames. This is pretty common and usually goes unnoticed as the flame graph looks ok at first glance.

Java 145

Java Cache Google Hardware 145

All Things Distributed

DECEMBER 22, 2012

Werner Vogels weblog on building scalable and robust distributed systems. 2005: Fiona Apple , Extraordinary Machine. I might have picked Fiona Apple again, but she already has a 2005 spot. All Things Distributed. An Album for Each Year - 2012 Version. By Werner Vogels on 22 December 2012 06:00 PM. Comments (). Same for Eminem.

Traffic 87

Traffic Scalability Systems 87

SQL Performance

JANUARY 23, 2020

The queues component of our methodology comes from Performance Monitor counters, which provide a view of system performance from a resource standpoint.". However, some seem to have missed Davidson's point regarding the importance of resources and rely almost entirely on waits to present a picture of query performance and system health.

Tuning 115

Tuning Servers Monitoring Hardware 115

ScaleOut Software

JUNE 22, 2020

Going back to the mid-1990s, online systems have seen relentless, explosive growth in usage, driven by ecommerce, mobile applications, and more recently, IoT. From Distributed Caches to Real-Time Digital Twins.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

ScaleOut Software

JUNE 22, 2020

Going back to the mid-1990s, online systems have seen relentless, explosive growth in usage, driven by ecommerce, mobile applications, and more recently, IoT. From Distributed Caches to Real-Time Digital Twins.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

O'Reilly

APRIL 23, 2024

In 2005, in “ What is Web 2.0? ,” I made the case that the companies that had survived the dotcom bust had all in one way or another become experts at “harnessing collective intelligence.” Yet many of the most pressing risks are economic , embedded in the financial aims of the companies that control and manage AI systems and services.

Social Media 108

Social Media Google Internet Internet 108

John McCalpin

APRIL 2, 2020

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).

Benchmarking 59

Benchmarking Performance Latency Architecture 59

SQL Performance

MARCH 30, 2021

The fundamentals of row mode parallel execution haven’t changed since SQL Server 2005, so the following discussion is broadly applicable. A parallel query might start out requesting DOP 8, but be progressively downgraded to DOP 4, DOP 2, and finally DOP 1 due to a lack of system resources at that moment. MonthlyPosts AS. (

Cache 98

Cache Servers Operating System Processing 98

KeyCDN

MARCH 28, 2019

They are responsible for the implementation of database systems, ensuring proper communication between various web services, generating backend functionality, and more. Laravel also offers its own database migration system and has a robust ecosystem. Backend developers work with a wide range of libraries, APIs, web services, etc.

Programming 77

Programming Website Scalability Design 77

IO River

NOVEMBER 2, 2023

Therefore, there might be cases where your system could experience a downtime during the migration process. For example, Akamai introduced ASI in 2005, which became the standard for building new websites. How does vendor lock-in occur? Akamai tried to convince many users to use this new framework.

Lambda 52

Lambda AWS Cache Website 52

Sutter's Mill

DECEMBER 29, 2011

From 1975 to 2005, our industry accomplished a phenomenal mission: In 30 years, we put a personal computer on every desk, in every home, and in every pocket. In 2005, however, mainstream computing hit a wall. The free lunch is over. Now welcome to the hardware jungle. iPad 2, Playbook, Kindle Fire, Nook Tablet) and smartphones (e.g.,

Hardware 40

Hardware Games Operating System Software 40

Brendan Gregg

JUNE 3, 2021

It was 2005, and I felt like I was in the eye of a hurricane. However, I was doing training and consulting for Sun, helping their customers with system administration and performance. Another difference was that there were few roles in Australia for engineers in 2005, unlike the US. You can't make this stuff up.

Open Source 40

Open Source Code Engineering Technology 40

Brendan Gregg

NOVEMBER 29, 2017

It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. They were being launched piecemeal, improving performance of pre-Nitro systems. AWS has a name for their Bare Metal platform: it's the "Nitro system".

Virtualization 111

Virtualization AWS Hardware Storage 111

Smashing Magazine

DECEMBER 2, 2021

With the goals of sharing, openness and mentoring, you’re in for some great articles about systems administration topics written by fellow sysadmins. Tune in each day for an article that explores the wide range of topics in system administration. It launched in 2005 and still has all of the calendars available online.

Design 107

Design Development Programming Website 107

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. Recommendation Unchanged: Prior to SQL Server 2016 enable –T8048 on larger systems. The three types of CMemThread partitioning and associated details are described in my previous post: [link].

Servers 40

Servers Azure Software Engineering Design 40

All Things Distributed

AUGUST 17, 2011

Werner Vogels weblog on building scalable and robust distributed systems. Amazon S3 is much more than just storage; the network and distributed systems infrastructure to ensure that content can be served fast and at high rates without customers impacting each other, is amazing. All Things Distributed. Comments ().

Servers 126

Servers Social Media AWS Website 126

IO River

NOVEMBER 2, 2023

Therefore, there might be cases where your system could experience a downtime during the migration process. Not only that, but there can be cases where a piece of your application could break during the migration process that could take a long time to get back running.‍How does vendor lock-in occur?

Lambda 52

Lambda AWS Cache Website 52

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. The Back Story.

Servers 90

Servers Media Cache Storage 90

Brendan Gregg

AUGUST 8, 2017

Linux load averages are "system load averages" that show the running thread (task) demand on the system as an average number of running plus waiting threads. This measures demand, which can be greater than what the system is currently processing. then your system is idle. - cat /proc/loadavg. 42/3411 43603. 42/3411 43603.

Latency 111

Latency Metrics C++ Systems 111

Tim Kadlec

JANUARY 4, 2011

Back in 2005, the W3C pointed out that third party services had demonstrated that most captcha services could be defeated with 88%-100% accuracy by using some simple OCR. In particular, visitors who suffer from blindness, dyslexia or low vision will struggle greatly with a captcha system.

Internet 40

Internet Internet Systems Testing 40

Brendan Gregg

NOVEMBER 28, 2017

It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. They were being launched piecemeal, improving performance of pre-Nitro systems. AWS has a name for their Bare Metal platform: it's the "Nitro system".

Virtualization 40

Virtualization AWS Hardware Storage 40

Highly Scalable

MARCH 10, 2015

Most of this article represents an overview of the results published by retailers and researchers who built practical decision making and optimization systems combining abstract economic models with data mining methods. The most typical use cases for this problem are recommender systems, personalized search results ranking, and targeted ads.

Retail 152

Retail C++ Analytics Metrics 152

The Agile Manager

SEPTEMBER 30, 2013

Big companies] create all these systems and processes - and then end up with a very small percentage of people who are supposed to solve complex problems, while the other 98% of people just execute." Wall Street Journal, 24 December 2007. They are anathema to businesses with financing that demands precise control.

Education 45

Education Best Practices Retail Network 45

Smashing Magazine

SEPTEMBER 16, 2021

On design systems, CSS/JS and UX. It looked realistic in 2004 but the rule was already irrelevant by 2005. The last subject I chose (ecodesign) is also critical from a systemic point of view with major potential consequences on our personal and professional lives. With Carie Fisher, Stefan Baumgartner and so many others.

Automotive 138

Automotive Website Social Media Design 138

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. Design systems should be used not only to ensure branding and consistency, but accessibility, inclusivity, and understanding of code better.

Website 145

Website Mobile Design Testing 145

The Agile Manager

FEBRUARY 28, 2021

When I first joined ThoughtWorks in 2005, one of our core messages was to solve an “outer quadrant” problem first - something in the problem space that is difficult and complex. They went on to acknowledge that some of my colleagues had counseled them to do this some months before I started working with them. Quick wins” attack the margins.

Virtualization 52

Virtualization Systems Technology Technology 52

Strategic Tech

FEBRUARY 16, 2022

The system needs to be highly reliable because even just a little downtime can alienate loyal customers. Google Maps started life in 2005 as a desktop application for getting from point A to point B. Two particularly relevant patterns are Efficiency Enables Evolution and Higher Order Systems Create New Sources of Worth.

Innovation 52

Innovation Speed Google Strategy 52

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

The Agile Manager

MAY 7, 2010

How many different booking systems have your frequent flier numbers, know that you prefer an aisle to a window, and know that you prefer a vegetarian meal on long-haul flights? And how much of that has changed since you last edited your profile in each of those systems? We have a lot of redundant data. We lug this data around with us.

Storage 40

Storage Internet Internet Mobile 40