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

Alex Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. – New Technologies. I decided to publish a few parts here to see if anything triggers a discussion. – Cloud. – Agile.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain.

Performance 124

Performance Network Cache Metrics 124

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. The first was c3. 0% performance overhead.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

APRIL 23, 2019

In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate. SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. Introduction. instructions are available.

Servers 67

Servers Testing Metrics Storage 67

SQL Performance

APRIL 10, 2019

The ISO/IEC 9075:2016 standard, or SQL:2016 in short, introduces support for a profound concept called Row Pattern Recognition (RPR) in SQL. I posted a suggestion to improve SQL Server by adding support for RPR in T-SQL , but I was quite limited in the space that I had to provide the feedback.

C++ 73

C++ Servers Virtualization Code 73

Alex Russell

MAY 9, 2022

Panglossian nonsense. --> Organisations that serve their tools tread water no matter how advanced their technology, while groups that intentionally manage systems can succeed on any stack. [1]. Teams that achieve Level 4 maturity are cautious acquirers of technology. Value Propositions #. What's the problem? Management Attributes #.

Performance 86

Performance Latency Metrics Engineering 86

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. So, apart from powering servers with renewable energy, what else can web developers do about climate change? Server-Side Performance.

Website Performance 73

Website Performance Website Energy Performance 73

Smashing Magazine

JANUARY 21, 2019

An API is the communication channel for an application to load data from the server. This relationship can be expressed through an associative array (an array of key => property) on the server-side, in which each module states its name as the key attribute and its inner modules under the property modules. Large preview ).

Social Media 65

Social Media Database Media Website 65

The Symphonia

DECEMBER 6, 2017

It’s no longer a niche technology for enthusiasts?—?it’s without web app servers?—?to Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. There have been some improvements since re:Invent 2016 but to see nothing announced at this re:Invent was very disappointing.

Serverless 40

Serverless Lambda AWS Traffic 40

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. The first was c3. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40