how to avoid generating alerts that are generated when the databases are different from the online status, i.e. I do not want to be alerted when they are in recovery or any other state?
how to avoid generating alerts that are generated when the databases are different from the online status, i.e. I do not want to be alerted when they are in recovery or any other state?
Many organizations have a cloud strategy and one of which is moving your databases to cloud. If you have already/recently moved to AWS and started using AWS RDS Databases for example Oracle, SQL Server, PostgreSQL, MySQL and if you are wondering how to…
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…
We are very excited to announce the general availability of Quest® Foglight® version 6.3.
Foglight is the world’s broadest and deepest monitoring and optimization solution for the hybrid enterprise. Foglight brings unique top-to-bottom…
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…
We have recently migrated from Quest's Spotlight (for databases) to Foglight (for databases).
In doing so we have run into a few challenges: The most important of which for us is delegating (non administrative) access.
Spotlight had a fairly mature…
This is the second in a multi-part series on how to leverage Foglight to save money within your IT budgets. To review the first part, managing monitoring vendor sprawl, check out the post linked here.
This post is going to cover another way to save money…
Similar to what's been discussed in this post earlier - How to configure corrective action against alarm
I am trying to implement a corrective action triggered via Foglight to auto-remediate SQL server space alarms e.g. increase max size of file and…
I'm looking to see if change data capture events can be logged by Foglight and ultimate be reported out to various groups, mainly for auditing purposes. I'd like to do this for multiple instances that are already being monitored by Foglight.
Let’s face it, tuning SQL statements is time-consuming, often frustrating and just plain hard. For many years, I’ve been giving performance tuning presentations, and through those years I’ve managed to whittle it down to five simple manual tuning tips…
Few things are as frustrating for database professionals as the inability to track down the root cause of a performance issue. And when you’re under pressure to keep everything running smoothly, manually and inefficiently struggling to understand the…
Hey guys,
I'm planning to upgrade the stock halogens headlights to LEDs because for the looks. Is there a recommended LED blub for the high beams or any will work just fine? I'm also planning on adding fog lights to my Mazda this February and since its…
Maybe I'm missing something, but I'm trying to calculate our hardware requirements for the FMS.
I've got to think the second example in the walk-through may not be for the Foglight Management Server alone.
We've investigated a few different ways to handle this but I wanted to see if anyone had already addressed this in their environment. When we spoke to Quest they didn't really have any use cases regarding compliance requirements. I've started reading…
Hi,
We have added a new blade to one of our SQL Server Clusters, and it is on a larger FI switch. I am looking for a way to aggregate the total i/o waits on a group of servers that are running on that blade. Does anyone have a query or a way to do this…
We have a scanning tool that hits every SQL server with bad logins on a regular basis. this generates Sev 20 errors in the log, which si good. however, I don't really want to deal with a few hundred of these a week from a know source. Is there a way to…
“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…
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…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
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…
Hello All,
This alarm "DBSS - Long Running Job" have a global fire threshold for all the jobs.
I can see that there is an exception in order to exclude specific jobs.
Does there is a way to make an exception for a single job duration that will…
Microsoft has evolved their marketing over the past several years to focus on the fact that SQL Server is more than just a Relational Database Management System (RDBMS). You may have noticed, that Microsoft commonly now refers to SQL Server as the SQL…
This large organization was using 6 different monitoring products. SCOM for windows, BMC for Linux, Riverbed Steel Central for APM, Oracle OEM for Oracle Databases, SCOM for SQL Server databases, VMWare for VM monitoring, and Empirix for web transaction…
During periods of scheduled maintenance, you may wish to prevent Foglight from sending alarms about the systems involved in the maintenance task. The use case is quite obvious. You know the system's down for maintenance and there's no need for you to…
Note: Database Expansion Pack download was updated in 2022
Hello all. I am pleased to provide the latest release of my Foglight Database Expansion Pack for general use. Any customer (current or future) is encouraged to install this pack into their Foglight…
