HammerDB

OCTOBER 24, 2023

by @krithikasatish and @JoshInnis to provide accelerated load performance for both SQL Server TPROC-C and TPROC-H schemas. This earlier functionality has the advantage that there are no intermediate staging files required, and data is inserted into the database with multi-row inserts as soon as it is created.

Servers 62

Servers C++ Benchmarking Virtualization 62

SQL Shack

SEPTEMBER 29, 2020

In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups. SQL Server PolyBase Introduction It is a new feature from SQL Server 2016 to query the relational and non-relational database using data virtualization techniques.

Servers 99

Servers Availability Virtualization Database 99

SQL Shack

AUGUST 28, 2020

In this 15th article of SQL Server Always On Availability Groups series, we will cover Transparent Data Encryption (TDE) for AG databases. Introduction In the previous articles of SQL Server Always On series, we explored the following topics so far.

Availability 94

Availability Servers Virtualization Database 94

Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

Dynatrace

NOVEMBER 3, 2023

already address SNMP, WMI, SQL databases, and Prometheus technologies, serving the monitoring needs of hundreds of Dynatrace customers. Extensions can monitor virtually any type of technology in your environment. Apache Kafka Server (JMX) The Apache Kafka extension offers valuable insights into your Kafka server.

Technology 248

Technology Technology Scalability Availability 248

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. We’ve seen the IT infrastructure landscape evolve rapidly over the past few years. What is infrastructure monitoring? .

Infrastructure 202

Infrastructure Monitoring Virtualization Serverless 202

Scalegrid

JUNE 6, 2019

June 6, 2019 – ScaleGrid , the Database-as-a-Service (DBaaS) leader in the SQL and NoSQL space, has announced the expansion of their fully managed MySQL Hosting services to support Amazon Web Services (AWS) cloud. PALO ALTO, Calif.,

AWS 191

AWS Cloud Open Source Virtualization 191

Percona

DECEMBER 20, 2023

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. OS maintains a huge list of allocated and free pages to make slow but reliable address translation from virtual to physical.

C++ 95

C++ Virtualization Benchmarking Database 95

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 85

Database Servers Open Source C++ 85

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. virtual = 2.2G virtual = 2.2G

Cache 96

Cache Database Virtualization Servers 96

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

Dynatrace

JULY 6, 2020

In addition to providing visibility for core Azure services like virtual machines, load balancers, databases, and application services, we’re happy to announce support for the following 10 new Azure services, with many more to come soon: Virtual Machines (classic ones). Azure Virtual Network Gateways. Azure Batch.

Azure 148

Azure Cloud Big Data Virtualization 148

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. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 154

Monitoring Best Practices Infrastructure Servers 154

SQL Performance

APRIL 5, 2022

As this post is chiefly concerned with the Virtual Log Files (VLFs) I described, I recommend you read the second part before continuing. That portion of the log hasn’t yet been sent to an asynchronous database mirror or availability group replica. When all is well, the transaction log will endlessly loop, reusing the existing VLFs.

Servers 55

Servers Database Virtualization Processing 55

Scalegrid

OCTOBER 2, 2019

October 2, 2019 – ScaleGrid, a rapidly growing leader in the Database-as-a-Service (DBaaS) space, has just launched their new fully managed Hosting on Azure for Redis™ service. Redis™, the #1 key-value store and top 10 database in the world, has grown by over 300% in popularity over that past 5 years, per the DB-Engines knowledge base.

Azure 100

Azure Availability Open Source Virtualization 100

Dynatrace

APRIL 15, 2022

Organizations hit this cloud operations wall when replacing static virtual machines with dynamic container orchestration and expanding to multicloud environments. The agency executed one of the largest email migrations from on-premises Exchange servers to Microsoft Office 365 — moving almost 480,000 mailboxes to the cloud.

Cloud 179

Cloud Infrastructure Innovation Monitoring 179

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 95

Monitoring Scalability Cache Database 95

Percona

JUNE 2, 2023

WordPress also benefited from and popularized MySQL, introducing the LAMP stack – and open source – to an audience that might never have touched a database before or had any intro to open source. MySQL was the database for phpWebLog, for example, way back in 2000. MySQL was founded in 1995 and went open source in 2000.

Open Source 92

Open Source Traffic Tuning Database 92

HammerDB

FEBRUARY 26, 2024

Many of the HammerDB TPROC-C workloads have included features to prevent the database doing maintenance tasks for the previous run whilst another run is taking place. This is particularly important when running automated workloads back-back to generate a performance profile for a progressively increasing number of virtual users.

C++ 62

C++ Cache Database Virtualization 62

Dynatrace

MAY 31, 2019

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. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 160

Monitoring Best Practices Infrastructure Programming 160

HammerDB

APRIL 27, 2021

One of the first things you will want to do is make sure that we can access the 3rd party driver libraries for the database that we want to use. In this example we are using SQL Server so the message shows that everything is in order and we can proceed with running tests. Selecting a database. Select a database.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

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

HammerDB

MARCH 25, 2023

When you list the HammerDB directory you can now see a directory called “scripts” This directory contains CLI scripts to build, run, delete and query TPROC-C and TPROC-H workloads against all databases. If HammerDB is running on a separate system from the database under test then you should modify this value accordingly.

C++ 83

C++ Virtualization Benchmarking Database 83

Testlodge

APRIL 14, 2021

The three-tier application should have client, server, and database layer, and each part of it needs to work well across the various platforms. The server layer will be able to work with Windows Server and Ubuntu Server. Assume that the client (front-end) will be able to support Windows 7, Windows 10, and Linux.

Testing 89

Testing Hardware Virtualization Operating System 89

HammerDB

DECEMBER 1, 2022

For example on Windows an example of opening a new database. Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB If disabled, the SQLite repository database is not opened, and it is not possible to query any jobs related data.

Virtualization 57

Virtualization C++ Storage Database 57

Dynatrace

JULY 2, 2020

With Dynatrace being able to handle thousands of connected agents, services, containers, servers, and individual user tracking, synthetic monitoring measurements and ingesting external data monitoring becomes a breeze . The complexity of cloud-based or hybrid IT environments and application landscapes continues to grow. Food for thought.

Virtualization 183

Virtualization Monitoring Servers Architecture 183

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.

Open Source 79

Open Source Programming Database Servers 79

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

HammerDB

NOVEMBER 30, 2022

Vuser 1:1 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 39945 NOPM from 92893 SQL Server TPM Vuser 1:Gathering timing data from Active Virtual Users. Running this script returns output as follows using the Python loop to drive HammerDB. Vuser 2:FINISHED SUCCESS Vuser 1:Calculating timings.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

Smashing Magazine

AUGUST 28, 2020

First, create a virtual environment, named djangodev. Now to get into your virtual environment, you need to get it activated; source ~/.virtualenvs/djangodev/bin/activate. Note: You need to activate the virtual environment anytime you want to use Django. Your classes (or models) are layouts your database tables will follow.

Virtualization 143

Virtualization Database Code Processing 143

SQL Server According to Bob

APRIL 24, 2018

I also started my career developing on UNIX systems with C++ and databases like Ingres. When I joined Microsoft in 1993, I would embark on a 25 year journey working only on Windows laptops and Windows Server computers. Last October we released SQL Server 2017 including support for Linux and Docker Containers.

Servers 40

Servers Internet Internet Open Source 40

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. Regardless of whether the computing platform to be evaluated is on-prem, containerized, virtualized, or in the cloud, it is crucial to consider several essential factors. TB)) for storage of database tablespaces and logging.

Performance 54

Performance Benchmarking Cache Storage 54

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. Microsoft has helped simplify things by creating multiple types of virtual machines. The various types are: General purpose – Balanced CPU-to-memory ratio, small to medium databases. VM Image Options.

Azure 76

Azure Benchmarking Storage Virtualization 76

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. We now have a new way of instrumenting the backup/restore process for any database or 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. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

HammerDB

DECEMBER 5, 2020

A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. Instead all of the client servers are connecting to the TP monitor.

C++ 40

C++ Benchmarking Virtualization Open Source 40