Dynatrace

OCTOBER 14, 2020

Upcoming Operating systems support changes. The following operating systems will no longer be supported starting 01 December 2020. Windows: Windows Server 1809. The following operating systems will no longer be supported starting 01 January 2021. Windows: Windows Server 2008. Added support for Go 1.15

Operating System 100

Operating System Java Google Servers 100

Dynatrace

FEBRUARY 10, 2021

set-server. set-system-logs-access-enabled. Upcoming Operating systems support changes. The following operating systems will no longer be supported starting 01 April 2020. Windows: Windows Server 1709. The following operating systems will no longer be supported starting 01 May 2020. Deprecated parameters.

Operating System 100

Operating System Servers Google Systems 100

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server. Installation and support of SSRS can be confusing.

Tuning 67

Tuning Servers Database Best Practices 67

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

Percona

APRIL 14, 2023

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Here are a few ways you can scale down and save: Audit your systems: Auditing your system for unused servers and eliminating those servers can reduce your cloud spend. If needed, you can spin up a backup.

Database 86

Database Serverless Tuning Cloud 86

Dynatrace

JULY 31, 2020

Current Operating systems support changes. The following operating systems will no longer be supported starting 01 August 2020. Windows: Windows Server 2008. Upcoming Operating systems support changes. The following operating systems will no longer be supported starting 01 November 2020. OpenJDK 12.

Operating System 124

Operating System Java Infrastructure Monitoring 124

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. I always check backups first when looking at a new system. Statistics.

Servers 49

Servers Azure Hardware Database 49

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 225

Traffic Latency Cloud C++ 225

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers. I also wrote about these topics in detail for my recent [Systems Performance 2nd Edition] book. Ford, et al., “TCP

Performance 121

Performance Latency Hardware Storage 121

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

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

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

Brendan Gregg

FEBRUARY 28, 2023

This talk originated from my updates to [Systems Performance 2nd Edition], and this was the first time I've given this talk in person! CXL in a way allows a custom memory controller to be added to a system, to increase memory capacity, bandwidth, and overall performance. Ford, et al., “TCP

Performance 103

Performance Latency Cache Virtualization 103

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.

Servers 64

Servers Azure Best Practices Monitoring 64

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

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. I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. How It Works: When is the FlushCache message added to SQL Server Error Log?

C++ 58

C++ Database Servers Storage 58

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers. I also wrote about these topics in detail for my recent [Systems Performance 2nd Edition] book. Ford, et al., “TCP

Performance 52

Performance Latency Hardware Storage 52

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. These desktop applications incremented the tooling an inch closer to the modern Jamstack content management systems of today.

Ecommerce 140

Ecommerce Website Government Internet 140

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

SQL Performance

MARCH 17, 2020

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. The optimizer chooses this plan without any hints on my system configuration because the estimated cost of the plan is below the cost threshold for parallelism.

Servers 86

Servers Tuning Database Efficiency 86

Brendan Gregg

FEBRUARY 28, 2023

This talk originated from my updates to Systems Performance 2nd Edition , and this was the first time I've given this talk in person! CXL in a way allows a custom memory controller to be added to a system, to increase memory capacity, bandwidth, and overall performance. Ford, et al., “TCP

Performance 52

Performance Latency Cache Virtualization 52

All Things Distributed

MAY 8, 2012

Werner Vogels weblog on building scalable and robust distributed systems. Amazon RDS for SQL Server. We introduced Amazon RDS for Oracle last year , and based on the demand from our Windows customers, are introducing Amazon RDS for SQL Server today. Expanding the Cloud for Windows Developers. Comments (). License Includedâ??

Cloud 106

Cloud Development AWS Servers 106

All Things Distributed

MARCH 26, 2018

March 26, 2008 doesn't have any delicious desserts associated with it, but that's the day when we launched Availability Zones for Amazon EC2. Powering the virtual instances and other resources that make up the AWS Cloud are real physical data centers with AWS servers in them.

AWS 121

AWS Latency Lambda Architecture 121

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. This seems like an oversight.

Database 98

Database Testing Storage Servers 98

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

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). ORDER BY ExecutionCount DESC ; Note: The sys.dm_exec_function_stats DMV was added in SQL Server 2016. Each option has pros and cons. query_hash AS [ query_hash ] , qs.

C++ 74

C++ Database Servers Tuning 74

All Things Distributed

APRIL 5, 2012

Werner Vogels weblog on building scalable and robust distributed systems. 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. Comments ().

Innovation 129

Innovation AWS Education Network 129

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

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. I work on the Windows version of Chrome, and one of my tasks is optimizing its build system, which requires doing a lot of test builds.

Processing 72

Processing Programming Code Cache 72

All Things Distributed

MARCH 24, 2011

Werner Vogels weblog on building scalable and robust distributed systems. The images from the 2008 TNW Conference have travelled around the world in my Animoto demo: This year TNW is showing that it is not just a conference for talkers but also for builders by organizing a massive Hackaton in the two days running up to the conference.

AWS 84

AWS Internet Internet Storage 84

Testsigma

FEBRUARY 9, 2022

Wikipedia states that in a 2008 report, open-source projects were able to save over USD 60 billion for the customers. Although remember that not every project on GitHub is open-source as it serves as a version control system repository. Reach out to our Discord server if you’d like some help! Join Discord.

Open Source 52

Open Source Code Software Software 52

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

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

All Things Distributed

APRIL 19, 2010

Werner Vogels weblog on building scalable and robust distributed systems. Here are the laurels given by the editors: Debuting in November 2008, Amazons entry into the CDN market quickly became a major player. No Server Required - Jekyll & Amazon S3. All Things Distributed. Amazon Cloudfront is Streaming Media 2010 Editors pick.

Media 60

Media AWS Storage Big Data 60

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 75

Virtualization AWS Engineering Hardware 75

Randon ASCII

FEBRUARY 25, 2018

The underlying bug is that if a program writes a PE file (EXE or DLL) using memory mapped file I/O and if that program is then immediately executed (or loaded with LoadLibrary or LoadLibraryEx), and if the system is under very heavy disk I/O load, then a necessary file-buffer flush may fail.

Programming 79

Programming Hardware Cache Code 79

Percona

JANUARY 14, 2019

In a partitioned massively parallel database system, the storage format and sorting algorithm may not be optimized for that operation as we are reading multiple partitions in parallel. ClickHouse is a great massively parallel analytical system. webkit','twitter','teacher','android','itunes'] ? ? Conclusion.

Database 40

Database Analytics Blockchain Healthcare 40