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…
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…
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…
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…
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…
All is well. Megan is having a good day. She’s a SQLServer DBA and her environment is humming along. Then…. someone drops a critical table bringing efficient data retrieval to a screeching halt. Now what? It’s a weekday morning and business…
Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.
In this (Part 1) blog, the focus is SQL Server Integration Services or ‘SSIS’…
Congratulations! You have Foglight installed and it is collecting meaningful performance data. There’s no doubt it is providing a ‘smorgasbord’ of actionable information about your mission-critical environment. Help yourself to delicious servings of baseline…
“The Only Thing That Is Constant Is Change “- Heraclitus.
Development, new applications, upgrades, patches, maintenance, schema updates…the list goes on and on around ways that changes are introduced into your environment. Sometimes these…
In Part 1 of this blog post, I review how you can get an evaluation copy and explain the various integration points from Quest’s monitoring solutions – Foglight and Spotlight Enterprise. You can find it here -> https://www.quest.com/community…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
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…
Were you ever sitting in a salary review when you suddenly discovered that you and your boss had different ideas about your most important responsibilities?
Not every DBA has a position-specific job description, and even those who do may not have…
