Chat now with support
Chat with Support

Foglight for SQL Server 5.7.5.1 - Foglight for SQL Server 5.7.5.1 Getting Started Guide

Introduction to this Guide

Welcome to the Foglight for SQL Server Getting Started Guide. This guide is a quick guide for the installation and use of Foglight for SQL Server, from the planning stage up to the actual monitoring of database instances.
This document details first the installation prerequisites, including the required permissions, and then the actual monitoring of database instances. This guide is intended for SQL Server database administrators.

Installing Foglight for SQL Server

Foglight for SQL Server is Dell Software's powerful diagnostic and problem resolution tool for Microsoft SQL Server databases. This Foglight cartridge delivers a global view that provides a visual instance health check, and enables a drill-down style diagnostic workflow to investigate the performance of monitored SQL Server instances and databases.
This chapter describes the installation of Foglight for SQL Server, from the planning stage up to the actual installation.

Installation Prerequisites

Before starting the installation of Foglight for SQL Server, ensure that the following conditions are met:
•
Having the required permissions; for details, see Permissions .
•
Using a supported system and platform.
Foglight for SQL Server’s system requirements and supported platforms are identical to those of Foglight Management Server. For details, see Foglight System Requirements and Platform Support Guide.
•
Using a Foglight license that allows cartridges to be installed. Alternatively, use the embedded trial license.
Ensure that the pre-existing Foglight license that is being used allows cartridge installation. If a license that does not allow cartridge installation is used, the installation wizard cannot proceed beyond the Foglight for SQL Server Management Server License screen, which requires specifying the type of license to be installed.
•
Using an available external database
 
* 
IMPORTANT: The available external database requirement is relevant only if you plan to install a new Foglight Management Server:
If you plan to install Foglight Management Server on an external database, ensure that this database is running.
The supported external database platforms and versions are as follows:
•
SQL Server
•
Oracle
•
MySQL
•
PostgreSQL
•
Preparing in advance a SQL Server user to be used for monitoring the discovered instances. The SQL Server user is created exclusively for monitoring a specific database, and has limited execution capabilities. The details of this SQL Server user are entered in the Connection Details dialog box when running the Database Discovery wizard (see Configuring Foglight for SQL Server ), and this user must be granted the privileges required for monitoring the database. These privileges can be granted only by a user with a SYSADMIN server role.

Installing Foglight for SQL Server

Foglight for SQL Server runs on the Foglight Management Server, which is its operation framework. Therefore, Foglight Management Server must be installed before installing the cartridge.
The installation of Foglight for SQL Server can be carried out using either of the following scenarios:
•
Installing both Foglight for SQL Server and Foglight Management Server.
•
Installing Foglight for SQL Server as a cartridge from within an existing Foglight Management Server.
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