Percona

APRIL 14, 2023

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Here we are, with an economic downturn looming globally and some countries facing a recession.

Database 81

Database Serverless Tuning Cloud 81

Percona

JUNE 4, 2023

MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. What is MariaDB? It continues to be developed and maintained by the open source community and remains free to use under the GNU General Public License.

Open Source 52

Open Source Servers Storage Scalability 52

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. A quirk of the implementation means no check is performed when the count of held locks is exactly 1250. The code in HeapDataSetSession::EscalateLocks next calls sqlmin!IsEscalationPossible

Database 98

Database Storage Testing Servers 98

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. Implementing the current requirement using that technique is quite straightforward, though the code is necessarily longer than anything we have seen up to this point: WITH R AS. ( The code may be easier to read and understand than the recursive CTE.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

All Things Distributed

MAY 8, 2012

Using the AWS Toolkit for Visual Studio , you can now deploy your.NET applications to AWS Elastic Beanstalk directly from your Visual Studio environment without changing any code. of administrative tasks such as OS and database software patching, storage management, and implementing reliable backup and disaster recovery solutions.

Cloud 115

Cloud Development AWS Servers 115

SQL Performance

MAY 1, 2020

I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. If you have instances running older versions like SQL Server 2008 R2 (I found one!), writes/sec average throughput: 46.96

C++ 58

C++ Database Servers Storage 58