Spotlight 12 Plan Visualizer – Enhancements
We’re excited to announce that with Spotlight version 12.3, the Plan Visualizer feature now includes several new enhancements. In my last blog, I covered the Plan Visualizer feature included in versio...
Where to find the latest grant privileges scripts for database agents?
During installing of an database agent Foglight requests an admin account to grant the needed database privileges to the Foglight database user. In some environments it is not allowed to do a remote a...
Foglight 5.9.3 What is New! – Analytics View in Custom Dashboards
Foglight 5.9.3 introduced the following three new WCF components to show collected metrics in a variety of ways and to better analyze the collected data. Tree Map: Treemap displays hierarchical (tre...
Find the Top Application Servers Loading up your Database
A customer recently asked if there was a way to find the top application servers that were placing load on their database instances. With Foglight Performance Investigator, it is very easy. Start with...
Foglight for Virtualization 8.8 is here and its all about understanding the cost, not just the performance, of your hybrid datacenter
How much is Azure costing me? How much do my VMs cost me in my datacenter? Should I migrate to the Cloud? Understand the cost of my datacenter you ask?! You heard that correctly, FVE 8.8 is almost, a...
Spotlight Cloud Workload Analyzer Diagnostic Tool
Spotlight Cloud is a cloud hosted database monitoring and diagnostics application providing DBAs with diagnostic tools to quickly identify and help resolve performance issues. The Workload Analyzer o...
AlwaysOn Monitoring with Foglight for SQL Server
We often get asked about the breadth and depth of Foglight when it comes to its monitoring scope. Whether it support for a multitude of relational, open source and NoSQL database platforms or providi...
Expand your SQL Server monitoring coverage to include your BI stack with Foglight (3-Part Series) Part 1 – SQL Server Integration Services (SSIS)
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 ...
Don’t Worry About Your (Con)figure, Have The PI !
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 en...
Lost on the Database Overview dashboard?
Do you also feel lost sometimes when searching for a specific instance on the database overview dashboard? If you monitor hundreds of databases it is easy to lose the overview but there are some optio...
SQL de Mayo – SQL Saturday #734 Dallas Recap
Having fun with the "SQL de Mayo" theme at the conference One of the best things about working for Quest has been the numerous opportunities we get to participate in conferences, user groups and meet...
Exceptional Database Exceptions in Foglight
A common question is how to make an exception for 1 or 2 particular databases for certain rules in Foglight. A good example is the "days since last backup" rule for SQL Server. The global default appl...