Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

Creating simple extensions for PostgreSQL

By | Database Administration & Monitoring | No Comments

When you are using PostgreSQL you should already know that PostgreSQL comes with a set of extensions by default. It might be that you need to install an additional package if you installed PostgreSQL with a package manager to get those extensions. Usually it is called something with “contrib” in its name. There is also the PostgreSQL Extension Network which list a lot of external extensions that might be useful for you. If you can’t…

Read More
Daniel Westermann

What are these *.ready and *.done files for in PostgreSQL?

By | Database Administration & Monitoring | No Comments

When you run PostgreSQL workloads in production you must have a backup and restore implementation. Even for development instances, which are like production for the developers, a well-tested backup and restore procedure sometimes must be in place. Community PostgreSQL comes with pg_basebackup to help you with creating a full consistent backup of your PostgreSQL cluster. If you want to be able to do point in time recovery (PITR) you need to archive the WAL segments…

Read More
Steven Naudet

SQL Server: Fixing another huge MSDB database – 80GB+

By | Database Administration & Monitoring, SQL Server | No Comments

I have blogged several times about unusually large MSDB databases like here. Most of the time the problem comes from the backup history which is never purged. This time it’s different. Try to guess, if not the backup history, what can cause MSDB to increase abnormally in size? Let’s start by looking at the total size of the database: It’s huge. The database size is almost 90GB. The 10% configuration on data files causes large…

Read More
Daniel Westermann

New predefined roles for PostgreSQL 14

By | Database Administration & Monitoring | No Comments

Time is moving fast and PostgreSQL 14 is already in beta 2. PostgreSQL 14 will ship with a lot of new features and in this post will look at a smaller one: There are three new predefined roles: pg_read_all_data, pg_write_all_data and pg_database_owner. While it seems to be obvious what the first two roles are about, the third one might sound strange at the beginning. Let’s have a look.

Read More
Stéphane Haby

SQL Server 2019: What’s new in sp_configure and sys.configurations options?

By | Database Administration & Monitoring, Database management, SQL Server, Technology Survey | No Comments

SQL Server 2019 added new options in sp_configure and sys.configurations. First, how can we find the difference between these SQL Server Versions. This simple query will give us the number of options and the SQL Server Version: select count(*),@@version FROM sys.configurations In SQL server 2016, we have 74 parameters for the instance configuration: In SQL server 2017, we have 77 parameters for the instance configuration: In SQL server 2019, we have 84 parameters for the…

Read More
Stéphane Haby

SQL Server SCOM Alert Analysis: The Average Wait Time of SQL instance “xxx” on computer “xxx” is too high

By | Database Administration & Monitoring, Database management, Development & Performance, SQL Server | No Comments

I have an interested alert on SCOM for SQL Server by a customer two weeks ago. In the SCOM interface, the warning on the server is MSSQL2016: The Average Wait Time of SQL instance “xxx” on computer “xxx” is too high. After right-click on the properties, go to the tab Alert Context. On this part, you can see that the Object Name is MSSQL$xxx:Locks. My first step is to go in the Reports>Standard Reports> Performance…

Read More
Open source Team

See you on Polywork (an new LinkedIn?)

By | AWS, Database Administration & Monitoring, Kubernetes, NoSQL, Oracle, Postgres | No Comments

By Franck Pachot . I have published 105 additional blog posts here since the 500th one https://blog.dbi-services.com/rollback-to-savepoint/ that I have written on my come back to dbi-services. On Oracle Database, of course, other databases as well, on clouds (OCI and AWS mainly, with a look at GCP and Azure). But also with some thoughts on the rise of the “scale-out” obsession of NoSQL. And, because I’m convinced that consistency, referential integrity, and SQL is a…

Read More
Karsten Lenz

Recurring PostgreSQL Installations using RHEL 8 and Clones

By | Database Administration & Monitoring | No Comments

This Blog is a follow up uf one of my older Blogs and my Article at heise.de: Blog at dbi-services.com Article at heise.de For RHEL 8 at its clones like AlmaLinux, CentOS, Oracle Linux and Rocky Linux i have written a shell script to automated recurring setups. This is used for a cloud project using own virtual machines. The script automates the steps i have described at my article at heise.de. The script has an…

Read More
Stéphane Haby

SQL Server SCOM: Many perf.perfHourly and State.StateHourly tables in OperationManagerDW

By | Database Administration & Monitoring, Database management, Development & Performance, SQL Server | No Comments

By a customer, the SCOM’s Database OperationManagerDW growth fast and becomes very big. To see what’s happens, in SSMS (SQL Server Management Studio), I right-click on the database open Reports>Standard Report> Disk Usage by Top Tables: You have many interesting reports with SSMS and I advise you to use it. In my case the “Disk Usage by Top Tables” report displays me many perf.perfHourly and State.StateHourly tables with a _guid(): After reading some blog’s, the…

Read More
Stéphane Haby

SQL Server: How to compare Server and Database Collation

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Sometimes during an SQL Server audit, I check the collation of the server and the databases but every time separately. The goal of this blog is to give you a script to have both and compare it. First step is to have the server collation and the code page. The code page will help to see if the character set is the same. For example, for us, the 1252 is Latin/Western European and the 1258…

Read More