SQL Performance

MARCH 15, 2021

In my last post , I illustrated one reason you should stop using deprecated system tables like sysprocesses. Since SQL Server 2012 (and, to a much lesser extent, since SQL Server 2008), the most complete and flexible solution for monitoring events on a SQL Server instance has been Extended Events. Afraid of Extended Events?

Servers 64

Servers Azure Best Practices Monitoring 64

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

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

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

Testsigma

FEBRUARY 9, 2022

The simplest of them is that open-source projects are those whose source code is available to read and reuse in other projects. You can just navigate to their repository, open the files, analyze the code, change according to yourself and reuse it as per your requirement. . A small list of some of the famous open-source technologies.

Open Source 52

Open Source Code Software Software 52

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

MARCH 17, 2020

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. The code may be easier to read and understand than the recursive CTE.

Servers 86

Servers Tuning Database Efficiency 86

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

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

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

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 116

Cloud Development AWS Servers 116

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

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. You need to be monitoring memory/disk/CPU utilization, network I/O, tempdb usage, waits, and other counters to know what is normal for the overall workload of those systems.

Tuning 67

Tuning Servers Database Best Practices 67

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

SQL Performance

OCTOBER 29, 2019

Borrowing and adapting code from a previous post, Examining the Performance Impact of an Adhoc Workload , we will first create two stored procedures. ORDER BY [ Short Query Text ] ; The query_hash was added in SQL Server 2008, and is based on the tree of the logical operators generated by the Query Optimizer for the statement text.

C++ 74

C++ Database Servers Tuning 74

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

The Agile Manager

FEBRUARY 28, 2017

Tool 1: Dolly the Sheep Companies that are heavily rule-based - think insurance - eagerly moved their business rules into code. It was easy to move into code; it's just as easy to move it back into human-readable format. There are people behind the systems to which we're bound today. Why not put them back on the payroll?

Strategy 40

Strategy Java Code Systems 40

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

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. The benefit of doing this is the entire site’s source code can live in Git.

Ecommerce 139

Ecommerce Website Government Internet 139

SQL Performance

APRIL 26, 2019

Do not expect the data to start flowing into the tables immediately; this will take time to make its way through the system. I used a block of code from existing SentryOne procedures to determine the rollup table for each counter. The code for this procedure is also attached ( dbo.Custom_ExportDataForDTUCalculator.sql_.zip

Azure 40

Azure Database Metrics Servers 40

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

The Netflix TechBlog

AUGUST 29, 2023

A brief history of IPC at Netflix Netflix was early to the cloud, particularly for large-scale companies: we began the migration in 2008, and by 2010, Netflix streaming was fully run on AWS. To improve availability, we designed systems where components could fail separately and avoid single points of failure.

Traffic 220

Traffic Latency Cloud C++ 220

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. What makes a complex system troublesome isn’t the sheer number of connections. And, often, to giving up.

Hardware 99

Hardware Storage Big Data Blockchain 99

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