Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

DBAle 31: Monitoring matters for modern data management

Is it a beer, is it a muffin or is it a Panda Pop? Who knows but at 9% strength, producer Louise joins our Chris duo as plan B, to monitor proceedings. Very fitting as our discussion focuses on monitoring for the modern data age. We talk busyness, hybrid estates, tooling, Multi-RDBMS, and a surprising amount about car mechanics. In The News we debate scrape or breach, and the potential maximum fines for the latest Facebook scandal. So, grab yourself a beer and tune in – cheers.

SQL vs NoSQL databases

Application developers have a choice between two main categories of database: SQL (Structured Query Language) and NoSQL (Not Only SQL). SQL databases, also known as relational databases, have been in use for over 40 years. Despite their age, SQL databases remain extremely popular with developers. Of the top 10 results on DB-Engines’ list of most popular database management systems in September 2021, six were relational, or SQL-based.

Why SQL Server Monitoring Is the First Step in Improving Performance

SQL Server monitoring is continuous collection and analysis of usage, performance, and event metrics for Microsoft SQL Server. It’s the first step in optimizing performance for applications that depend on your data platform. Highly effective monitoring gives a bird’s-eye view of your entire data estate. It also provides the deep analytics necessary to perform root cause analysis on the most challenging performance problems.

What's the real story behind the explosive growth of data?

You may have read or heard about IDC’s recent Global DataSphere Forecast, 2021-2025, which predicts that global data creation and replication will experience a compound annual growth rate (CAGR) of 23% over the forecast period, leaping to 181 zettabytes in 2025. That’s up from 64.2 zettabytes of data in 2020 which, in turn, is a tenfold increase from the 6.5 zettabytes in 2012.

Spotting and Avoiding Database Drift

Managing any database ecosystem is difficult enough: taking backups, maintaining statistics, and doing performance tuning all tax the time of the DBA or database developer. The job is complex even without considering the work you do to manage the various schema and data drifts that can occur. Unless you operate in a vacuum or within a single person organization (and even then, schema drift can occur), drift is going to manifest naturally and as the size of the environment expands.