SQL Performance

MARCH 13, 2020

SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The post SQL Server 2019 Cumulative Update #3 appeared first on SQLPerformance.com. The build number is 15.0.4023.6.

Servers 40

Servers Availability 40

SQL Performance

FEBRUARY 13, 2020

SQL Server 2019 Cumulative Update #2 is now available, with 134 fixes and improvements. The post SQL Server 2019 Cumulative Update #2 appeared first on SQLPerformance.com. Build # is 15.0.4013.40.

Servers 40

Servers Availability 40

SQL Performance

NOVEMBER 1, 2019

As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features.

Servers 40

Servers Hardware Database Availability 40

SQL Shack

JULY 15, 2020

In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations. A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016 Configuration of virtual machines on Oracle […].

Servers 69

Servers Availability Virtualization Infrastructure 69

High Scalability

JUNE 27, 2019

Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy?

Open Source 196

Open Source Database Cloud Strategy 196

SQL Shack

NOVEMBER 25, 2019

In an article, An overview of the SQL table variable, we explored the usage of SQL table variables in SQL Server in comparison with a temporary table. Let’s have a quick recap of the table variable: We can define a table variable and use it similar to a temporary table with few differences. The table […].

Servers 87

Servers Development Performance 87

SQL Shack

JULY 10, 2019

By removing disk-based storage and the challenge of copying data in and out of memory, query speeds in SQL Server can be improved by orders of magnitude. Introduction In-memory technologies are one of the greatest ways to improve performance and combat contention in computing today.

Servers 79

Servers Latency Storage Speed 79

SQL Server According to Bob

APRIL 4, 2020

SQL Server On Linux: Logger.ini Size and Rollover Additions ​​ to SQL Server 2019 CU4 I can’t take credit for this post as Dylan added the code and provided the write-up to share with you. For SQL Server on Linux, there are ​​ additional logging capabilities.

Servers 40

Servers Code 40

Percona Community

APRIL 4, 2022

I love the Raspberry Pi, and I love Percona server. I have been running a Percona Server database since 2019 to hold all the weather information, that I collect from several of my Weather Stations. I did a my first blog post on installing Percona Server 5.7 The combination of the two can provide a nice home database.

Servers 52

Servers Database 52

SQL Shack

OCTOBER 6, 2020

In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances. Introduction SQL Server 2017 & 2019 works on the cross-platform operating system: Windows and Linux. You […].

Servers 52

Servers Availability Operating System Systems 52

SQL Shack

JULY 13, 2020

In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration. Introduction SQL Server Always On Availability Groups offers high availability and disaster recovery solution for mission-critical databases.

Servers 69

Servers Availability Database 69

SQL Shack

MAY 13, 2020

In this article, we will learn latch contention issues that we might experience in the SQL Server TempDB database. Especially, we will mention the Memory-Optimized TempDB Metadata feature that was introduced with the SQL Server 2019. We will also discuss reasons and the solution method of these latch contention issues.

Database 68

Database Servers Performance Testing Testing 68

SQL Shack

JULY 13, 2020

In this series for SQL Server Always On availability groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In this article, we […].

Availability 77

Availability Servers Virtualization Network 77

SQL Shack

OCTOBER 12, 2020

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Introduction We might have sensitive data in our SQL database such as customers’ credit card details, bank account details, social security numbers, and medical history.

Servers 105

Servers Availability Database 105

MachMetrics

DECEMBER 27, 2019

It can also be described as server delay. TTFB is typically reduced via server-side optimizations, such as enabling caching and database indexes. The post Year in Web Performance: 2019 appeared first on MachMetrics Speed Blog. Time to first byte is a blocker for all other metrics that follow it.

Performance 52

Performance Speed Website Mobile 52

Scalegrid

JUNE 18, 2019

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. Servers provided as seeds that do # not belong to this replica set will be ignored. Whether to connect to the servers via ssl.

C++ 100

C++ Servers Database Network 100

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. 2019-04-29T18:34:58+00:00. 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. The Server Timing Header. Drew McLellan.

Servers 87

Servers Performance Metrics Database 87

Percona Community

MAY 4, 2020

Wed) Level: Intermediate Abstract MariaDB Server 10.4 has been out for some time now (June 2019) and it has many new features, some of which MySQL does not have. Feature-wise, it is important to know what MariaDB Server 10.4 . • London 4:00 a.m. Wed) • New Delhi 8:30 a.m.

Servers 52

Servers Storage Engineering Systems 52

High Scalability

FEBRUARY 1, 2019

ludovicc : We spent many years to remove stored procedures and put business logic in an application server, why do you want to go back to that? Glacier is cheap because it isn't "always ready" storage. and if/when you REALLY need the data, you're gonna be waiting a long time. Nice idea for fast prototyping though.

Internet 146

Internet Internet Scalability Games 146

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

Dynatrace

NOVEMBER 19, 2021

This eliminates certain timeout issues with Windows Server 2019 at boot. Problems API v2 now includes event evidence data as part of the event details. With this release, svchost.exe is excluded from injection. This opens the **Add new SLO ** page already filled in with the settings from the cloned SLO.

Metrics 207

Metrics Monitoring Traffic Servers 207

Dynatrace

SEPTEMBER 7, 2019

OneAgent for IBM Z platform is now also compatible with the SUSE Linux Enterprise Server (SLES) 12 distribution. in November 2019 as it reached end-of-life on June, 27th 2019. in November 2019 as it reached end-of-life on June, 27th 2019. support has been extended and will reach end-of-life in November 2019.

Java 101

Java Traffic AWS Monitoring 101

Scalegrid

NOVEMBER 29, 2023

Data Center Dynamics highlights a significant uptick in DBaaS adoption, growing from 40% to 45% between 2019 and 2020. This blog post will explore some of the major challenges in database management that businesses can expect, especially when transitioning from traditional database servers.

Healthcare 130

Healthcare Hardware Database Scalability 130

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers. This was a chance to talk about other things I've been working on, such as the present and future of hardware performance.

Performance 140

Performance Latency Hardware Storage 140

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

Dynatrace

APRIL 15, 2022

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. ” Despite many challenges, when the project concluded in 2019, the team had the confidence and experience to migrate anything to the cloud.

Cloud 178

Cloud Infrastructure Innovation Monitoring 178

Scalegrid

JULY 17, 2019

July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. PALO ALTO, Calif., The ScaleGrid platform allows PostgreSQL users to automate their daily operations without having to sacrifice control over their deployments.

Azure 182

Azure AWS Open Source Database 182

Dynatrace

JANUARY 19, 2020

Having released this functionality in a Preview Release back in May 2019, we’re now happy to announce the General Availability of our SAP ABAP monitoring extension. As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. Dynatrace news. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 154

Monitoring Best Practices Infrastructure Servers 154

SQL Performance

MARCH 17, 2020

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. It would be nice if SQL Server could push the aggregation down into the scan and just return distinct values from the column store directly.

Servers 86

Servers Tuning Database Efficiency 86

Dynatrace

NOVEMBER 6, 2019

The vendor has de-supported this technology and version with 2019-04-30. The vendor has de-supported this technology and version with 2019-06-30. IBM WebSphere Application Server 8.0. Upcoming support changes. Upcoming OneAgent support changes. Node.js 11.

Java 104

Java Technology Technology Servers 104

Dynatrace

JUNE 9, 2020

However, due to special requirements and dependencies (which vary for different Linux distributions), installation on Linux servers could sometimes be tricky or require some extra knowledge. As you might already know, starting with Dynatrace version 1.193, Windows Server 2019 is supported. What’s next.

Monitoring 134

Monitoring Hardware Servers Infrastructure 134

SQL Server According to Bob

JULY 31, 2018

Update Oct 2018 – SQL Server 2019 CTP 2.0. SQL Server 2019 changes the DELTE On CLOSE behavior used on Linux installations. Bob Dorr – Principal Software Engineer SQL Server. The downside of using unlink or remove, and keeping the file descriptor open, is that the file becomes hidden. Restart the VM.

Servers 40

Servers Software Engineering Systems Monitoring 40

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. PALO ALTO, Calif.,

Azure 100

Azure Availability Open Source Virtualization 100

SQL Performance

AUGUST 14, 2019

SQL Server 2016 introduces the batch-mode Window Aggregate operator, which removes the performance penalty part of the pitfall, but prior to SQL Server 2019 this operator is used only if you have a columnstore index present on the data. This would have resulted in quadratic, or N 2 , complexity.

Best Practices 108

Best Practices Servers Database Azure 108

Dynatrace

JULY 9, 2019

support has been extended and will reach end-of-life in November 2019. x (Pivotal support for this version ended in April 2019. x (Pivotal support for this version ends in June 2019. WebSphere Application Server version 8.0 ( EOS by IBM in April 2018 ) OneAgent 1.183 will be the last version that supports WebSphere v8.0.

Java 104

Java AWS Cloud Infrastructure 104

Dynatrace

JULY 31, 2020

The vendor has de-supported this technology and version with 2019-09-30. The vendor has de-supported this technology and version with 2019-09-30. Windows: Windows Server 2008. Windows: Windows Server 1809. OneAgent 1.197 will be the last OneAgent version that supports the following technologies. Oracle Hotspot JVM 12.

Java 119

Java Operating System Infrastructure Monitoring 119

Dynatrace

MAY 31, 2023

Uptime Institute’s 2022 Outage Analysis report found that over 60% of system outages resulted in at least $100,000 in total losses, up from 39% in 2019. More than one in seven outages cost more than $1 million. Identify KPIs Next, create a list of the key performance indicators (KPIs) that are important to the business.

Best Practices 224

Best Practices DevOps Latency Metrics 224