As organizations rely more on data to make critical business decisions, ensuring that their databases are running efficiently becomes increasingly important. A database slowdown or crash can result in a significant…
Foglight has rules which fire alarms on specific events, but it can also fire alarms for a group of objects as part of the service builder configuration. This is important if you have a service, let’s say a mixture of monitored objects, like OS, databases…
Put to use some of the built-in facilities of Foglight to make your monitoring even more effective and valuable: registry variables, schedules, services, and the security model.
Find More Time for Innovation and Helping Your Business: Invoke Variables…
What’s that you say? You think it may not be appropriate that a technology blog dive into politics?
Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglight for Postgres.
Administration options are available…
This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle. These monitoring options come included at no additional cost and illustrate how broad and complete Foglight is as an Oracle monitoring solution…
This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle.
Part 1 of the blog covers Foglight’s monitoring for Oracle’s Data Guard.
April 15, 2019.....Let’s give a shout out to all those men and women running the Boston Marathon today.
Man, running for that long must be taxing. Taxing…..wait…what day is it again?
So, as my way of giving a nod to long runners,…
A UI Query can be used to add either static or dynamic components to a service definition via the Service Builder dashboard. This in turn offers a
great range of additional things Foglight can do. This post will introduce creating a service definition…
In my Introduction to UI Queries post, the building of a simple query to return all SQL Server Agent Jobs was shown.
Let's back up a step, and take a look at where UI Queries can be used in Foglight. This post will be updated with links as the topics…
We have all done it. We think we know the lyrics to a song. We sing them passionately….and incorrectly. Here are a few classics.
When you first monitor a database instance, you have the option of adding the host too. But sometimes, the checkbox is un-checked. Now what?
To add a host to monitor on it's own, switch the left-hand panel to Expert Mode, select the Infrastructure dashboard…
Many things can happen if the database runs out of disk space. None of them are good. DBAs understand that it is essential to monitor database disk space so that critical business processes are uninterrupted. Quest’s Foglight provides peace of mind by…
Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.
In this (Part 3) blog, the focus is SQL Server Analysis Services or ‘SSAS’.…
Congratulations! You have Foglight installed and it is collecting meaningful performance data. There’s no doubt it is providing a ‘smorgasbord’ of actionable information about your mission-critical environment. Help yourself to delicious servings of baseline…
Do you also feel lost sometimes when searching for a specific instance on the database overview dashboard? If you monitor hundreds of databases it is easy to lose the overview but there are some options to quickly find the database you need.
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
First, a brief introduction….
Formally named PostgreSQL (and pronounced /ˈpoʊstɡrɛs ˌkjuː ˈɛl/), it is an object-relational database management system with roots from the Ingres project at the University of California, Berkeley. PostgreSQL is open…
As you might suspect, I had difficulty coming up with a witty title for this blog. However, I rather enjoy people rolling their eyes when I make bad jokes. Given the topic is about memory settings for Foglight’s Management Server (FMS) and Foglight’s…
