In a previous post, we learned how to disable specific Foglight alarm severities. For example, maybe you don't want a warning alert when cpu utilization is only at 70% - if so, you can disable that, while keeping the rule active to alert when the condition…
A previous post showed how to modify a registry variable to apply a value to a specific host.
It would be good if the actual value that is going to be used when the rule fires could be validated.
The "Run Condition Query" feature in the Rules…
In a previous post, the Rules dashboard was used to show how to modify the global value of an alarm threshold. For this particular rule, that value would then apply to all hosts that are being monitored.
What if we only want a subset of hosts to take…
I recently showed a customer how to modify the thresholds and severity levels of Database alarms by using the Foglight for Databases administration dashboard. A follow-up question was about how to do the same thing for alarms that were appearing for page…
Often times, we will have a situation where we don't want a Rule to alert on a specific host or set of hosts which are brought down for a reason, but we still want the rule to alert for the rest of the servers.
This can be achieved in multiple ways…
“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…
Investigating a rogue OS process is a pain; digging through the multitude of metrics, different times of days have different outcomes, alarms that come and go and customer complaints to accompany it all. This is just one example of problem troubleshooting…
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…
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…
Registry variables in Foglight are mostly used as placeholders in rules in order to avoid hard-coding in values.
For example, a rule to check cpu utilization over a certain percentage could be coded as:
1- #utilization# > 99.0
or
2- #utilization# …
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…
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…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
Wow! What a year and what a way to wrap it up. Foglight for Virtualization 8.7.5 is out and with it brings a brand new SaaS offering from Quest that enables connectivity from any Foglight for Virtualization installation in the world to the cloud. Try…
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…
In every SQL Server instance the TempDB database is the common global resource for all the operations taking place and DBA's are particularly cautious about the use of it. Given the nature of applications and ad-hoc queries by users, one must keep…
This post is short but hopefully useful. When you start the Foglight server and navigate to the home page URL (http://foglight_server:8080 or https://foglight_server:8443), you may see a startup splash page (below). If you see a login page, then the 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…
I've done a number of posts recently that touch on Foglight administration, customization, or some of the more advanced capabilities of the product. I felt it was a good time to circle back on some of the more basic use cases that Foglight can help…
Just a quick update, in FVE 8.6 we have introduced a simple rule editor. With this you can create new alarms in 5 clicks and easily add email recipients. Check out the video below.
Creating rules in Foglight made easy.
Foglight has many out of the box rules to evaluate performance and availability conditions for your databases, virtual and physical infrastructure, web pages, network devices, etc. Once it has been running for some time, it's a good idea to evaluate which…
My favourite feature in Toad has always been the PL/SQL Profiler. I love the way it can profile your code executions is integrated with the editor. It is such an easy and visual feature to use.
So if you have Foglight for Oracle Performance Investiga…
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…
Foglight reports can be extremely useful in broadening the reach of whatever monitoring you’ve got set up. Reports can be the mechanism for delivering PDF or Excel summaries of important information on the health and capacity of your databases,…
Recently, I spoke with a customer who's using Foglight for Oracle to monitor their RAC instance. They were able to successfully monitor the instance, but then asked "Why don't I see any data in the ASM tab?". I think this is a great question and I thought…
