So here is an interesting example of using Quest solutions together. What if you have Foglight, you are monitoring a database, you find a SQL Server stored procedure that is getting slower, and slower and you want to know what the purpose of this proc…
From Foglight version 6.3 onwards a lot of development has gone into updating the security of Foglight, that could be upgrading various components to the latest versions but also ensuring the agents negotiate the highest security protocols when connecting…
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…
I received a question today from a customer about alerting on index fragmentation within Foglight. We don’t provide this feature out of the box, but we could add this as a custom feature.
So, to begin with, let’s consider how we find this information…
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…
Once Foglight for Databases or Foglight for SQL Server has been installed, you’ll need to tell it what to monitor. Since Foglight doesn’t use any agents installed on the monitored systems, all you have to do is provide Foglight a SQL and Windows…
If you are reading this, chances are you’re considering a 30 day trial of ‘Foglight for Cross Platform Databases’. Before you do, here are a few tips that will help you get a fully functional Foglight installation up and running quickly…
Part 2 of this series will show you how to tune the queries you found by using Workload Analysis (see Part 1). Additionally, we'll look at the different 'Context' dimensions to help you quickly focus on the right problem.
2. SQL Statements…
Database performance issues are a major contributor to the application slowdowns which we all face every day.
DBAs, developers and IT professionals have a daunting task of deciphering the large number of factors that contribute to database wait time.…
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…
We were recently asked if Foglight can be used to monitor Google Cloud SQL instances, specifically MySQL, PostgreSQL and SQL Server. To clarify, these are the PaaS (or DBaaS) offerings from Google. Within Google Cloud Platform, you can use Compute Engine…
Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.
In this (Part 1) blog, the focus is SQL Server Integration Services or ‘SSIS’…
Congratulations! You have Foglight installed and it is collecting meaningful performance data. There’s no doubt it is providing a ‘smorgasbord’ of actionable information about your mission-critical environment. Help yourself to delicious servings of baseline…
“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 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…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
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…
For those of you that have been using Foglight for some time may have seen how the solution not only captures and retains metric data historically, but also applies baselines to estimate the system performance and help with system monitoring and planning…
It is a foregone conclusion that performance monitoring is part and parcel of managing a database instance once it is in production. But what about pre-production? Especially when the instance itself is reaching critical phases of testing and quality…
We are pleased to announce the general availability of Foglight for SQL Server and Foglight for Oracle versions 5.7.5.35. This release provides the following significant enhancements:
