2008 Code Servers Storage 
Percona
APRIL 14, 2023
During the recession of 2008, they experienced firsthand how fast money and assets can vanish. 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. If needed, you can spin up a backup.
Percona
JUNE 4, 2023
In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
AUGUST 27, 2019
On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.
SQL Performance
SEPTEMBER 6, 2022
I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. The SQL Server lock manager keeps track of the number of locks held by the current transaction. Testing environment. Well, almost. The sqlmin!lck_lockInternal
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. Test Environment.
All Things Distributed
MAY 8, 2012
s announcement of Amazon RDS for Microsoft SQL Server and.NET support for AWS Elastic Beanstalk marks another important step in our commitment to increase the flexibility for AWS customers to use the choice of operating system, programming language, development tools and database software that meet their application requirements. Comments ().
SQL Performance
MAY 1, 2020
In a recent tip , I described a scenario where a SQL Server 2016 instance seemed to be struggling with checkpoint times. I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. How It Works: When is the FlushCache message added to SQL Server Error Log?
Expert insights. Personalized for you.
85 
Let's personalize your content