Chat now with support
Chat with Support

Foglight for SQL Server (Cartridge) 5.7.5.30 - 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

Current Activity Dashboard

The current activity dashboard displays the list of current sessions and their state. The dashboard can be used to examine the amount of sessions connected, the status of the sessions and amount of resources they used.

Monitoring Analysis Service Performance

The Performance Investigator (PI) dashboard provides the ability to investigate the activity and resource consumption of a selected instance. The Analysis Service PI provides a more in-depth analysis by adding a dimension view of the activity, blocking history and change tracking analysis.
For additional information, refer to:
•
Performance Tree
•
Viewing Historical Metrics
•
Viewing Change Tracking

Resource Toolbar Options

The SSAS PI dashboard displays the following components:
•
The Instance View — Provides the ability to investigate and analyze the resource consumption of the instance.
•
The Resource toolbar — By selecting one of the resources, the resource consumptions charts and the overview section are updated to display only the relevant information regarding the activity of the selected resource.
The following resource are available:
•
Workload — Allows you to review the overall workload by gathering all resources into one view.
•
CPU — Allows you to review CPU usage.
•
I/O — Allows you to review the I/O-related data, such as wait time for I/O, reads and writes.
•
Memory — Allows you to review memory related waits and performance data, such as memory used, memory cache size and more.
•
Lock — Allows you to review blocks and deadlocks related information and identify blocked activities.
•
Remote — Allows you to review amount of time activities spent waiting for processing to finish on remote instances such as relational data sources
To review specific data metrics, select one of the specific metrics from the toolbar.

Performance Tree

The performance tree provides iterative (up to three levels) access to any of the key dimensions associated with
Analysis Services activity, based on the OLAP multidimensional model and an instance view of the instance activity. Domain nodes offer a hierarchical view of all types of SSAS activity characteristics. Selecting a dimension from the tree determines what subset of activity is displayed. Iterative drill-downs into domains of interest provides increasingly refined focus and diagnosis.
For example, to begin the investigation by first identifying the most active User, follow the steps described below:
1
Select the Users node, to display the most active users in the selected time range. That is, the users who consumed the highest amount of the selected resource.
2
Select the first user, to focus the entire window on the activity of that user.
3
Identify the most demanding Command that this specific user has executed, by expanding the user node and then selecting the Command dimension node. This displays the most active SQL statements executed by this user.
4
Select a specific Command to focus the entire window on the selected command's activity.
5
Select Client Machines under the selected Command, to view the computers which initiate the command.
In a similar manner, such iterative drilldowns can be carried out into any SSAS dimension of interest, to gain a complete understanding of the causes of its behavior.
The default Analysis Services dimensions are as follows:
•
Commands — The executed MDX, DMX and XMLA commands.
•
Databases — The database context in which the session carried out its operations. A session may switch to numerous databases within its lifetime.
•
Programs — Name of a program that connects to SSAS and executes the Command.
•
Users — Users running the client program.
•
Client Machines — The machines on which the client executable (connected to SQL Server) is running.
•
Command Types — Executed command type (for example, Batch, XMLA, SQL etc).
•
Sessions — Presents the top sessions which consumed the highest active time during the selected time frame.
•
Objects — Displays the top objects that were used by all activities running on the server,their association to other dimensions and the resources they used.
In the Commands dimension there is an option to view information regarding the selected command through the top Commands table top:
•
View Full Text — View full text of the statement\batch selected.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating