Performance Monitoring

There are several ways in Foglight for SQL Server to add multiple instances for monitoring. From the Monitor option, there is a link at the top to discover multiple instances. You can use the command line installer for mass deployment or continue wi…

From Foglight version 6.3 onwards a lot of development has gone into updating the security of Foglight, that could be upgrading various components to the latest versions but also ensuring the agents negotiate the highest security protocols when conne…

Many organizations have a cloud strategy and one of which is moving your databases to cloud. If you have already/recently moved to AWS and started using AWS RDS Databases for example Oracle, SQL Server, PostgreSQL, MySQL and if you are wondering how …

I was asked recently if there were any videos or posts on installing Foglight on Linux. We have some documentation but I wanted to walk thru the steps in the installer. I've downloaded the "Foglight for Databases for Linux" installer from the trial s…

Configuring user-defined collections (UDCs) and adding rules to alert upon the result have been covered previously in this blog. With Oracle and SQL Server, UDCs are stored in the Foglight topology model at the instance level.I found a special case w…

Barman (Backup and Recovery Manager) is a software solution that performs and manages PostgreSQL database backups and recovery. Barman is open-source, maintained by EnterpriseDB, and distributed under GNU GPL 3. It uses PostgreSQL's Point-in-Tim...

I've got our database load testing product, Benchmark Factory (bmf), running load tests on various database platforms in our lab. Sometimes the host reboots and then BMF needs to be restarted. Since I'm monitoring the host with Foglight, I de...

I’ve been using PostgreSQL for many years, but mainly as an application back end database. I’ve never really had a chance to performance test a Postgres database and see what happens. With the 7.3 version of Foglight we now have the SQLPI...

A common requirement for any monitoring solution is to integrate with a service desk ticketing system. Most will accept an email or API call to create tickets if the monitoring solution detects an issue. I recently worked with a customer who needed t…

The Postgres community is excited about the new release of Postgres - Version 17! *(Released September 26, 2024) Here are some highlights of what is new in this latest version. Performance Improvements - This release brings several upgrades to ...

You're looking at Foglight's Global View dashboard and deciding the workflow you'd like to take to diagnose database performance. There are several options for you here.... Global View dashboard: *(click on the images to enlarge) You ma...

One of my favourite features to write about in Foglight isn't really a feature at all - it's more like a foundational building block that enables you to do interesting things. UI queries are simply a path to the underlying data. They are particularly…