Remove 2008 Remove Database Remove Storage
article thumbnail

How To Reduce the Costs of Database Management in Financial Services

Percona

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. With proper database management, it’s possible to cut your bills in half.

article thumbnail

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

High Scalability

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
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

article thumbnail

The Lock Escalation Threshold – Part 1

SQL Performance

Let’s look at some examples using a fresh database. 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. USE master ; -- Create a new test database. -- COLLATE clause only to remind people it exists.

article thumbnail

"0 to 60" : Switching to indirect checkpoints

SQL Performance

I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. Change the Target Recovery Time of a Database. databases AS d.

C++ 58
article thumbnail

Expanding the Cloud for Windows Developers - All Things Distributed

All Things Distributed

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.

Cloud 106
article thumbnail

Finding Distinct Values Quickly

SQL Performance

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Not everyone will be able to move to column store storage quickly, and it won't always be the right solution anyway.

Servers 86