OS Process Monitoring with Foglight
I've got our database load testing product, Benchmark Factory (bmf), running load tests on various database platforms in our lab. Sometimes the host reboots and then BMF needs to be restarted. Since I...
Foglight for PostgreSQL, let’s see what the elephant is doing.
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 ver...
Foglight alarm templates and email notifications – getting the balance right
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 iss...
And the winner is….POSTGRES!
The Postgres community is excited about the new release of Postgres - Version 17! *(Released September 26, 2024) Here are some highlights of what is new in this latest version. Performance Improvemen...
Understand Query Performance Across Your Environment with Foglight’s Query Insights
You're looking at Foglight's Global View dashboard and deciding the workflow you'd like to take to diagnose database performance. There are several options for you here.... Global View dashboard: *(c...
Quick Guide for ‘Spotlight on SQL Server Enterprise’ Installation & Setup
Here are some quick instructions on how to install and set up Spotlight so you can quickly find and diagnose issues in your SQL Server instance. You can start by downloading a free, 30-day trial of Sp...
A Horror Story – Upgrading SQL Server to a Newer Version!
Recently, I had a customer call and ask if Quest had any tools that could help with upgrading their SQL Server 2016 instance to SQL Server 2019. They had already tried to upgrade once but performance...
Introducing World’s First SaaS Platform to Deliver Deep Diagnostics for Hybrid SQL Server Environments
Quest Software is excited to announce our extended Spotlight® Cloud offering which will deliver deep performance diagnostics to both on-premises and cloud SQL Server environments from a single, innova...
Manage and automate Spotlight by PowerShell Command Line Access
When dealing with large number of connections, the power and advantage of PowerShell API can be leveraged to manage, automate, and administer Spotlight configuration. The efficiency gains obtained thr...
Tune Your Queries with SQL Optimizer (Pt 1)
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are: Minimize Response Time – End users who are interacting wit...
How to test connectivity if Telnet or Putty is not available
When reporting a Foglight connectivity issue, support people are always asking to test the connection using Telnet or Putty. But what to do if you do not have Telnet or Putty installed? There are some...
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...