SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here.

Servers 142

Servers Testing C++ Code 142

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. What is a stored procedure?

Benchmarking 62

Benchmarking Database Network C++ 62

HammerDB

MARCH 25, 2023

Docker build, example CLI scripts were added to build and run the TPROC-C workload in the Tcl language. This post will give an overview of the example CLI scripts that you can run directly or use as a template to write your own. Copy Code Copied Use a different Browser ~/HammerDB-4.7$ With the HammerDB v4.5 In HammerDB v4.6

C++ 83

C++ Virtualization Benchmarking Database 83

Dynatrace

JANUARY 23, 2024

In May 2023 the critical vulnerability CVE-2020-36641 in the Java library aXMLRPC was published in the National Vulnerability Database (NVD). XML external entity (XXE) exploit The aXMLRPC library allows its users to connect to a server and perform RPC calls using the XML-RPC protocol over HTTP.

Java 211

Java Servers Code Software 211

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. People assume that because the code is public, attackers can have at it and easily wreak havoc.

Open Source 110

Open Source Database Software Software 110

Percona Community

MARCH 19, 2023

We learn how to work with HTTP requests in PHP and make API requests using the GitHub API as an example. We’ll get the data from the API and save it to the database. In the previous article, we developed a simple application that connects to the MongoDB database (Percona Server for MongoDB) and writes documents in a loop.

Servers 52

Servers Database Code Development 52

Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. 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.

Database 80

Database Serverless Tuning Cloud 80

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health.

Metrics 130

Metrics Monitoring Latency Cache 130

Scalegrid

SEPTEMBER 18, 2020

One option is purchasing your own CA-signed SSL certificates and configuring them on the MongoDB server. If your application connects to the production database over a public network, do reach out to support@scalegrid.io Note: All the code samples have been tested using MongoDB Driver v2.8.1 Else the code samples will not work.

C++ 244

C++ Programming Servers Database 244

Scalegrid

DECEMBER 14, 2023

How the MongoDB timeout is set up can significantly affect your application’s performance, no matter if you are an experienced MongoDB user or just starting with NoSQL databases. Typical applications are interacting with different database servers based on the business logic.

Java 130

Java Network Servers Database 130

Dynatrace

MAY 17, 2023

However, this method limited us to instrumenting the code manually and collecting specific sets of data we defined upfront. It is available for the major OS and cloud platforms (for example, Windows, Linux, Solaris, AWS, Azure, and more) and only requires the deployment of a single service to monitor its environment. What is OneAgent?

Metrics 176

Metrics Monitoring Database Network 176

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Dynatrace

JULY 11, 2023

When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database. For example, the LEMURLOOR web shell Cl0p used during the Memorial Day attacks used a backdoor called human2.aspx.

Database 163

Database Government Games Servers 163

Dynatrace

JULY 1, 2020

F or example dashboarding, SAPGUI user experience anal ytic s , and problem detection. . The SAP Module Dashboard details the experience of the users and transaction code executions for each specific area , with t op transactions and users displayed. L et ’s delve into how each of these works. Dashboarding . User Session Details.

Database 245

Database Servers Monitoring Code 245

Dynatrace

MAY 27, 2022

At Dynatrace Perform 2022 , David Walker, a Lockheed Martin Fellow, and William Swofford, a full-stack engineer at Lockheed Martin, discuss how to create a self-diagnosing and self-healing IT server environment using this AIOps combination for auto-baselining, auto-remediation, monitoring as code, and more.

Artificial Intelligence 192

Artificial Intelligence Innovation Servers Database 192

Percona

JUNE 1, 2023

In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. the same does not happen with MariaDB, which from a specific version, we could say in some way, distanced itself from MySQL and Percona Server for MySQL. Upload that dump to the Percona Server for MySQL using myloader.

Servers 71

Servers Database Testing Open Source 71

Dynatrace

AUGUST 18, 2022

Years later, a few configuration management solutions came into play that required heavy amounts of coding, but proved that the industry was moving toward compartmentalized automation solutions. These evaluations that I hard-coded into a script were now embedded into the back-end of Ansible’s modular approach.

Games 296

Games Monitoring Infrastructure DevOps 296

Dynatrace

MARCH 22, 2023

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. For example, ensuring software stacks don’t use default accounts or passwords, error handling doesn’t reveal sensitive information, and application server frameworks use secure settings.

Open Source 203

Open Source Artificial Intelligence Internet Internet 203

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security.

Database 130

Database Servers Storage Network 130

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool? pgAdmin uses too many resources.

Open Source 262

Open Source Database Azure Cloud 262

The Netflix TechBlog

SEPTEMBER 3, 2021

link] Example: Netflix Studio Production Money Heist (La casa de papel) / Netflix Let’s assume there is a Production service that manages Studio Content Productions (in the film and TV industry, the term production refers to the process of making a movie, not the environment to run a software). Field names are not included.

Design 245

Design Java Efficiency Code 245

SQL Shack

FEBRUARY 3, 2022

In this article, we will go through the details of the trivial execution plans and we will also tackle some examples about the trivial plans to explore effects on query performance. Introduction SQL is a non-procedural programing language that means the database users only code what they want to do and they can’t describe how […].

Servers 83

Servers Programming Database Code 83

Dynatrace

DECEMBER 9, 2020

Most applications communicate with databases to, for example, pull a catalog entry or submit a new record when an order is placed. To achieve this, there must be a healthy connection between the application and the database. Automatically identify connection leaks in your application code. Dynatrace news.

Traffic 139

Traffic Performance Database Metrics 139

Dynatrace

AUGUST 18, 2022

According to the 2022 CISO Research Report , only 25% of respondents’ security teams “can access a fully accurate, continuously updated report of every application and code library running in production in real-time.” Undetected, the compromised code could allow attackers to access data they’re not authorized to have.

Traffic 168

Traffic Java Network DevOps 168

Dynatrace

NOVEMBER 18, 2021

With PurePath ® distributed tracing and analysis technology at the code level, Dynatrace already provides the deepest possible insights into every transaction. Automatic contextualization of log data works out-of-the-box for popular languages like Java,NET, Node.js, Go, and PHP, as well as for NGiNX and Apache Web servers.

Analytics 229

Analytics Cloud Java Serverless 229

Testsigma

FEBRUARY 3, 2021

Example: Let’s take an example of an e-commerce mobile app. Unit Testing – Developers execute unit tests for the smallest unit of code, whenever they commit new code in the code repository. Example: Here, we test the integration of two or more modules like- from cart to make a payment module.

Mobile 82

Mobile Testing Hardware C++ 82

Dynatrace

JULY 7, 2022

One large team generally maintains the source code in a centralized repository that’s visible to all engineers, who commit their code in a single build. These teams typically use standardized tools and follow a sequential process to build, review, test, deliver, and deploy code. Common problems with monolithic architecture.

Architecture 206

Architecture Serverless Azure Programming 206

Percona

FEBRUARY 14, 2023

Recently, we released Percona Monitoring and Management 2.34 (PMM) which includes upgrades for backup and Database as a Service (DBaaS) features, and we are seeking ways to simplify PMM deployment. Percona Monitoring and Management is a best-of-breed open source database monitoring solution.

Monitoring 119

Monitoring Infrastructure Open Source AWS 119

The Morning Paper

MARCH 3, 2020

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. NSDI’20. This paper is a real joy to read. a majority of nodes).

Database 106

Database AWS Network Design 106

Dynatrace

NOVEMBER 16, 2021

It records real-time metrics in a time series database with flexible queries and real-time alerting. It then compresses and stores them in a time-series database on a regular cadence. This means Dynatrace isn’t collecting the metrics on the Prometheus server, but directly at the source of truth – the exporters.

Metrics 206

Metrics Infrastructure Open Source Database 206

Dynatrace

DECEMBER 12, 2021

The National Vulnerability Database describes the exploit here. It results in remote code execution (RCE) by submitting a specially composed request. Sensitive Data Access – Do the vulnerable Java processes access critical databases or file systems in the environment? Application List – Which applications use these libraries?

Java 242

Java Internet Internet Database 242

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Scalegrid

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. Pagination Example Let’s walk through an example to see the different ways to achieve MongoDB pagination. So in effect, our page size is 10. The result?

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. That issue is slow server response times. There’s very little browser optimisations can do to improve a page that is simply slow to build on the server. Encompassed in that wait time is everything the server needs to do to build the page.

Servers 87

Servers Performance Metrics Database 87

SQL Performance

FEBRUARY 1, 2022

This is done to make managing operations in the transaction log easier for the log manager in SQL Server. You can’t specify how many VLFs are created by SQL Server when the database is first created or the log file automatically grows, but you can influence it. I explained an example of the difference in this blog post.

Architecture 53

Architecture Servers Virtualization Database 53

SQL Performance

APRIL 5, 2022

Examples of reasons why log records may be required include: There’s a long-running transaction the log records are part of, so they cannot be released until the transaction has committed or has finished rolling back. That portion of the log hasn’t yet been sent to an asynchronous database mirror or availability group replica.

Servers 55

Servers Database Virtualization Processing 55

Percona

AUGUST 30, 2023

If a PostgreSQL user wants to change these values, they need to recompile the PostgreSQL from the source code. For example, the wal_segment_size , which determines the WAL segment file, is such a parameter. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database.

Database 99

Database Servers Open Source Tuning 99