SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This clause allows you to shorten your code by avoiding the repetition of identical parts of your window specifications.

Servers 145

Servers C++ Code Database 145

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

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

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

Dynatrace

JUNE 12, 2020

Besides being the most popular web server back end, PHP is also commonly used for developing microservices, shell applications, high-scale back ends, and for scheduling automated tasks. Dynatrace has long provided automatic code-level performance monitoring for PHP applications with OneAgent. Support for request attributes. to PHP 7.3.

Code 133

Code Monitoring Database Metrics 133

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 206

Java Servers Code Software 206

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

SQL Shack

SEPTEMBER 6, 2021

In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled. Introduction SQL Server Stored procedures are the make-ready T-SQL codes that can be executed again and again by the database users to perform data manipulation commands and data definition commands.

Servers 90

Servers Database Code Performance 90

Percona

MARCH 13, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Percona Server for MySQL 5.7.41-44 44 On March 2, 2023, Percona Server for MySQL 5.7.41-44 Percona Server for MongoDB 4.2.24-24

Servers 78

Servers Open Source Database Software 78

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

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 73

Servers Database Testing Open Source 73

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 Database Servers 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

NOVEMBER 3, 2023

already address SNMP, WMI, SQL databases, and Prometheus technologies, serving the monitoring needs of hundreds of Dynatrace customers. focused on technology coverage, building on the flexibility of JMX for Java and Python-based coded extensions for everything else. This includes Python-coded extensions, which are also sandboxed.

Technology 247

Technology Technology Scalability Availability 247

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

Dynatrace

JULY 1, 2020

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. The most important part s are the impact s on users and longest-running transaction codes , as these are the indicators for the overall health of module performance.

Database 244

Database Servers Monitoring Code 244

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 198

Open Source Artificial Intelligence Internet Internet 198

SQL Shack

FEBRUARY 3, 2022

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

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 We recommend checking out our products for Percona Server for MongoDB , Percona Backup for MongoDB , and Percona Operator for MongoDB. PSMDB), the best practice to create an index was doing it in a rolling manner. Starting from PSMDB 4.4, internal", "port" : 27017, "version" : "4.4.22-21",

Servers 79

Servers C++ Storage Best Practices 79

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 187

Artificial Intelligence Innovation Servers Database 187

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 293

Games Monitoring Infrastructure DevOps 293

DZone

JANUARY 29, 2021

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

Testing 207

Testing Programming Performance Database 207

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 120

Monitoring Infrastructure Open Source AWS 120

Dynatrace

OCTOBER 23, 2023

Therefore, they experience how the application code functions and how the application operations depend on the underlying hardware resources and the operating system managed by Hyper-V. Observability challenges with Hyper-V End-users don’t have direct interaction with Hyper-V.

Efficiency 214

Efficiency Virtualization Hardware Performance 214

Percona Community

MARCH 19, 2023

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. We only used Composer packages to work with MongoDB.

Servers 52

Servers Database Code Development 52

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. Application servers use connection pools to maintain connections with the databases that they communicate with.

Traffic 138

Traffic Performance Database Metrics 138

Percona

JUNE 23, 2023

Both MySQL and PostgreSQL do the basics very well From a high level, one relational database management system is pretty much like every other relational database management system. It does not follow the SQL Standard as closely as other databases, and some useful functions such as MERGE() are missing.

Database 118

Database Transportation Servers Cloud 118

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 164

Traffic Java Network DevOps 164

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.

Tuning 67

Tuning Servers Database Best Practices 67

Percona

DECEMBER 13, 2023

Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. These error codes can be specified in either symbolic or numeric form. By default, log_error_suppression_list is set to empty.

Database 95

Database Open Source Tuning Traffic 95

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 240

Java Internet Internet Database 240

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

APRIL 5, 2022

That portion of the log hasn’t yet been sent to an asynchronous database mirror or availability group replica. SQL Server tracks the start of the oldest uncommitted (active) transaction, and this LSN is persisted on disk every time a checkpoint operation occurs. Figure 2: Activity moves through the transaction log.

Servers 55

Servers Database Virtualization Processing 55

Smashing Magazine

NOVEMBER 2, 2021

Creating A Magento PWA: Customizing Themes vs. Coding From Scratch. Creating A Magento PWA: Customizing Themes vs. Coding From Scratch. One of the reasons for that is because a PWA has the same code base. So unlike the case with native applications, the progressive web app needs to be coded only once. Alex Husar.

Code 74

Code Cache Retail Mobile 74

Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages? In this case, THP is enabled.

Database 89

Database Servers Open Source C++ 89

Dynatrace

JANUARY 19, 2020

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. No ABAP code instrumentation or injection is performed.

Monitoring 154

Monitoring Best Practices Infrastructure Servers 154