What an exciting year it was for Foglight for Databases!
Foglight for Databases had an amazing year, with several releases for the various Database Cartridges. Here are some of the highlights of what we’ve done in 2017:
- Foglight for SQL Server…
Foglight for Databases had an amazing year, with several releases for the various Database Cartridges. Here are some of the highlights of what we’ve done in 2017:
Many customers ask how they might integrate Foglight Alarms into other 3rd party monitoring tools. One way to accomplish this is to send SNMP traps in response to a Foglight alarm.
To configure Foglight for this capability, you need to first download…
I had a customer ask how they could use Foglight to find out when "dbcc checkdb" last ran against their SQL Server databases.
This is a great use case for User-Defined Collections!
As a refresher, my colleague Trent Mera wrote a great blog on…
Understand that this is a general, high-level guide outlining the steps you should expect to take during a Foglight for SQL Server upgrade. Since environments and upgrade circumstances are often different, it is important to review and familiarize yourself…
As a DBA, you are responsible for many things, not to mention the ever changing landscape that is your database environment. Documenting the server inventory is essential as it will come in good use when it comes to planning for a migration/upgrade,…
Organizations are as varied as the people working within them. Some organizations have groups that are focused on specific applications. Some organizations have people responsible for specific database platforms supporting the business. How ever the organization…
We often get questions from customers wondering how much overhead will be put on a database server when monitoring that server with Foglight for SQL Server and/or Foglight for Oracle. This blog post should act to explain exactly how Foglight collects…
Managing production application databases has become more demanding than ever before not only due to the complexity of the applications they support, but also the very small margins for performance slowdowns or outages. Being proactive and resolving…
The backend repository for the Foglight Performance Investigator is based on Infobright, an analytics engine for machine generated data. However, you can connect natively via anything that can connect to PostgreSQL.
The schema reference for Performance…
As the old saying goes, “the one constant in life is change”, and this is especially true in database environments. There are many reasons why database environments experience change whether it be through typical maintenance efforts such…
SQL Performance Investigator (SQL-PI) is an extension to the standard Foglight for SQL Server Cartridge, and adds Real-time and historical data.
If you have used Performance Analysis for SQL Server, then SQL Performance Investigator should look very familiar…
“The Only Thing That Is Constant Is Change “- Heraclitus.
Development, new applications, upgrades, patches, maintenance, schema updates…the list goes on and on around ways that changes are introduced into your environment. Sometimes these…
A common question is how to make an exception for 1 or 2 particular databases for certain rules in Foglight. A good example is the "days since last backup" rule for SQL Server. The global default applies to all databases. It's possible from the Databases…
This post will cover one way to make it easy easier to get the user-defined collection data onto a dashboard or report.
For a quick refresher, please see User Defined Collections in Foglight for SQL Server: A Quick Walk-Through
With a "simple" UDC that…
Many of our Foglight users including myself have grown accustomed to using the "Databases" home as their starting point into their daily monitoring tasks. This dashboard provides a global view into all of the instances being monitored and gives…
During a recent installation of Foglight for SQL/Oracle the DBA announced how excited he was to get Foglight installed because he was desperate to become a pro-active DBA and stop being a re-active one. Music to my ears!
So what was it about Foglight…
If you’re like many DBAs, your life is probably getting more complicated by the week. Are you under pressure to manage larger and larger numbers of database instances? Or to adopt new database technologies like open source or NoSQL? With those changes…
Foglight Administrators often find that the responsibility of onboarding Foglight end users falls on them. It’s not always the case; sometimes we see that a business liaison will work with teams that need Foglight and they will help setup the use cases…
I had a question recently from a customer. They were asking how to keep track of inactive SQL Server instances in Foglight so that the data can be removed. A flip side of this would be to check what instances they have being monitored vs. what is supposed…
The attached post shows how to use Foglight Performance Investigator for Oracle to analyze and compare historical execution plans.
The attached post shows how to use Foglight Performance Investigator for SQL Server to analyze and compare historical execution plans.
Had a question from a customer today about backing up the Foglight for SQL PI database. The customer wants to automate this using command line and the reference guide asks you to deactivate the agent first, via the UI.
No problem, I said, there is always…
