Using tokens for Foglight dashboard access
Some users only require simple access to Foglight dashboards, ideally being able to skip the logon step. In Foglight Server version 5.7.5.7, the user security option of an auth token was introduced. M...
Some users only require simple access to Foglight dashboards, ideally being able to skip the logon step. In Foglight Server version 5.7.5.7, the user security option of an auth token was introduced. M...
If you are someone who is responsible for administering Foglight when used for monitoring SQL Server Instances, you will likely run into the situation where you want certain databases to be neglected ...
In a previous post, I explained how to customize alarms in Spotlight on SQL Server Enterprise. Recently, I had a customer inquire how he could refine the "Days Since Last Full Backup" alarm. He wanted...
Some users only require simple access to Foglight dashboards, ideally being able to skip the logon step. The NoLoginUser was designed to allow the passing of a dashboard id via URL, and bypass the log...
Merriam-Webster defines ‘Custom’ as made or performed according to personal order. Tailored, fitted, personalized…or ‘pimped out’, slang meaning something is modified to extreme performance. There was...
Often times, excessive number of Java request types causes burden on the Foglight Management Sever and it affects the FMS performance. Also, You may not see the new request types from a newly added se...
A Picture is worth a thousand words! Execution plans can help us identify the performance hog sections of SQL code that impact CPU usage and I/O operations. Addressing these bottlenecks can ultimatel...
Managing production application databases has become more demanding than ever before not only due to the complexity of the applications they support, but also the very small margins for performance sl...
Updated in March 2021 - You now only need to check the "Use SSL" box when setting up your SQL Server connections in Foglight. This option appeared in the 5.9.x line of releases. A customer recentl...
Wondering where to find the Webmonitor metrics for use on a custom dashboard? You will find them on the Data tab, but there is no pre-defined category for them. Start by checking the "show all" box, a...
Tweaking performance monitoring to work exactly the way you want Spotlight on SQL Server comes ready out-of-the-box to help you navigate your SQL Servers’ performance metrics in real-time. The settin...
You can generate on-demand or scheduled reports in Foglight to a number of formats. These can be setup to be emailed at the time of generation, or they can be reviewed later via the Foglight UI (Repor...