SQL Performance

SEPTEMBER 17, 2019

SSRS 2008 brought that component into the reporting service module. Caches of report results are stored in the ReportServerTempDB database and I/O performance can become an issue here. To tune for a slow report, that usually means you need to create indexes for that specific report or tune the code within the report. Conclusion.

Tuning 67

Tuning Servers Database Best Practices 67

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

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

Dean Hume

APRIL 24, 2018

CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). In this article, I’ve focussed on service worker caching, but other forms of caching can help performance and CPU usage too! I already had Google Analytics installed, so I added the following code to each page.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). In this article, I’ve focussed on service worker caching, but other forms of caching can help performance and CPU usage too! I already had Google Analytics installed, so I added the following code to each page.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). In this article, I’ve focussed on service worker caching, but other forms of caching can help performance and CPU usage too! I already had Google Analytics installed, so I added the following code to each page.

Energy 40

Energy Cache Traffic Website 40

SQL Performance

MAY 1, 2020

If you have instances running older versions like SQL Server 2008 R2 (I found one!), You could also not be lazy like me, and run the code in Powershell instead of a CMS query window, where you could easily filter out databases given any number of properties before ever hitting compile-time issues.

C++ 58

C++ Database Servers Storage 58

All Things Distributed

MAY 8, 2012

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. Amazon RDS currently supports SQL Server 2008 R2 and plans to add support for SQL Server 2012 later this year.

Cloud 116

Cloud Development AWS Servers 116

Dynatrace

JULY 24, 2023

The evolution of DevOps automation Since the concept of DevOps emerged around 2007 and 2008 in response to pain points with Agile development, DevOps automation has been continuously evolving. For example, consider an e-commerce website that automatically sends personalized discount codes to customers who abandon their shopping carts.

DevOps 222

DevOps Traffic Efficiency Servers 222

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 ). The code for this procedure is also attached ( dbo.Custom_ExportDataForDTUCalculator.sql_.zip

Azure 40

Azure Database Metrics Servers 40

Randon ASCII

FEBRUARY 11, 2018

In hindsight it’s obvious that these zombies were caused by a trivial user-space coding bug. If you do care – if you want to wait for the process to quit – WaitForSingleObject(hProcess, INFINITE); – or query its exit code – GetExitCodeProcess(hProcess, &exitCode); – then you need to remember to close the handles after that.

Processing 72

Processing Programming Code Cache 72

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.

Strategy 40

Strategy Java Code Systems 40

The Agile Manager

OCTOBER 31, 2013

The other is that it is primarily concerned with compliance with protocols, procedures or regulations, such as ITIL or Sarbanes-Oxley or even coding and architectural standards. As the financial crisis hit in 2008, it became glaringly obvious that few bank directors had any detailed understanding of either banking or risk.)

Government 58

Government Strategy Technology Technology 58

Dynatrace

SEPTEMBER 26, 2019

They also find ways to bake security into our DNA and culture – just as we always had performance at the core of everything we do and deliver. As far as I remember, Atlassian’s JIRA had already been used back when I started at Dynatrace in 2008. I have a new idea. 1 Let’s track it with JIRA.

Education 35

Education Programming Processing DevOps 35

O'Reilly Software

OCTOBER 23, 2018

In 2008 or so, when data scientist emerged as a job title, it was widely ridiculed as a nonjob: the thought that people who just worked with data could be scientists, or employ the rigors of their time-honored methods, was literally laughable in many circles. Adding security reduces performance. Three concerns of the architect.

Strategy 100

Strategy Architecture Technology Technology 100

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 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. This might have a performance effect for unencrypted databases on the same instance of SQL Server. I then verified my findings in the source code. First, let’s explain the mystery in more detail.

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. Piecing together a website using a WYSIWYG editor and seeing the code it generated was a fascinating and educational experience that sparked an initial interest in web design. MovableType really was before its time.

Ecommerce 139

Ecommerce Website Government Internet 139

John McCalpin

APRIL 2, 2020

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). Building separate models for each of the benchmarks was required to get the correct asymptotic properties.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

The Agile Manager

JANUARY 14, 2009

Functionality that is coded and tested is the best measure of "results" that we have. The projected rate of progress through the Stories - that is, how quickly the team is expected to render business needs code complete - is rooted in a simple formula that includes capacity, distraction management, and estimate weight (complexity, etc.)

Metrics 40

Metrics Code Software Software 40

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.

Network 40

Network Servers Processing Software Engineering 40

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. A quirk of the implementation means no check is performed when the count of held locks is exactly 1250. The code in HeapDataSetSession::EscalateLocks next calls sqlmin!IsEscalationPossible

Database 98

Database Storage Testing Servers 98

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

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. With our focused investment in performance and scale, simply upgrading to SQL 2016 could bring 25% performance improvement. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

Alex Russell

AUGUST 30, 2021

Anyone who cares to download and fork the code can do so. From 2008 to 2013, the Chrome project was based on WebKit, and a growing team of Chrome engineers began to contribute heavily "upstream." The signal to parties who might contribute code for these features could scarcely be clearer: your patch is unlikely to be accepted.

Engineering 98

Engineering Open Source Website Operating System 98

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

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. There are two main code paths that can set DMLRequestSort to true for index inserts. Fast Load Context.

Cache 64

Cache Testing Servers Code 64

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. Single-threaded CPU performance is the one relative weak point of the AMD EPYC 7742 processor. In this case, 6,716.88/64 64 equals 104.95 If we divide 7012.53

Servers 52

Servers Benchmarking Virtualization Architecture 52

Brendan Gregg

SEPTEMBER 5, 2017

It uses a Solaris Porting Layer (SPL) to provide a Solaris-kernel interface on Linux, so that unmodified ZFS code can execute. There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

The Agile Manager

JUNE 29, 2008

This content is derived from material presented in a ThoughtWorks-sponsored webcast in June 2008. Changing the way work is performed is no simple task. A two minute video presentation of this material is available. A complete webinar re-broadcast, including audience Q&A, will be available soon.

Code 45

Code Availability Processing Performance 45