You’re Fired! Wait, What has Fired?
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 ru...
Checking When DBCC CheckDB Last Checked Your DB
I had a customer ask how they could use Foglight to find out when "dbcc checkdb" last ran against their SQL Server databases. This is a great use case for User-Defined Collections! As a refresher, my ...
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...
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...