Dynatrace

FEBRUARY 14, 2022

Without any coding, these extensions make it easy to ingest data from these technologies and provide tailor-made analysis views and zero-config alerting. Multiple Prometheus servers might be required, creating significant maintenance efforts. Topology definition and entity extraction rules. Customizable dashboard.

Technology 210

Technology Technology Metrics Infrastructure 210

Dynatrace

MAY 17, 2023

When software runs in a monolithic stack on on-site servers, observability is manageable enough. While classic logging is an essential tool in debugging issues, it often lacks context and only provides snapshot information of one specific location in your code/application. Those are prime candidates for their own spans.

Metrics 174

Metrics Open Source Traffic Cache 174

Dynatrace

JULY 11, 2023

IBM Power servers enable customers to respond faster to business demands, protect data from core to cloud, and streamline insights and automation. It also detects new containers and injects OneAgent code modules into application pods. Dynatrace webhook server validates Dynakube definitions for correctness.

Architecture 164

Architecture Availability Infrastructure Metrics 164

Scalegrid

DECEMBER 19, 2019

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. How Does PgBouncer Work?

Cache 246

Cache Architecture Database Servers 246

CSS Wizardry

DECEMBER 9, 2023

All code examples are complete and correct. Connection overhead isn’t huge , but too many preconnect s that either a) aren’t critical, or b) don’t get used at all, is definitely wasteful. Further, opening and persisting connections has a CPU overhead on both the client and the server. When to Use crossorigin Okay.

Speed 234

Speed Network Analytics Availability 234

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2 Now that 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

Percona

APRIL 4, 2023

Those are a lot more common and may be in your table definitions, so your upgrade process will be harder. If you try to use a reserved word, the server will not explicitly admonish you that you are trying to use a reserved word. Instead, the server informs you that you have a syntax error. Yes, there is a workaround.

Open Source 116

Open Source Database Servers Scalability 116

The Netflix TechBlog

FEBRUARY 3, 2021

There are two different approaches to GraphQL development; schema-first and code-first development. The code in your service only implements this schema. With code-first development , you don’t have a schema file. Instead, the schema gets generated at runtime based on definitions in code.

Open Source 246

Open Source Java Architecture Metrics 246

Dynatrace

MARCH 17, 2021

A single OneAgent instance can handle the monitoring of many types of entities, including servers, applications, services, databases, and more. You want to optimize your Citrix landscape with insights into user load and screen latency per server? Your SAP instance is slow, and you don’t know which transactions or users are affected?

Metrics 164

Metrics Monitoring Network Technology 164

Percona

SEPTEMBER 6, 2023

Definitions The examples below use MySQL, but it is helpful to check their competition’s documentation to help explain what a functional index is. MySQL’s definition is a little more convoluted, stating that in MySQL versions 8.0.13 Well, there is always a drawback to having the server do something complicated for you.

Speed 82

Speed Virtualization Storage Open Source 82

SQL Performance

SEPTEMBER 8, 2021

Use the following code to create these tables in tempdb and populate them with some initial sample data: USE tempdb ; GO. To understand the circumstances where you would want to use the CHECK OPTION as part of a view’s definition, we’ll first examine what can happen when you don’t use it. Sample Data. DROP TABLE IF EXISTS dbo.

Servers 130

Servers Code Engineering Database 130

SQL Performance

JULY 14, 2021

The code that I’ll be using in this article can be executed in any database, but in my demos, I’ll be using TSQLV5—the same sample database that I used in previous articles. Use the following code to create a table called dbo.T1, and a view called dbo.V1 Use the following code to query the view: SELECT * FROM dbo. sql_modules.

Code 117

Code Database Servers Availability 117

Randon ASCII

AUGUST 30, 2020

Sometimes tracking down a bug is as simple as paying attention to server dashboards, spending a few minutes in a profiler, or looking at compiler warnings. Server CPU Surprise. A few years ago I spent a few weeks doing some memory investigations on live game servers. The first server process that I profiled was… odd.

Games 142

Games Servers Code Monitoring 142

Percona

NOVEMBER 7, 2023

The illustrations are clear, and there are many reference pointers to the documentation or source code where needed. If you are new to the internals of PostgreSQL, this book, along with the source code and some caffeine, should give you a great start on the subject. This is a great tool for learning the intricacies of PostgreSQL.

Cache 87

Cache Servers Operating System Database 87

Dynatrace

NOVEMBER 2, 2020

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. This shift requires infrastructure monitoring to ensure all your components work together across applications, operating systems, storage, servers, virtualization, and more.

Infrastructure 192

Infrastructure Monitoring Virtualization Serverless 192

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. looking out for MongoDB Inc.

Open Source 81

Open Source Programming Database Servers 81

Smashing Magazine

JULY 18, 2022

If you think that static rendering is limited to generic, public content that is the same for every user of your website, you should definitely read this article. Segmented Rendering is a new pattern for the Jamstack that lets you personalize content statically, without any sort of client-side rendering or per-request Server-Side Rendering.

Cache 114

Cache Website Energy Servers 114

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

AUGUST 30, 2023

If a PostgreSQL user wants to change these values, they need to recompile the PostgreSQL from the source code. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),

Database 102

Database Servers Open Source Tuning 102

tRPC

JANUARY 16, 2023

post ) throw new TRPCError ({ code : "NOT_FOUND" }); return post ; }) , ; 5 more.; post ) throw new TRPCError ({ code : "NOT_FOUND" }); return post ; }) , ; 5 more.; post ) throw new TRPCError ( { code : " NOT_FOUND " } ) ; return post ; } ) , ; 5 more.; any): Post | undefined (+1 overload)">find (( p ) => p. id ); if ( !

Servers 138

Servers Code Network Database 138

SQL Performance

FEBRUARY 10, 2021

Here’s the code to create the dummy table: DROP TABLE IF EXISTS dbo. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; And here’s the code with the definition of the dbo.GetNumsAlanCharlieItzikBatch function: CREATE OR ALTER FUNCTION dbo. It took this code 1:04 minutes to complete on my machine.

C++ 124

C++ Servers Testing Code 124

Brendan Gregg

APRIL 8, 2022

In this case there's an orange tower (kernel code) that's unusual. At Netflix, 10% of CPU time somewhere unexpected can be a large costly issue across thousands of server instances. of CPU, so it definitely was, and madvise() was calling zap_page_range() that was calling the faults. The cause I've highlighted here.

Performance 100

Performance Virtualization Code Servers 100

Testsigma

APRIL 4, 2022

Let’s look at the definition of quality to see how test automation isn’t quality assurance. One of the popular definitions of Quality is that it is “value” to someone “who” matters. Any fool can write code that a computer can understand. Good programmers write code that humans can understand.”. Martin Fowler.

Testing 95

Testing Open Source IoT Programming 95

SQL Performance

APRIL 14, 2021

Here’s the function’s definition: -- Helper dummy table. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; GO. -- Function definition. Use the following code to test the function with the variable assignment technique: DECLARE @n AS BIGINT ; SELECT @n = n FROM dbo. DROP TABLE IF EXISTS dbo.

C++ 112

C++ Servers Testing Code 112

SQL Performance

MAY 13, 2020

I just wanted to mention some use cases here to illustrate how important table expressions are in our T-SQL code, and why it's worthwhile to invest in understanding their fundamentals well. Here's the standard's definition for derived tables in the general sense: 4.15.3 In my examples I'll use a sample database called TSQLV5.

C++ 143

C++ Code Design Servers 143

Percona

MAY 15, 2023

Normally this solution requires a full code redesign and could be quite difficult to achieve when it is injected after the initial code architecture definition. In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. The POC Why this POC?

Traffic 123

Traffic Scalability Database Servers 123

High Scalability

FEBRUARY 1, 2022

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

MAY 4, 2022

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

Percona

AUGUST 3, 2023

The definition looks strange, but everything should be more clear, providing a real use case for this feature. Suppose you have SELECT * queries in your application code. As an experienced database developer, you should know that these kinds of queries should not exist in any production code. Definitively better.

Best Practices 77

Best Practices Open Source Code Engineering 77

High Scalability

JULY 18, 2022

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

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

High Scalability

AUGUST 24, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

DECEMBER 9, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

JUNE 10, 2022

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

SQL Performance

AUGUST 12, 2020

You can find it in the documentation of Microsoft SQL Server and Azure SQL Database. T-SQL supports it starting with SQL Server 2005. What’s different about the design of CTEs compared to derived tables is where in the code these three elements are located. It uses the term with list element to represent what T-SQL calls a CTE.

C++ 140

C++ Code Design Database 140

High Scalability

MARCH 18, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Scalability Infrastructure 100

High Scalability

MARCH 18, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. We believe the only way to maintain and scale our standards is to focus on quality code. Get started for free!

Education 100

Education DevOps Scalability Infrastructure 100