Migrating databases from Oracle to SQL Server can be challenging, particularly when character sets between the two systems differ. Mismatched character sets can lead to data loss, corruption, or issues with character encoding. In this blog, we'll explore…
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…
From Foglight version 6.3 onwards a lot of development has gone into updating the security of Foglight, that could be upgrading various components to the latest versions but also ensuring the agents negotiate the highest security protocols when connecting…
Many organizations have a cloud strategy and one of which is moving your databases to cloud. If you have already/recently moved to AWS and started using AWS RDS Databases for example Oracle, SQL Server, PostgreSQL, MySQL and if you are wondering how to…
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…
I received a question today from a customer about alerting on index fragmentation within Foglight. We don’t provide this feature out of the box, but we could add this as a custom feature.
So, to begin with, let’s consider how we find this information…
We are very excited to announce the general availability of Quest® Foglight® version 6.3.
Foglight is the world’s broadest and deepest monitoring and optimization solution for the hybrid enterprise. Foglight brings unique top-to-bottom…
As organizations rely more on data to make critical business decisions, ensuring that their databases are running efficiently becomes increasingly important. A database slowdown or crash can result in a significant…
Once Foglight for Databases or Foglight for SQL Server has been installed, you’ll need to tell it what to monitor. Since Foglight doesn’t use any agents installed on the monitored systems, all you have to do is provide Foglight a SQL and Windows…
If you are reading this, chances are you’re considering a 30 day trial of ‘Foglight for Cross Platform Databases’. Before you do, here are a few tips that will help you get a fully functional Foglight installation up and running quickly…
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…
Database performance issues are a major contributor to the application slowdowns which we all face every day.
DBAs, developers and IT professionals have a daunting task of deciphering the large number of factors that contribute to database wait time.…
This is the second in a multi-part series on how to leverage Foglight to save money within your IT budgets. To review the first part, managing monitoring vendor sprawl, check out the post linked here.
This post is going to cover another way to save money…
If you’ve never attended a SQL Server performance tuning session with Brent Ozar or Pinal Dave, you’re in for a treat when the two of them team up during Quest EMPOWER, a virtual conference occurring November 10-11, 2021.
Brent Ozar is a Microsoft…
In this article, we will explore when and how to use the SQL PARTITION BY clause and compare it to using the GROUP BY clause.
Database users use aggregate functions such as MAX(), MIN(), AVERAGE() and COUNT() for performing…
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…
This short video reviews Spotlight's Workload and Wait State Analysis dashboards. (4:53)
Constraints in SQL Server are predefined rules that you can enforce on single or multiple columns. These constraints help maintain the integrity, reliability and accuracy of values stored in these columns. You can create constraints using CREATE TABLE…
This short video reviews Spotlight's navigation and workflow. (3:39)
