The Juggling Act of Modern DBAs
Database performance monitoring can be a real circus! And with an ever-growing amount of technology platforms to manage, we’ve become the ultimate jugglers. Didn’t sign up to be a clown? Hey, I know...
Foglight for SQL Server – Custom Dashboards using Views
While on the Quest stand at the recent SQL Pass summit in Seattle I was talking to a customer about custom dashboards. You can find more information on custom dashboards here: https://www.quest.com/co...
Be Doubly Selective with Two Foglight Report Parameterized Inputs: SQL Server Instance and Databases
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...
Foglight for Databases Quick Tip – Rules and Alerts for Baseline Deviation
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 pe...
Monitor Postgres Post-Haste with Foglight
First, a brief introduction…. Formally named PostgreSQL (and pronounced /ˈpoʊstɡrɛs ˌkjuː ˈɛl/), it is an object-relational database management system with roots from the Ingres project at the Univer...
Reconsidering the idea of monitoring pre-production database instances
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 itsel...
Customer Question: Setting Up ASM Monitoring with Foglight for Oracle
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 AS...
Diagnosing Blocking and Deadlocks with Foglight for Databases
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 cus...
A General Guide to a Foglight for SQL Server Upgrade
Understand that this is a general, high-level guide outlining the steps you should expect to take during a Foglight for SQL Server upgrade. Since environments and upgrade circumstances are often diffe...
Customer Story: Using Foglight SQL PI to Detect Unauthorized User Activity
Let me be very clear when I say that I do not advertise Foglight for Databases as a security auditing or intrusion detection solution. What is interesting to me is a scenario described by a customer w...
Documenting your SQL Server inventory with Foglight
As a DBA, you are responsible for many things, not to mention the ever changing landscape that is your database environment. Documenting the server inventory is essential as it will come in good use ...
Filter Database Visibility Using Foglight User Level Access
Organizations are as varied as the people working within them. Some organizations have groups that are focused on specific applications. Some organizations have people responsible for specific databas...