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

Managing SQL Server Database Systems

Welcome to the Foglight for SQL Server User and Reference Guide. This guide comprises two different guides:
•
User guide—provides configuration instructions, conceptual information and instructions on how to use the Foglight for SQL Server cartridge. It describes the dashboards included with the cartridge and how they are used for collecting monitoring data from the entire relational database management system, as well as the cartridge’s interaction with and support of additional services and modules, such as replication and virtualization.
The user guide is intended for any user who wants to know more about monitoring SQL Server instances through Foglight for SQL Server, and the steps required for discovering and configuring the SQL Server agent. It is also meant for those users who want to learn about the methods used for configuring and applying user-defined settings.
•
Reference guide— describes the rules and collections that are available for the SQL Server monitored system.
The reference guide is intended for any user who wants to learn about the rules that are included with the cartridge, and the data collected by the Foglight for SQL Server agent.
The User and Reference Guide is organized as follows:
•
Using Foglight for SQL Server—the user guide.
•
Reference—contains reference information about the Foglight for SQL Server rules and collections.
Foglight for SQL Server User and Reference Guide
March 2016
Version 5.7.5.10
 

Introduction to this Guide

Welcome to the Foglight for SQL Server User and Reference Guide. This guide provides configuration instructions, conceptual information and instructions on how to use the Foglight for SQL Server cartridge. It describes the dashboards included with the cartridge and how they are used for collecting monitoring data from the entire relational database management system. Also covered are the cartridge’s interaction with and support of additional services and modules, such as replication and virtualization.
This guide is intended for users who wants to know more about monitoring SQL Server instances and the steps required for discovering and configuring the SQL Server agent. It is also meant for those users who want to learn about the methods used for configuring and applying user-defined settings.

Installation

Information regarding the installation of Foglight for SQL Server, its pre-requisites and permission can be found in the Foglight for SQL Server Getting Started Guide. You can view this guide on Dell’s website at http://documents.quest.com/Book/4517.
For further information to help you determine your environment’s hardware requirements, see the Foglight for SQL Server Hardware Sizing Guide, which is available at http://documents.quest.com/foglight-for-sql-server/5.7.5.1/foglight-for-sql-server-hardware-sizing-guide/
Installing and Configuring Agents
Foglight for SQL Server monitors the SQL Server database activity by connecting to and querying the SQL Server database. The agents provided monitor the SQL Server database system. The dashboards included with the cartridge provide a visual representation of the status of the major components of the SQL Server agents. They allow you to determine any potential bottleneck in database performance.
Upgrading to the Current Version
Starting to work with a Foglight for SQL Server cartridge requires upgrading to the current version of both the cartridge and the Foglight Agent Manager that runs the cartridge.
This section contains instructions for using the upgrade wizard.
* 
IMPORTANT: Foglight for SQL Server does not support the upgrade method of placing the new version under the folder FGLHOME/upgrade/cartridge folder.
* 
IMPORTANT: If upgrading to the current version of Foglight for SQL Server in a Federation architecture, the upgrade should be applied first to the stand-alone Management Servers (the Federated Children) and then to the central Management Server (the Federation Master).
If the Federation Master is upgraded first, this server displays incorrect information regarding the number of instances being monitored, as reported under the Status Summary section. All the same, this information is displayed correctly on the Federated Children.

Installing and Configuring Agents

Information regarding the installation of Foglight for SQL Server, its pre-requisites and permission can be found in the Foglight for SQL Server Getting Started Guide. You can view this guide on Dell’s website at http://documents.quest.com/Book/4517.
For further information to help you determine your environment’s hardware requirements, see the Foglight for SQL Server Hardware Sizing Guide, which is available at http://documents.quest.com/foglight-for-sql-server/5.7.5.1/foglight-for-sql-server-hardware-sizing-guide/
Foglight for SQL Server monitors the SQL Server database activity by connecting to and querying the SQL Server database. The agents provided monitor the SQL Server database system. The dashboards included with the cartridge provide a visual representation of the status of the major components of the SQL Server agents. They allow you to determine any potential bottleneck in database performance.
Upgrading to the Current Version
Starting to work with a Foglight for SQL Server cartridge requires upgrading to the current version of both the cartridge and the Foglight Agent Manager that runs the cartridge.
This section contains instructions for using the upgrade wizard.
* 
IMPORTANT: Foglight for SQL Server does not support the upgrade method of placing the new version under the folder FGLHOME/upgrade/cartridge folder.
* 
IMPORTANT: If upgrading to the current version of Foglight for SQL Server in a Federation architecture, the upgrade should be applied first to the stand-alone Management Servers (the Federated Children) and then to the central Management Server (the Federation Master).
If the Federation Master is upgraded first, this server displays incorrect information regarding the number of instances being monitored, as reported under the Status Summary section. All the same, this information is displayed correctly on the Federated Children.
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating