SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Rewrite some or all of the stored data to match the new definition. Improvements in SQL Server 2016. You get these undocumented improvements for free.

Servers 63

Servers Database Testing Efficiency 63

Dynatrace

NOVEMBER 30, 2023

When we look at the combined tests above, the average server-side response time (measured as first byte time, or the amount of time it takes to get the first packet of data in response to a request) is 397 milliseconds. This type of issue would definitely affect conversion rates on a retail site.

Retail 221

Retail Social Media Performance Benchmarking 221

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

DZone

MARCH 24, 2021

We typically understand software testing by the everyday definition of the word: making sure a piece of software performs the way it is supposed to in a production-like environment. The first category would fall under integration testing, and you definitely need that. Or is there? If so, the database is updated.

Design 193

Design Testing Software Performance Database 193

Dynatrace

JULY 1, 2020

As Dynatrace is an all in one solution, you have multiple options to capture the needed data; you can use Real User Monitoring (RUM) properties , Server-side request attribute , and Log metrics. In the next step change, the UTM campaign parameter to also be a user action property by editing the definition as shown on the screenshot below.

Traffic 264

Traffic Analytics Metrics Servers 264

Scalegrid

FEBRUARY 15, 2024

Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Preparing SSL Certificates for MongoDB The SSL certificates are necessary for our MongoDB server to establish secure SSL/TLS communications.

Servers 130

Servers Best Practices Government Network 130

SQL Performance

JANUARY 20, 2022

All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. When I’m talking about any mechanism in SQL Server, I find there’s a chicken-and-egg problem where I need to use a word or phrase before I’ve explained it.

Servers 54

Servers Database Architecture Performance 54

SQL Performance

SEPTEMBER 29, 2021

A common requirement in ETL and various reporting scenarios is to quietly load a SQL Server staging table in the background, so users querying the data aren’t impacted by the writes and vice-versa. Refreshing Tables in SQL Server. SQL Server Partition Switching Example. definition , 500 ) FROM sys. session_id , o.

Servers 55

Servers Games Database Processing 55

Dynatrace

MAY 12, 2022

The title size of a tile has been moved from the dashboard definition to the dashboard metadata definition and included in the advanced settings UI for dashboards. Fixed an issue with “500 Internal Server Error” response of Anomaly detection – Disk events API. (APM-370270). Dashboards. Dynatrace API.

Tuning 192

Tuning Metrics Cloud Mobile 192

Dynatrace

FEBRUARY 14, 2022

Multiple Prometheus servers might be required, creating significant maintenance efforts. Alternatively, if you’re already using a Prometheus Server to gather data from your distributed systems, you can now seamlessly make this data work for you in Dynatrace as well—use your Prometheus server as the endpoint for scraping metrics.

Technology 217

Technology Technology Metrics Infrastructure 217

DZone

JANUARY 29, 2021

It is mainly the channel that links the client to the server, drives business procedures, and gives the services which give worth to users. Application Programming Interface acts as the center level between the database and presentation layer in the software development procedure. What is API Test?

Testing 207

Testing Programming Performance Database 207

Percona

JULY 25, 2023

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. The changes done by an uncommitted transaction can be flushed or written to the redo log by the server. So, given a table_id, how do you get the table schema/definition? For that, we have to use undo logs.

Cache 89

Cache Benchmarking Servers Design 89

Percona Community

NOVEMBER 29, 2023

After completing the deployment process, I noticed that the status of the Custom Resource Definition for Percona Server for MongoDB was still displaying as ‘initializing’ and two of our Pods remained in a Pending state. Last week, I embarked on the task of deploying our Percona Operator for MongoDB in Kubernetes.

Servers 77

Servers Processing 77

The Netflix TechBlog

JULY 30, 2019

Adoption As of writing this blog, Conductor orchestrates 600+ workflow definitions owned by 50+ teams across Netflix. The task definition parameter rateLimitFrequencyInSeconds sets the duration window, while rateLimitPerFrequency defines the number of tasks that can be scheduled in a duration window.

Lambda 189

Lambda Media Open Source Metrics 189

Dynatrace

MAY 17, 2023

When software runs in a monolithic stack on on-site servers, observability is manageable enough. For the HTTP request, we add the request headers we sent, as well as certain details from the response, such as the status code, the length of the response, and server information.

Metrics 180

Metrics Open Source Traffic Cache 180

Percona

SEPTEMBER 19, 2023

The effort has definitely paid off, as we can release shortly after upstream. To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. We’ve improved both the packaging build pipelines and tremendously reworked and improved the automation of our QA pipelines.

Availability 115

Availability Open Source Database Servers 115

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 200

Infrastructure Monitoring Virtualization Serverless 200

Percona

OCTOBER 13, 2023

sdi [root@mysql-test test_rocksdb]# Updating.sdi files.sdi files are typically updated when certain database operations are performed, such as Data Definition Language (DDL) operations on tables or using the “CHECK TABLE FOR UPGRADE” command. 1 mysql mysql 2.8K Sep 18 08:15 test_table_714.sdi sdi -rw-r --. 1 mysql mysql 1.0K

Storage 100

Storage Database Engineering Open Source 100

Tim Kadlec

APRIL 10, 2023

There was a comment on Twitter today from Rafael Gonzaga expressing disappointment in what he sees as a tendency to focus on the frontend solely in performance discussions, while neglecting the server-side aspect. Performance conversations were dominated by discussions around the server-side aspects of performance.

Performance 111

Performance Servers Mobile Metrics 111

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache 108

Cache Hardware Servers Benchmarking 108

Dynatrace

DECEMBER 15, 2022

Typically, these are streamed to a central syslog server. One option is to install OneAgent on that syslog server, which automatically discovers, instruments and sends the log data to the Dynatrace platform. Syslog is a popular standard for transporting and Ingesting log messages. Ingest AWS Fargate logs with Fluent Bit.

Strategy 180

Strategy AWS Open Source Transportation 180

Alex Podelko

AUGUST 18, 2019

Of course, more sophisticated tools may definitely do better job in creating a simple and intuitive interface (still providing a way to invoke more sophisticated functionality when needed). One of main challenges is definitely scripting and scripts fragility. But it doesn’t mean that we need tools with minimal functionality.

Performance Testing 243

Performance Testing Testing Performance Testing Tools 243

SQL Performance

JULY 14, 2021

When you create a view, SQL Server records metadata information in a number of catalog objects. It records some general information, which you can query via sys.views, the view definition which you can query via sys.sql_modules, column information which you can query via sys.columns, and more information is available through other objects.

Code 117

Code Database Servers Availability 117

Percona

NOVEMBER 7, 2023

How to read this book The best way to read this book is from the first page to the last, as the author builds on previous definitions and explanations. Buy this book if you are looking for a deeper understanding of how the PostgreSQL server really works, and you will not be disappointed.

Cache 93

Cache Servers Operating System Database 93

Dynatrace

AUGUST 16, 2019

By definition RESTful APIs should be stateless, meaning that each request should be individually validated for authentication/authorization by the receiving server. Note that the word “authentication” hasn’t yet been mentioned. And why are we referring to OAuth while discussing APIs? This is the key.

Monitoring 157

Monitoring Tuning Google Cloud 157

SQL Server According to Bob

FEBRUARY 9, 2020

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, ​​ logs, ​​ … This blog ​​ post ​​ focuses on connecting to the SQL Server BDC, ​​ some ​​ helpful ​​ log files ​​ and utility outputs.

Servers 40

Servers Database Availability Azure 40

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. Is MongoDB free to use?

Open Source 85

Open Source Programming Database Servers 85

The Netflix TechBlog

FEBRUARY 3, 2021

Instead, the schema gets generated at runtime based on definitions in code. Fitting into the GraphQL Server Ecosystem So how exactly does the DGS framework fit into the existing GraphQL ecosystem? When it comes to building GraphQL servers using JVM, there are both schema-first and code-first libraries available.

Open Source 246

Open Source Java Architecture Metrics 246

Smashing Magazine

NOVEMBER 8, 2018

Sharing Data Among Multiple Servers Through AWS S3. Sharing Data Among Multiple Servers Through AWS S3. After the file is uploaded to a server on step 1, the file must be available to whichever server handles the request for steps 2 and 3, which may or may not be the same one for step 1. Leonardo Losoviz.

AWS 44

AWS Servers Storage Cloud 44

Brendan Gregg

APRIL 8, 2022

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. In this case there's an orange tower (kernel code) that's unusual. The cause I've highlighted here.

Performance 100

Performance Virtualization Code Servers 100

Percona

MAY 9, 2023

Background story I recently worked with a company running a large four-shard MongoDB Enterprise Server database cluster on VMs on premises that decided to migrate to the Google Cloud Platform. This can be MongoDB Enterprise Server, MongoDB Community Edition, or Percona Server for MongoDB. Don’t start the server yet!

Storage 110

Storage Cloud Servers Google 110

Dynatrace

NOVEMBER 14, 2023

We’ll see lots of different types of impact versus one definitive impact [from generative AI],” she said. These would have the potential to largely eliminate manual intervention and lengthy processes to address regularly occurring incidents. However, Lipsig reminded the panel that SRE looks different across organizations. “We’ll

Best Practices 191

Best Practices Engineering DevOps Software Engineering 191

Percona

DECEMBER 29, 2022

The last is a good option when you can afford some downtime and desire to reuse the same server where your current instance is running. You might consider some extra steps, such as verifying the existence of gin/gist indexes, unknown datatypes, or planning the upgrade of any standby server using the rsync approach.

C++ 84

C++ Open Source Database Programming 84

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. But when I went back and looked at my database definition I was using a 5Gb transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. But when I went back and looked at my database definition I was using a 5Gb transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

SQL Performance

MARCH 15, 2021

This time around, I want to talk about a feature included with SQL Server client tools that we should not be using these days – not just because it is deprecated but, more importantly, because it has the potential to completely take a server down: SQL Server Profiler. Not too long ago, something like this happened to us.

Servers 64

Servers Azure Best Practices Monitoring 64

Scalegrid

JANUARY 20, 2020

If your application passes on the test dataset, it is definitely fit to deploy in production! Here are the two options we typically suggest: If the analytics job is running on the primary/master server, move it to a secondary/replica server. Data Analytics.

Analytics 185

Analytics Storage Database Systems 185