Dynatrace

FEBRUARY 1, 2020

Such web resources have two things in common: Their requests never hit your data center, hence any failed requests don’t show up in your web server logs. Their performance and any errors they cause can have a massive impact on your bottom line. Or, learn more about this new capability by watching this Performance Clinic video.

Tuning 186

Tuning Monitoring Network Best Practices 186

SQL Server According to Bob

JUNE 22, 2016

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Instead the design of CMemThread was updated.

Servers 40

Servers Azure Software Engineering Design 40

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

MARCH 15, 2021

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. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects are also deprecated.

Servers 64

Servers Azure Best Practices Monitoring 64

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Performance is competitive at around 15ms. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

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. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

MachMetrics

JANUARY 13, 2021

Founded in 2008, Catchpoint states that its mission is to “help companies advance the digital experience of their customers and employees” They offer a suite of products such as synthetic monitoring, real user monitoring, endpoint monitoring, and network insights. Who is Catchpoint? What does this mean for WebPageTest?

Open Source 64

Open Source Network Speed Engineering 64

SQL Performance

MAY 1, 2020

In a recent tip , I described a scenario where a SQL Server 2016 instance seemed to be struggling with checkpoint times. A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions. How It Works: When is the FlushCache message added to SQL Server Error Log? writes/sec average throughput: 46.96

C++ 58

C++ Database Servers Storage 58

SQL Server According to Bob

JULY 12, 2016

Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements. For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. This is behavior is unchanged in SQL Server 2016.

Servers 40

Servers Design Engineering Database 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.

C++ 74

C++ Database Servers Tuning 74

Dean Hume

APRIL 24, 2018

As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. CPU Utilization and Power Consumption (Source: Blackburn 2008).

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. CPU Utilization and Power Consumption (Source: Blackburn 2008).

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. CPU Utilization and Power Consumption (Source: Blackburn 2008).

Energy 40

Energy Cache Traffic Website 40

All Things Distributed

MAY 8, 2012

s announcement of Amazon RDS for Microsoft SQL Server and.NET support for AWS Elastic Beanstalk marks another important step in our commitment to increase the flexibility for AWS customers to use the choice of operating system, programming language, development tools and database software that meet their application requirements. Comments ().

Cloud 116

Cloud Development AWS Servers 116

SQL Performance

MAY 16, 2019

Achieving minimal logging using INSERT.SELECT into an empty clustered index target is not quite as simple as described in the Data Performance Loading Guide. The Data Loading Performance Guide contains a high-level summary of the conditions required for minimal logging into clustered tables: This post is concerned with the top row only.

Cache 67

Cache Servers Testing Storage 67

All Things Distributed

APRIL 5, 2012

Troy: We moved our service from internal servers to AWS. Jack: Since our launch in late 2008, weve grown to over 6 million teachers and students globally primarily through word of mouth of teachers who have shared Edmodo with each other. How are your users adopting and responding to your service? What did you find unique about RDS?

Innovation 149

Innovation AWS Education Network 149

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 default is -1, which means copy all watched SQL Servers.

Azure 40

Azure Database Metrics Servers 40

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 instance, in the case of poor performance, you can seamlessly toggle a feature flag and mitigate any detrimental effects.

DevOps 222

DevOps Traffic Efficiency Servers 222

SQL Server According to Bob

JANUARY 11, 2020

Using SQL Server’s SNITrace to Troubleshoot Networking Issues In the process of tracking down a few TCP 10054 issues (highlighted here: ​​ [link] ) I ​​ also ​​ used ​​ the ​​ SNITrace ​​ (SNI Trace) ​​ capabilities.

Network 40

Network Servers Processing Software Engineering 40

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. A Windows kernel file buffer bug from Server 2008 R2 to Windows 10. So, I went to Task Manager’s Details tab, added the Handles column, and sorted by it.

Processing 72

Processing Programming Code Cache 72

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

Smashing Magazine

AUGUST 20, 2021

Yet, for all these technological developments, it’s interesting that many of us are still serving sites in the same way Tim did with the very first website — a web server serving static website files. MovableType was one of the first static site generators on the market, although that term wouldn’t become popular until 2008.

Ecommerce 139

Ecommerce Website Government Internet 139

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 is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

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. The SQL Server lock manager keeps track of the number of locks held by the current transaction. Testing environment. Well, almost. The sqlmin!lck_lockInternal

Database 98

Database Storage Testing Servers 98

O'Reilly

JULY 25, 2023

And if I switch tabs to view a paper from 2008, then a song from 2008 could start up. To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022.

Programming 98

Programming Code Design Benchmarking 98

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link]. Follow-up.

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. } ; We now have correct lengths for the column definitions, and we won't be passing them as LOBs over TDS to SQL Server.

Servers 55

Servers Azure Hardware Network 55

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016.

Cache 64

Cache Testing Servers Code 64

Brendan Gregg

SEPTEMBER 5, 2017

Nowadays, there are three built-in tracers that you should know about: - **ftrace**: since 2008, this serves many tracing needs, and has been enhanced recently with hist triggers for custom histograms. As a performance engineer who does kernel tracing, I find the lack of an ID I can trace in the kernel to be pretty annoying.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Randon ASCII

FEBRUARY 25, 2018

Either way, whether we fixed two or three separate bugs, Chrome’s builds are much more reliable now and I can go back to doing build-performance testing without hitting failures. Or did we just get lucky or oblivious? Twitter announcement is here , hacker news discussion is here , and reddit discussion is here.

Programming 79

Programming Hardware Cache Code 79

Percona

JANUARY 14, 2019

With the latest ClickHouse version, all of these features are available, but some of them may not perform fast enough. Updating a single message in the past (e.g. in the case of messages, we may need to update the final price; in the case of comments, we may need to upvote or downvote a comment). Deleting messages. Text search.

Database 40

Database Analytics Blockchain Healthcare 40