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. dm_os_performance_counters.

Latency 57

Latency Servers Monitoring Systems 57

O'Reilly

MARCH 26, 2024

To me, the analogy breaks down before it begins: firstly, LLMs don’t merely blur, but perform highly non-linear transformations, which means you can’t just squint and get a sense of the original; secondly, for the photocopier, the error is a bug, whereas, for LLMs, all errors are features. joined Flickr.

Artificial Intelligence 108

Artificial Intelligence Social Media Google Internet 108

All Things Distributed

SEPTEMBER 20, 2013

Many of the modern high-performance data warehouses such as Amazon Redshift are based on column stores. The first practical modern implementation is probably C-Store by Stonebraker, et al. There is a great tutorial by Harizopoulos, Abadi and Boncz from VLDB 2009 that takes you through the history, trade-off''s and the state of the art.

Storage 87

Storage Hardware Cache C++ 87

SQL Performance

MARCH 30, 2021

It includes initializing each operator, and adding hidden profilers to collect runtime performance data like actual row count and elapsed time. The fundamentals of row mode parallel execution haven’t changed since SQL Server 2005, so the following discussion is broadly applicable. Compatibility level 150 is used exclusively.

Cache 98

Cache Servers Operating System Processing 98

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. It has helped assure that these applications deliver predictably fast performance and scale to meet the demands of growing workloads.

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. It has helped assure that these applications deliver predictably fast performance and scale to meet the demands of growing workloads.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

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. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

Virtualization 111

Virtualization AWS Hardware Storage 111

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. Check out how to perform an Express CDN integration with KeyCDN.

Programming 77

Programming Website Scalability Design 77

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

IO River

NOVEMBER 2, 2023

‍You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. 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.

Lambda 52

Lambda AWS Cache Website 52

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 139

Automotive Website Social Media Design 139

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

Smashing Magazine

DECEMBER 2, 2021

Good ol’ PerfPlanet is back for another season with all things speed and web performance. Anyone is welcome to contribute to the calendar , so do feel free to reach out with a topic or tool you’re passionate about, or a technique you’d like to teach and tell the web performance community about. Stoyan Stefanov on Twitter.

Design 108

Design Development Programming Website 108

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. 4 Socket, TPCC.

Servers 90

Servers Media Cache Storage 90

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

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

IO River

NOVEMBER 2, 2023

You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. Therefore, there might be cases where your system could experience a downtime during the migration process. Akamai tried to convince many users to use this new framework.

Lambda 52

Lambda AWS Cache Website 52

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.

Latency 111

Latency Metrics C++ Systems 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. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

Virtualization 40

Virtualization AWS Hardware Storage 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

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. Moreover, gross margin is not the only performance metric that is important for retailers. Applications.

Retail 152

Retail C++ Analytics Metrics 152

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