We're thrilled to announce the general availability of Foglight Cloud, a transformative solution reshaping how organizations manage and monitor their IT environment. Foglight Cloud…
The recent system glitch at Toyota offers a compelling lesson in the intricate dance between technology and business. When routine database maintenance went awry, the fallout was massive, halting 28 assembly lines across 14 plants. Over a span of 36 hours…
As part of most any database monitoring software evaluation, it includes comparing that software to similar solutions. Logically, it often means doing head-to-head comparisons to database tools that come bundled with that particular DBMS. Regularly, I…
Database cartridges allow you to monitor your database instances. But you can boost the power of your monitoring by adding one or more of these features.
A Spotlight on Foglight – How Spotlight Users can ease their way into Foglight
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…
We've all been there, the dreaded ticket that comes across our inbox. Always light on detail, just a single sentence: "The database server is slow." No five words bring as much fear, uncertainty and doubt to a DBA than those (well, maybe…
Apologies to Rogers and Hammerstein; but the title fits. In addition to listening to the scores of old musicals, one of my hobbies is watching the weather. I have about 20 years of weather data in a MariaDB database - for those unfamiliar with OpenSource…
You say “No” - well - I say “Yes”. All database rules are sensitive and have a sensitivity level.
What does that mean? What is a sensitivity level? Where can I find it and can it be modified?
Ok - a lot of questions, so let's start…
In Part 1 of this blog post, I review how you can get an evaluation copy and explain the various integration points from Quest’s monitoring solutions – Foglight and Spotlight Enterprise. You can find it here -> https://www.quest.com/community…
Am 10.4. 2018 findet das siebte Foglight Anwendertreffen in Köln statt. Das Treffen bietet Ihnen die Möglichkeit, sich über Neuheiten und Entwicklungen im Bereich Foglight zu informieren und Erfahrungen auszutauschen. Die Referenten kommen aus den technischen…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
The new year kicked off with some big news on January 3rd, 2018 with the news of the Meltdown and Spectre chipset vulnerabilities. There are a lot of resources available to understand the details and potential impact. This one from cnet.com is pretty…
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…
Merriam-Webster defines ‘Custom’ as made or performed according to personal order. Tailored, fitted, personalized…or ‘pimped out’, slang meaning something is modified to extreme performance. There was a television series called …
A Brief Walk-Through of SQL Performance Investigator
In a previous Foglight for Databases/SQL Server blog post, I provided a guide for navigating your database servers’ performance metrics in real-time. That post showed you how to identify your…
Throughout my career I have conversed with many IT leaders that have adopted the practice of measuring the performance of their technology assets by monitoring key performance indicators (or KPIs). Most of them will tell you that there needs to be some…
One of the lesser known features of Foglight the ability to monitor log files. One of our customers has a process that collects and prints documentation required for truck movement. Before a truck can leave the loading dock, the dispatcher requests a…
The Database Administration Manager communicated his need to efficiently gather and report upon growth data in the QA and Production environments. The project at hand was to build an accurate growth model for 6, 12, and 24 month time windows. He explained…
In part one of monitoring Raspberry Pi with Foglight, I showed that the Infrastructure agent worked pretty much as expected when collecting from the Raspbian OS.
I was curious though if it exposed any metrics via snmp.
The first step was to check if snmpd…
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 latest release of the Foglight for Oracle cartridge brings a new dashboard, customer enhancements and various fixes.
There is a new overview dashboard:
It is easier to read with an improved layout. I like the way the various areas are summarized…
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…
Performance Investigator (PI) collects a lot of workload and performance data about the activity which runs within a database instance. This information is saved in the PI embedded repository which is separate from the Foglight repository. As a result…
To all you DBAs and database performance monitoring enthusiasts out there: Have you gotten your copy of the survey The Real World of the Database Administrator yet?
In my previous post, I highlighted several facts of DBA life noted in the survey, including…
As a DBA, would you say that your database performance monitoring tasks are getting any less complex?
I thought not.
We commissioned a study called The Real World of the Database Administrator for a closer look at the facts of DBA life. In this post,…
