Chat now with support
Chat with Support

Foglight for SQL Server (Cartridge) 5.7.5.10 - User Guide

Managing SQL Server Database Systems Introduction to this Guide Using Foglight for SQL Server Monitoring Business Intelligence Services Administering Foglight for SQL Server Glossary Reference

Viewing Historical Metrics

The History section view is divided into two sections that are correlated to each other:
•
Resource consumption charts — This section displays data in five different charts:
•
Workload chart — Displays the instance resource activity over the selected time frame by emphasizing the resources by colors.
•
Breakdown chart — Activity of the instance by second.
•
Resource Breakdown Pie chart — Displays the resource breakdown usage by % of the total instance activity.
•
Overview section — Displays a graphical representation of the metrics highlighted in the Workload related Metrics table.
•
Workload related Metrics — A table that displays a variety of resource consumption metrics which can give an in-depth of the instance activity, each resource holds its default metrics.
Selecting each dimension in the performance tree together with a specific resource effects the data displayed for each Level. For example, by selecting the Lock resource, the Instance view dimension will present only locks related data, the Command dimension will present only the commands that were experiencing locks , Users will show only users that were experiencing locks and so on across all the dimensions and resources.

Viewing Change Tracking

The change tracking tool is an integrated monitoring mechanism. It periodically tracks changes in environments and activity that can potentially influence system performance. Use it to view correlation between occurrences of changes and Analysis Services activity and behavior patterns.
Use the Categories filter mechanism to refine the set of displayed change tracking occurrences. These categories are displayed on the right hand side of the pane and include:
•
MetaData — Report on changes to the Analysis Services server configuration and to the underlying database's schema.
•
System Configuration — Hardware and operating system configuration (for example, disks and network interfaces (NIC), amount of RAM, CPU count, device installations and swap space allocation).
•
User defined — Used for manually documenting user changes that may affect performance. Recording this activity can assist in determining whether a change in performance can be directly associated with this event

BI Administration Settings

To change the administration settings for multiple agents of the same type:
1
Select multiple agents of the same type: Integration, Reporting or Analysis services.
2
On the databases table toolbar, select Settings>Administration.
3
Select a category of settings on the left: Alarms or Connection Details.
A view containing related settings opens. The definitions under the Administration dashboard apply to all of the agents selected before opening the Administration dashboard.
4
Save changes made to the settings before selecting another category of settings.
* 
NOTE: To view the selected agents click the Selected Agents button at the upper right corner of the screen. If the settings vary between the selected agents the fields that contain non-identical values are displayed as empty and marked with an Inconsistent Values icon.

Defining Connection Details

Use the Connection Details category to redefine connection settings, which apply to one or all of the selected services hosts.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating