SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This system has one AMD EPYC 7502P 32-core processor and 512GB of RAM. The price per QphH for this system is 0.34 The price per QphH for this system is 0.47

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

MARCH 15, 2021

In my last post , I illustrated one reason you should stop using deprecated system tables like sysprocesses. This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data.

Servers 64

Servers Azure Best Practices Monitoring 64

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. System locks also count, but these are rarely held for long and aren’t associated with the user transaction. Let’s look at some examples using a fresh database.

Database 98

Database Storage Testing Servers 98

SQL Performance

SEPTEMBER 17, 2019

SSRS 2008 brought that component into the reporting service module. Unlike the system database tempdb, ReportServerTempDB is not recreated at startup. Caches of report results are stored in the ReportServerTempDB database and I/O performance can become an issue here. A scale-out deployment requires an Enterprise Edition license.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

MAY 1, 2020

I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. If you have instances running older versions like SQL Server 2008 R2 (I found one!), writes/sec average throughput: 46.96

C++ 58

C++ Database Servers Storage 58

Alex Russell

AUGUST 30, 2021

Does Apple restrict, in any way, the ability of competing web browsers to deploy their own web browsing engines when running on Apple's operating system? Anyone who cares to download and fork the code can do so. House Antitrust Subcommittee includes their most specific claims: 4. If no, please explain why not.

Engineering 98

Engineering Open Source Website Operating System 98

SQL Performance

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). Extended Events provides data about the individual execution of queries, while Query Store and the DMVs aggregate performance data. Each option has pros and cons. Example Scenario.

C++ 74

C++ Database Servers Tuning 74

Sutter's Mill

AUGUST 27, 2010

5 Avoid Calling Unknown Code While Inside a Critical Section (Dec 2007). 6 Use Lock Hierarchies to Avoid Deadlock (Jan 2008). Feb 2008). 8 Going Superlinear (Mar 2008). 9 Super Linearity and the Bigger Machine (Apr 2008). 10 Interrupt Politely (May 2008). 13 The Many Faces of Deadlock (Aug 2008).

Website 40

Website Scalability Code Design 40

Sutter's Mill

SEPTEMBER 24, 2010

5 Avoid Calling Unknown Code While Inside a Critical Section (Dec 2007). 6 Use Lock Hierarchies to Avoid Deadlock (Jan 2008). Feb 2008). 8 Going Superlinear (Mar 2008). 9 Super Linearity and the Bigger Machine (Apr 2008). 10 Interrupt Politely (May 2008). 13 The Many Faces of Deadlock (Aug 2008).

Programming 41

Programming Website Scalability Design 41

Sutter's Mill

JULY 12, 2010

From the article: … Active objects dramatically improve our ability to reason about our thread’s code and operation by giving us higher-level abstractions and idioms that raise the semantic level of our program and let us express our intent more directly. 5 Avoid Calling Unknown Code While Inside a Critical Section (Dec 2007).

C++ 40

C++ Java Programming Website 40

All Things Distributed

MAY 8, 2012

Werner Vogels weblog on building scalable and robust distributed systems. Using the AWS Toolkit for Visual Studio , you can now deploy your.NET applications to AWS Elastic Beanstalk directly from your Visual Studio environment without changing any code. All Things Distributed. Expanding the Cloud for Windows Developers. Comments ().

Cloud 115

Cloud Development AWS Servers 115

Randon ASCII

FEBRUARY 11, 2018

I immediately saw that CcmExec.exe (part of Microsoft’s System Management Server ) had 508,000 handles open, which is both a lot and also amazingly close to my zombie count. In hindsight it’s obvious that these zombies were caused by a trivial user-space coding bug. A Windows kernel file buffer bug from Server 2008 R2 to Windows 10.

Processing 72

Processing Programming Code Cache 72

Randon ASCII

FEBRUARY 25, 2018

Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes? This command compares the code bytes in the crash dump (some of them are saved in the crash dump, just in case) against those on disk. In this case it said that 9322 bytes in the code in the crash dump were wrong.

Programming 79

Programming Hardware Cache Code 79

O'Reilly Software

OCTOBER 23, 2018

Technology systems are difficult to wrangle. Our systems grow in accidental complexity and complication over time. The product management team states what must be done to solve the problem, and the architect describes how to realize that vision in a system. To do so, we borrow metaphors from roles in other industries.

Strategy 100

Strategy Architecture Technology Technology 100

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

The Agile Manager

FEBRUARY 28, 2017

Management textbooks dating at least as far back as the 1980s included stories of employees performing tasks the reasons for which they didn't really understand. Tool 1: Dolly the Sheep Companies that are heavily rule-based - think insurance - eagerly moved their business rules into code. Why not put them back on the payroll?

Strategy 40

Strategy Java Code Systems 40

SQL Performance

APRIL 26, 2019

The DTU calculator is a free tool you can use to upload performance metrics from your server, and use the data to determine the appropriate service tier if you were to migrate that server to an Azure SQL Database (or to a SQL Database elastic pool ). NOTE : This process is not officially supported by SentryOne. Logical Disk – Disk Reads/sec.

Azure 40

Azure Database Metrics Servers 40

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. And we state in the documentation the following regarding tempdb: Transparent Data Encryption and the tempdb System Database. For more information about the tempdb system database, see tempdb Database.

Servers 40

Servers Database Azure Cache 40

Smashing Magazine

AUGUST 20, 2021

However, unlike the early days of the web, static sites are no longer limited to developers working in a code editor. During the 90s, we saw two content management systems for static sites — Microsoft FrontPage in 1996 and Macromedia Dreamweaver in 1997. Maintaining layouts became a particular pain point for static sites.

Ecommerce 139

Ecommerce Website Government Internet 139

O'Reilly

JULY 25, 2023

If you’re reading this, chances are you’ve played around with using AI tools like ChatGPT or GitHub Copilot to write code for you. So far I’ve read a gazillion blog posts about people’s experiences with these AI coding assistance tools. And if I switch tabs to view a paper from 2008, then a song from 2008 could start up.

Programming 98

Programming Code Design Benchmarking 98

SQL Server According to Bob

JANUARY 11, 2020

SNI Server Network Interface (SNI) is centralized code, shared among the SQL Server and SQL Server client providers, both Windows and Linux that can send, parse and act upon ​​ TDS communications. ​​ ​​ Start by ​​ determining ​​ what is registered on your system.

Network 40

Network Servers Processing Software Engineering 40

O'Reilly

SEPTEMBER 19, 2023

” Each step has been a twist on “what if we could write code to interact with a tamper-resistant ledger in real-time?” Mental contortions led to code contortions led to frustration. After each iteration, the process compares the results to its fitness function , then mixes the attributes of the top performers.

Hardware 99

Hardware Storage Big Data Blockchain 99