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…
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…
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…
Having fun with the "SQL de Mayo" theme at the conference
One of the best things about working for Quest has been the numerous opportunities we get to participate in conferences, user groups and meet-ups related to the database technologies…
The proliferation of web hosting alternatives and client side execution of code within web browsers has moved APM vendors to take a much harder look at collecting data from within the browser using JavaScript instrumentation. While sniffing the wire to…
A colleague of mine (Darren Mallette) wrote a great blog post explaining how to query the embedded Foglight Performance Investigator (PI) repository using tools which provide native PostgreSQL connectivity (i.e. Toad Data Point or pgAdmin). While reading…
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…
A Picture is worth a thousand words!
Execution plans can help us identify the performance hog sections of SQL code that impact CPU usage and I/O operations. Addressing these bottlenecks can ultimately help us achieve the best execution times. What if…
Finding where and how things are getting locked up
Aside from IO bottlenecks, locking-related problems are the pains most commonly mentioned in the demos that we here at Quest Software provide for customers seeking database management performance tools…
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…
Can Foglight run on a Raspberry Pi running Linux? This blog answers the question.
Interestingly, I've been asked more than once recently if the Foglight Agent Manager can be installed on a Raspberry Pi (version 3) running Raspbian. One of the main use…
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…
Understanding the processes and configurations causing your bottlenecks
IO is the single most important metric to know for creating optimal performance of your database systems. To understand it, you’ll need to know the processes, resources and configurations…
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:
When reporting a Foglight connectivity issue, support people are always asking to test the connection using Telnet or Putty. But what to do if you do not have Telnet or Putty installed?
There are some other options, for example using an Internet browser…
“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…
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…
In the recent 5.7.5.50 release of Foglight for SQL Server, a change was made to the TempDB drilldown. Specifically, the Sessions tab would formerly show the current sessions, regardless of the time range selected on the dashboard. Now, it will allow you…
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# …
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: