As part of most any database monitoring software evaluation, it includes comparing that software to similar solutions. Logically, it often means doing head-to-head comparisons to database tools that come bundled with that particular DBMS. Regularly, I…

What’s that you say? You think it may not be appropriate that a technology blog dive into politics?

Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglight for Postgres.

Administration options are available…

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 different, it is important to review and familiarize yourself…

In a previous post, I explained how to customize alarms in Spotlight on SQL Server Enterprise. Recently, I had a customer inquire how he could refine the "Days Since Last Full Backup" alarm. He wanted to be able to exclude specific databases, but specify…

In an earlier blog, I wrote about a company’s success with Quest’s flagship SQL Server monitoring and diagnostics solution – Spotlight Enterprise. The blog detailed a customer success story and revealed detailed use cases explaining how this application…

It never gets old hearing about how Quest Performance Monitoring solutions offer actionable insight to mission-critical systems. Upon visiting a customer for a 'health check' of their environment, we had the pleasure of learning about two distinct ways…

I recently spoke to a user of Spotlight on SQL Server Enterprise who wanted to be able to drill into the individual SQL Server instances that are participating in an Availability Group. The customer had successfully created a connection to the Availability…

Naturally, it's VERY important to know when things are going wrong with our monitored instances. What's not helpful is the dreaded "False Positive." You know the scenario I'm about to describe. It's 03:00 and you're sleeping soundly and dreaming of the…

So, you’ve downloaded and installed an evaluation of Spotlight Enterprise. Good news…it comes with a 30-day evaluation license key! Spotlight is fully functional (not limited trial functionality). It simply expires after the 30 days. There are a couple…

One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:

1. Minimize Response Time – End users who are interacting with data want that data as quickly as possible. It may…

The other day I was speaking to a customer about their growth strategy and planning on database management and infrastructure. One of the topic that I really liked is how companies get very creative and innovative. One of the strong drive for them is…

Off-roading, Maps, and Nine Gray Hairs

We all tend to spend most of our time on the “turnpike” of a product’s feature set: you know, the “power” set of its features that get us to many of our endpoint destinations within the product as productively as…

When very large tables are out of sync on the target and Compare is not a suitable sync option, it requires a set of coordinated steps to bring them in sync with the source tables. This is especially true if the downtime on the source table is not acceptable…