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

About Monitoring Extensions

During the installation process you can choose to install and configure one or more of the monitoring extensions. The monitoring extensions provide a more in-depth analysis of the monitored instance and the environment it is running on, creating a whole and unified status.
Understanding the Foglight for SQL Server Architecture
The communication architecture of Foglight for SQL Server is presented below.
Figure 2. Communication Architecture overview.
SQL Performance Investigator Extension
SQL Performance Investigator allows you to rapidly identify bottlenecks, anomalies, and application trends by focusing on top resource consumers and providing multi-dimensional SQL domain drilldowns. SQL PI allows you to:
•
Monitor real-time SQL Server database performance at a glance
•
Gather and diagnose historical views
•
Identify and anticipate performance issues
•
Analyze and optimize execution plan changes
•
Compare day-to-day values to identify anomalies and application changes
 
* 
NOTE: SQL Performance Investigator requires a license. If you are using a trial version and would like to request pricing, contact https://quest.com/register/57891.
* 
NOTE: SQL PI requires a repository database that is installed automatically on the Agent Manager.
Operating System Extension
Monitoring the operating system allows you to identify resource consumption and provides a full view of the server health. An Infrastructure agent, which is created automatically as part of the monitoring process, monitors the operating system.
 
* 
NOTE: The Operating System extension is enabled by default.
VMware Extension
Monitoring the VMware system allows you to identify resource consumption and provides a full view of the data center and ESX health when the server is part of a VMware environment.

Understanding the Foglight for SQL Server Architecture

During the installation process you can choose to install and configure one or more of the monitoring extensions. The monitoring extensions provide a more in-depth analysis of the monitored instance and the environment it is running on, creating a whole and unified status.
Understanding the Foglight for SQL Server Architecture
The communication architecture of Foglight for SQL Server is presented below.
Figure 2. Communication Architecture overview.
SQL Performance Investigator Extension
SQL Performance Investigator allows you to rapidly identify bottlenecks, anomalies, and application trends by focusing on top resource consumers and providing multi-dimensional SQL domain drilldowns. SQL PI allows you to:
•
Monitor real-time SQL Server database performance at a glance
•
Gather and diagnose historical views
•
Identify and anticipate performance issues
•
Analyze and optimize execution plan changes
•
Compare day-to-day values to identify anomalies and application changes
 
* 
NOTE: SQL Performance Investigator requires a license. If you are using a trial version and would like to request pricing, contact https://quest.com/register/57891.
* 
NOTE: SQL PI requires a repository database that is installed automatically on the Agent Manager.
Operating System Extension
Monitoring the operating system allows you to identify resource consumption and provides a full view of the server health. An Infrastructure agent, which is created automatically as part of the monitoring process, monitors the operating system.
 
* 
NOTE: The Operating System extension is enabled by default.
VMware Extension
Monitoring the VMware system allows you to identify resource consumption and provides a full view of the data center and ESX health when the server is part of a VMware environment.

SQL Performance Investigator Extension

During the installation process you can choose to install and configure one or more of the monitoring extensions. The monitoring extensions provide a more in-depth analysis of the monitored instance and the environment it is running on, creating a whole and unified status.
Understanding the Foglight for SQL Server Architecture
The communication architecture of Foglight for SQL Server is presented below.
Figure 2. Communication Architecture overview.
SQL Performance Investigator allows you to rapidly identify bottlenecks, anomalies, and application trends by focusing on top resource consumers and providing multi-dimensional SQL domain drilldowns. SQL PI allows you to:
•
Monitor real-time SQL Server database performance at a glance
•
Gather and diagnose historical views
•
Identify and anticipate performance issues
•
Analyze and optimize execution plan changes
•
Compare day-to-day values to identify anomalies and application changes
 
* 
NOTE: SQL Performance Investigator requires a license. If you are using a trial version and would like to request pricing, contact https://quest.com/register/57891.
* 
NOTE: SQL PI requires a repository database that is installed automatically on the Agent Manager.
Operating System Extension
Monitoring the operating system allows you to identify resource consumption and provides a full view of the server health. An Infrastructure agent, which is created automatically as part of the monitoring process, monitors the operating system.
 
* 
NOTE: The Operating System extension is enabled by default.
VMware Extension
Monitoring the VMware system allows you to identify resource consumption and provides a full view of the data center and ESX health when the server is part of a VMware environment.

Operating System Extension

During the installation process you can choose to install and configure one or more of the monitoring extensions. The monitoring extensions provide a more in-depth analysis of the monitored instance and the environment it is running on, creating a whole and unified status.
Understanding the Foglight for SQL Server Architecture
The communication architecture of Foglight for SQL Server is presented below.
Figure 2. Communication Architecture overview.
SQL Performance Investigator Extension
SQL Performance Investigator allows you to rapidly identify bottlenecks, anomalies, and application trends by focusing on top resource consumers and providing multi-dimensional SQL domain drilldowns. SQL PI allows you to:
•
Monitor real-time SQL Server database performance at a glance
•
Gather and diagnose historical views
•
Identify and anticipate performance issues
•
Analyze and optimize execution plan changes
•
Compare day-to-day values to identify anomalies and application changes
 
* 
NOTE: SQL Performance Investigator requires a license. If you are using a trial version and would like to request pricing, contact https://quest.com/register/57891.
* 
NOTE: SQL PI requires a repository database that is installed automatically on the Agent Manager.
Monitoring the operating system allows you to identify resource consumption and provides a full view of the server health. An Infrastructure agent, which is created automatically as part of the monitoring process, monitors the operating system.
 
* 
NOTE: The Operating System extension is enabled by default.
VMware Extension
Monitoring the VMware system allows you to identify resource consumption and provides a full view of the data center and ESX health when the server is part of a VMware environment.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating