Foglight for SQL Server 5.7.0 用户与参考指南

需积分: 35 127 浏览量更新于2024-07-22 收藏 2.39MB PDF 举报

"Foglight for SQL Server 是一款由 Dell 公司提供的性能管理和监控工具，主要用于Microsoft SQL Server数据库环境。此用户及参考指南详细介绍了Foglight 5.7.0版本的功能、使用方法以及相关参考信息。文档强调了其内容受版权保护，软件的使用需遵循许可协议条款，并且禁止未经授权的复制或传播。Dell公司明确指出，文档并未授予任何知识产权，并且对于其产品的任何知识产权，除非在产品许可协议中明确指定，否则不提供任何形式的明示或默示保修。" Foglight for SQL Server 是一个强大的监控和性能优化解决方案，它专为SQL Server设计，帮助管理员监控数据库的健康状况、性能指标和资源使用情况。以下是该工具的一些核心功能和知识点： 1. **实时监控**：Foglight 提供了实时的性能数据视图，允许管理员快速识别和解决问题。这包括CPU使用率、内存消耗、磁盘I/O以及查询性能等关键指标。 2. **预警和警报**：系统可以设置阈值，当性能指标超出预设范围时，会触发警报，帮助管理员及时发现并预防潜在的问题。 3. **性能分析**：Foglight 包含了深入的性能分析工具，能诊断SQL查询的效率，找出慢查询并提供优化建议，以提升整体数据库性能。 4. **容量规划**：通过收集历史数据，Foglight 可以预测未来资源需求，为数据库的扩展和优化提供决策支持。 5. **报告与报表**：工具提供了丰富的报告功能，可以自定义报告内容，包括性能趋势、资源利用率、问题总结等，方便管理层了解数据库状态。 6. **用户管理**：Foglight 支持多用户访问和权限控制，确保不同角色的管理员可以访问适合他们职责的信息。 7. **集成与扩展**：Foglight 可以与其他IT管理工具集成，如SCOM（System Center Operations Manager），增强了整个IT环境的管理能力。 8. **版本5.7.0特性**：尽管具体更新内容未详述，通常新版本会包含性能提升、新的监控指标、增强的用户体验或更全面的平台支持。在使用Foglight for SQL Server 时，管理员应仔细阅读官方提供的用户和参考指南，理解每个功能的用途，正确配置和使用工具，以充分发挥其潜力，确保SQL Server环境的稳定性和高效运行。同时，了解Dell的许可政策和保修条款，以避免违反规定并确保合规性。

Foglight for SQL Server Version 5.7.0

User and Reference Guide

Figure 4. Exporting the list of registered servers.

To prepare a Regserv file:

1 Create a new file.

2 Assign the file a descriptive name, such as imported_instances.regsrvr.

3 In this file, type the connection details for each instance in a separate row.

Foglight for SQL Server supports monitoring of both named instances and default instances.

Use the following format for named instances:

<DB type (MSSQL)>,<host1 name>,<instance1 name>,<DB port (0 for default)>.

For default instances use the following format:

<DB type (MSSQL)>,<host1 name>,,<DB port (0 for default)>.

The following examples show how to enter named instances (the first and second instances) and default

instances (the third and fourth instances).

MSSQL,MyHost1,MyInstance1,0

MSSQL,MyHost2,MyInstance2,1434

MSSQL,MyHost1,,0

MSSQL,MyHost2,,1434

4 Save the file.

To import the predefined Regserv file:

1Click Add instances.

2Click Import from file.

The dialog box Import SQL Server Instances from File appears.

3Click Choose file.

4 Browse for the selected file.

5Click Import.

At the end of this process a table appears, displaying the instances whose connection details appear in

the file.

6 Select the instances to be monitored.

7Click Finish.

The newly added instance now appears on the table, with the status Set credentials.

Foglight for SQL Server Version 5.7.0

User and Reference Guide

8 Proceed with the wizard, starting from Step 5 on page 12.

Configuring Multiple Instances for

Monitoring using Silent Installation

To add multiple agents using the silent installation through a command line interface:

1 Navigate to Administration > Cartridges > Components for downloads.

2Click the download icon in the Installer column to download DB_SQL_Server_CLi_Installer row.

The Download Message dialog box appears.

3 Review the details in this dialog box, and click Download.

The downloaded ZIP file contains the following files:

• README.txt file

• mssql_cli_installer.groovy — a groovy script file that runs the silent installation. This file

should be copied to the <FMS_HOME>/bin directory.

• silent_installer_input_template.csv — a template file that should serve as the basis

for inserting contents into the input CSV file. This file can be copied to any folder of your choice,

provided that the path indicated by the <csv_instances_file_name> parameter (see below)

points to the selected path. For details about the contents of this file, see Contents of the Input

CSV File on page 18

4 Extract the ZIP file to a directory of your choice.

5Copy the mssql_cli_installer.groovy file to the <FMS_HOME>/bin directory.

6 Go to the command line and execute the command: <FMS_HOME>/bin/fglcmd -srv

<fms_host_name> -port <fms_url_port> -usr <fms_user_name> -pwd

<fms_user_password> -cmd script:run -f mssql_cli_installer.groovy fglam_name

<fglam_name> instances_file_name <csv_instances_file_name> lockbox_name

<lockbox_name> lockbox_password <lockbox_password>

The descriptions of the flags and parameters in this command are as follows:

• <FMS_HOME>: The Foglight Management Server installation directory.

• <fms_host_name>: Name of the host where the Foglight Management Server is installed.

• <fms_url_port>: The Foglight Management Server port.

• <fms_user_name>: The user name used for connecting to the Foglight Management Server.

• <fms_user_password>: The password of the specified user.

• <clusters_file_name>: The full path and the name of the input CSV file.

• <lockbox_name>: Optional — specifies the name of an existing lockbox to be used.

• <lockbox_password>: Optional — the selected lockbox's password.

7 After the installation process completes, review the CSV files that are created in the same folder where

the input file resides:

• A file with the input file's name and _status suffix (for example: if the input file is named

input, this file is named input_status).

This file indicates the monitoring situation of all SQL Server instances listed in the input CSV file.

If monitoring failed for one or more of the instances, the file specifies the error message.

Foglight for SQL Server Version 5.7.0

User and Reference Guide

The _status file includes the name of the monitored Foglight for SQL Server agent, the result of

the monitoring validation process - MONITORED, FAILED, or AGENT EXISTS - and the error

message, in case the agent creation failed.

• A file with input file's name and _new suffix (for example: if the input file is named input, this

file is named input_status).

This file, which is only created if one or more instances failed the monitoring validation, contains

all details about these instances.

Using this CSV file, the user only needs to fix the errors and re-run the script, this time by

specifying this file as the input file, that is: the original file name with suffix _new. In the

example used here, the new file should be named input_new.csv.

Contents of the Input CSV File

The input CSV file contains the following fields, which are used as columns in the resulting file:

IMPORTANT: If all instances listed in the input CSV file passed the monitoring

validation successfully, no additional file is created.

Table 1. Input CSV File

Name Description

Host name The SQL Server host name.

Instance name The name of the SQL Server instance.

DB port (Optional)

The SQL Server instance port. If no value is inserted in this field, the port

number should match the instance name.

DB credentials Type

(Optional)

DB authentication type. The possible values are:

• Windows_Default_Account

• Windows_Custom_Account

• SQL_Server_Authentication

If this field is left empty, the Windows_Default_Account option is used.

DB user name (Optional)

The user name required for connecting to the database, if the

Windows_Default_Account authentication type was selected.

DB password (Optional)

The password of the database user name that was selected if the

Windows_Default_Account authentication type was selected.

DB power user credentials

Type (Optional)

The type of database authentication of a user that can grant privileges to

the regular database user. The possible values are:

• Windows_Default_Account

• Windows_Custom_Account

• SQL_Server_Authentication.

If this field is left empty, the grant privileges script will not run.

DB power user name

(Optional)

The user name of a user that can grant privileges to the regular database

user.

DB power password

(Optional)

The password of the database power user name mentioned above;

required only if the regular user does not have sufficient privileges.

Should monitor OS

Specifies whether to create an Infrastructure Cartridge agent for the

given host name; the possible values are either True or False.

Foglight for SQL Server Version 5.7.0

User and Reference Guide

Configuring the On Demand Data Port on the Agent

Manager Concentrator

If a firewall is installed between the Management Server and the Agent Manager, a bidirectional On Demand

Data Port connection is not possible because On Demand data requests require direct connection.

This issue can be resolved by creating an On Demand Data Port on the concentrator - an Agent Manager instance

that works similarly to an HTTP proxy. This On Demand Data Port can be configured to accept On Demand data

requests from the Management Server and direct them to the Agent Manager instances (called downstream

instances). For additional details about the concentrator, see Configuring an Agent Manager Instance as a

Concentrator in the Agent Manager Installation Guide.

Figure 5. On Demand Data Port connection with firewalls installed.

OS credentials Type

(Optional)

OS authentication type; can have one of the following values:

• Windows_Default_Account

• Windows_Custom_Account

If this field is left empty, the Windows_Default_Account value is used by

default.

OS user name (Optional)

The user name required for connecting to the OS if the

Windows_Default_Account option was selected. The user name should be

compatible with the selected authentication type.

If the Windows_Default_Account value was selected, this field can be left

empty.

OS password (optional)

The password of the OS user specified above; if the

Windows_Default_Account option was selected, this field can be left

empty.

Enable VMware Collection

(Optional)

Specifies whether to monitor VMware metrics; the possible values are

either True or False.

VMware Host (Optional) The VMware host name.

VMware Port (Optional)

The VMware port. If no value is inserted in this field, the port number will

used the default port number 443.

VMware User Name

(Optional)

The user name required for connecting to the VMware.

VMware Password

(Optional)

The password of the VMware user specified above.

Table 1. Input CSV File

Name Description

Foglight for SQL Server Version 5.7.0

User and Reference Guide

A concentrator agent, created specifically for Foglight for SQL Server, allows controlling the On Demand Data

Port so that the server is initialized (starts collecting data) when the agent starts, and stops when data retrieval

by the agent is brought to an end. The agent, which is created manually by the user, requires configuring the

following parameters:

• A list of the downstream hosts that are connected through the concentrator

• The RMI port number

Each time the Foglight Management Server sends RMI request, the list of downstream hosts submitted by the

concentrator agent is being searched, as follows:

• Inclusion of the target RMI server host name within this list indicates that a FglAM concentrator exists, in

which case a connection is made to the proxy RMI server.

• If the list does not contain the target host name, the connection is made directly to the target On

Demand data port server.

To create the concentrator agent:

1Go to Dashboards > Administration > Agents > Agent Status.

2Click Create Agent.

3 Select the agent type DB_SQL_Server_Concentrator.

4 Enter a name of your choice.

5Click Create.

6 After the creation process is completed successfully, click OK.

To edit the concentrator agent connection details:

1 Select the newly created concentrator agent.

2Click Edit Properties.

3Click Modify properties for this agent only.

4 Enter the number of the proxy On Demand Data Port server port, or accept the default number.

5 Enter the concentrator Foglight Agent Manager host name (optional).

6Click Edit to edit the list of downstream Agent Managers.

7Click Add Row.

8 Enter the name of the requested Foglight Agent Manager host.

9Repeat Step 7 to Step 8 as many times as required.

10 Click Save Changes.

11 Click Save at the lower right corner of the screen.

12 Click Back to Agent Status.

13 Select the newly created concentrator agent.

14 Click Activate.

15 Click OK to complete the process.

IMPORTANT: When editing the properties of the Foglight Agent Manager concentrator (Dashboards

> Administration > Agents > Agent Status), the name of the Foglight Agent Manager should be

entered in the Downstream FglAMs section exactly as it appears in the topology, under Home >

Agents > All agents > <Agent name> > RMI data > Fglam host property. The <Agent name>

parameter refers to any of the Foglight for SQL Server agents that reside on the selected Foglight

Agent Manager.

剩余286页未读，继续阅读

Eosin_Chioa

粉丝: 0
资源: 4

Foglight for SQL Server 5.7.0 用户与参考指南

Quest-SharePlex数据库复制解决方案

Foglight隨時掌控系統資源

FogLight中文文档

dw3000_software_api_guide

armasm_user_guide.pdf

ansys_mechanical_users_guide

rockchip_driver_guide_vi_cn_v1.1.1.pdf

rockchip_developer_guide_linux_wifi_bt_cn.pdf位置

ansys_fluent_tutorial_guide_2022

modbus_messaging_implementation_guide_v1_0b

最新资源