When you setup monitoring for SQL Server or Oracle, the checkbox to enable SQL PI is off initially. Here's what to do to enable it after setting up a monitoring connection.
From the Databases dashboard, select the instance to enable PI on.
Sel..…
One of the primary tasks of any DBA is to find and optimize poorly performing queries. This is not a trivial job as often times there is too much data to sort through and pinpoint problems. Quest’s Foglight provides alerts for Postgres queries ...
One of the most valuable capabilities of Postgres is its support for concurrent ACID transactions. ACID is an acronym for Atomicity, Consistency, Isolation, and Durability. These database transaction properties help verify data validity. It is import…
Foglight 5.9.3 (core Foglight release) includes among its features new components for building dashboards called “analytic views”. The new view types are: Scatter Plot Chart, Bubble Chart and Tree Map Chart.
Specifically, I&rs...
What if you could get a list of all metrics and observations collected by Foglight, and have the ability to filter/sort by cartridge and topology type? That would be groovy.
My colleague Mark.Bai developed the script below. To run it, navigate to Adm…
What is VMware Cloud on AWS?
Quote from VMware – "VMware Cloud on AWS brings VMware’s enterprise-class SDDC software to the AWS Cloud with optimized access to AWS services. Powered by VMware Cloud Foundation, VMware Cloud on AWS integrate...
Simple Rule Editor simplifies the process of creating custom rules. The view of Simple Rule Editor contains the links that allows you to manage Infrastructure rules and alarms.
For more information, see the following topics:
Prerequisites...
To compare is to measure, estimate, or make note of two or more “ things’ “ similarities and/or differences. It helps us better understand the items. A versus B. Sometimes it is done to learn which one is ‘better’. Other...
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 version 12.0 which provides a display view of the …
A customer recently asked how it would be possible to get Spotlight for SQL Server Enterprise to show up on a big screen in their office. There are a number of ways.
A Windows desktop could be used to hook directly to the TV, and then the Spotl...
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 admin connection to the database. Or you might not …
A customer recently asked if the value that Foglight uses for email (to, cc, etc.) could be set to a different value at different times of the day. It can actually do one or the other, and with a little workaround, could do both.
Start on the Manage …
