Background
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…
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…
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)
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…
Let’s face it, tuning SQL statements is time-consuming, often frustrating and just plain hard. For many years, I’ve been giving performance tuning presentations, and through those years I’ve managed to whittle it down to five simple manual tuning tips…
Quest is very excited to announce the General Availability of Spotlight on SQL Server Enterprise v13.3.
Spotlight on SQL Server Enterprise v13.3 is focused on a major aspect of SQL Server tuning - analyzing execution plans.
An execution plan…
Few things are as frustrating for database professionals as the inability to track down the root cause of a performance issue. And when you’re under pressure to keep everything running smoothly, manually and inefficiently struggling to understand the…
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, innovative SaaS platform.
Two years ago, we…
One of the primary needs of those responsible for maintaining the health of database environments is to efficiently find poorly performing queries. Are there resource-intensive queries running? Are there long-running queries running? Who is running them…
SQL Server provides us with a number of high availability and disaster recovery solutions. Two of them are Always On Availability Groups and Always On Failover Cluster offerings. In order to leverage these options, they themselves need to be constantly…
Spotlight reports are designed in SQL Server Report Definition files (RDL) and stored in the local installation folder of Spotlight client application making them accessible to Spotlight users. By default this path in Spotlight is C:\Program Files (x86…
I recently had a customer ask if they can audit SELECT operations for 1 table and 1 view in a specific database where the SELECT only contains certain keywords.
This article covers advanced filtering in ApexSQL Audit. This post will provide a tutorial…
If you missed the recent webcast on SQL performance tuning presented by Janis Griffin, you are definitely going to want to watch it on-demand. She packed so much information into 60 minutes, it’s a wonder there weren’t thousands of heads exploding across…
We were recently asked if Foglight can be used to monitor Google Cloud SQL instances, specifically MySQL, PostgreSQL and SQL Server. To clarify, these are the PaaS (or DBaaS) offerings from Google. Within Google Cloud Platform, you can use Compute Engine…