On a customer call recently and the customer was asking if our Foglight for Oracle agent included an alert for blocking locks.
This is a rare question for me, since Oracle database customers don’t tend to see issues with blocking locks compared to SQL…
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…
I recently helped a customer setup monitoring for over 400 instances in about 30 minutes. Darren Mallette posted a blog on how easy this is using the Discover Multiple Instances option Setting up Monitoring for Multiple SQL Instances - Performance Monitoring…
I’ve been using PostgreSQL for many years, but mainly as an application back end database. I’ve never really had a chance to performance test a Postgres database and see what happens.
With the 7.3 version of Foglight we now have the SQLPI…
A common requirement for any monitoring solution is to integrate with a service desk ticketing system.
Most will accept an email or API call to create tickets if the monitoring solution detects an issue.
I recently worked with a customer who needed their…
In Foglight 6.1 Quest added additional metrics to monitor Availability Groups (Always-On). The dashboard was also redesigned to show these new metrics as well as some new alarms shown below:
The important point here is that you might have some monitoring…
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…
The PostgreSQL Global Development Group announced the release of Postgres version 15!
Some of the notable feature enhancement additions include:
1. Addition of the MERGE command - SQLServer and Oracle have had this command for some time now and its…
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…
Wouldn't it be nice if we all had a big animal to handle our heavy lifting and workloads?
Introducing, EnterpriseDB's fully-managed Postgres database in the cloud, Big Animal.
-> Get pumped! <- (choose skip ad)
The community spoke and EnterpriseDB…
For environments that have lots of instances to be monitored, registering each of them one by one can be a bit time-consuming.
A time-saving alternative is to import your instance list from a file.
Step 1:
Right-click on the SQL Server node in the navigation…
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…
Postgres v. 14 snuck up on us and was released about a month ago.
The community continues to kill it with advancements in innovation.
Have a look at these frighteningly powerful enhancements and additions.
JSON:
PostgreSQL 14 now supports the syntax…
For over two decades, as a Database Sales Engineer, I have provided technical demonstrations either in-person, online, or in a recorded format. It takes a particular honed skillset to accurately distill technical information and position solutions in…
RR Episode 04 – Are You Prepared For Your Time Away?
In this Episode, Quest Senior Consultants, Dave Orlandi and Amit Parikh, consider the common challenge of staying on top of the systems they manage while out of the office.
On the go? Listen…
Put another way... -> Introduction
What is Spotlight?
Spotlight is a laser-focused monitoring and diagnostics solution for SQLServer (by Quest).
The following is a series of short videos to help you learn and understand the primary capabilities of…
Rabbit, Rabbit!" - a superstition found in Britain and North America wherein a person says or repeats the words "rabbit", "rabbits" and/or "white rabbits" aloud upon waking on the first day of a month, to ensure good luck…
This short video reviews Spotlight's Workload and Wait State Analysis dashboards. (4:53)
RR Episode 02 – Are You Ready for Change?
In this Episode 2, Quest Senior Consultants, Dave Orlandi and Amit Parikh, discuss the importance of being ready for change and considerations around its impact on database performance.
On the go? Listen…
This short video reviews Spotlight's navigation and workflow. (3:39)
Are you looking for a laser-focused monitoring and diagnostics solution for SQLServer?
If so, you're in the right place!
This short video reviews Spotlight's architecture and requirements. (2:59)
Installation is simple and takes only a few minutes…
As part of one’s Database Management strategy, one of the primary tasks at hand is to keep queries running at peak performance. One of the most impactful ways to do this is to identify ‘Missing Indexes’.
Simply put, Indexes can allow…
