Foglight for SQL Server (Cartridge) 5.9.3.20


Display Name	Description
Database	The database name
Is Hidden	Indicates whether there is a hidden CLR assemble within the selected database.
Is External	Indicates whether there is an external CLR assemble within the selected database.
Is Unsafe	Indicates whether there is an unsafe CLR assemble within the selected database.

Cluster Summary

Purpose

This collection provides information on the state of the currently monitored cluster environment, as shown in the Cluster Administration application.

Type

SQL Server.

Collection Sampling Intervals


Frequency Mode	Collection Interval (In Seconds)
Real-time	900
Online	900
Offline	14400

Collection Metrics


Display Name	Description
ID	The unique identifier for the specified resource in the cluster.
Parent ID	The parent ID of the node’s vertical level.
Type	The type of resource (Resource group).
Name	The resource name.
Status	The status of the cluster resource.
Comment	A brief description of the specified cluster resource (if available).
Other Data	The group to which the resource belongs.
Icon Flag	A flag indicating whether there is an error.
Take Offline Cmd	A flag indicating the existence of a command that runs when the resource goes offline.
Bring Online Cmd	A flag indicating the existence of a command that runs when the resource goes online.
Move Group Cmd	A flag indicating the existence of a command that runs when the resource is moved to another group.
Stop MSCS Cmd	A flag indicating the existence of a command that runs when the resource is stopped.
Start MSCS Cmd	A flag indicating the existence of a command that runs when the resource is started.
Running On Preferred Server	A flag indicating whether the node is running on a server that appears on the preferences list.
Controls The Current SQL Server	A flag indicating whether the node is currently controlling the SQL Server.
Running On Server	Indicates the host (server) on which the selected node is running.
Non Active Node Available	Indicates which non-active SQL Server nodes are currently not running.
Can Accept Move	A flag indicating whether the resource can accept being moved to another group.

Configuration

This collection provides a list of the values that are configured and running in the SQL Server instance.

Type

SQL Server.

Collection Sampling Intervals


Frequency Mode	Collection Interval (In Seconds)
Real-time	3600
Online	3600
Offline	86400

The value to which the configuration option is set. This value may not be implemented immediately upon creation. Usually, restarting SQL Server is necessary before any change takes effect.

Description

A description of the specified configuration option.

Last Change

The date when the value was last changed.

Last Run Value

The most recent value, set during the last modification.

Max

The maximum permitted value for the configuration option.

Min

The minimum permitted value for the configuration option.

Modifiable

Indicates when changes to the option take effect.

The following options are possible:

•

Immediate: changes to these options take effect immediately.

•

Restart: changes to these options take effect after SQL Server is stopped and restarted.

•

Never: these options cannot be modified.

Name

The name of the specified configuration option.

Run Value

The value currently used by the configuration option.

Database Index Density Vectors

This collection provides a list of density values for each combination of columns in a specific database index.

Type

SQL Server.

Collection Sampling Intervals

This collection is an on-demand collection, which has no pre-defined sampling intervals.

Collection Metrics


Display Name	Description
All Density	Density is the term used by SQL Server to represent the selectivity of the index columns. The more selective an index is, the more useful it is in searches. Calculated as 1 / distinct values for all values in the first key column of the statistics object, excluding the histogram boundary values. This Density value is not used by the query optimizer, and is displayed for backward compatibility with versions prior to SQL Server 2008.
Avg Key Length	Average number of bytes per value for all of the key columns in the statistics object.
Columns	The names of the columns in the index.

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação

Selecione seu produto:

Para podermos atendê-lo melhor, informe o Propósito de seu chat:

Soluções recomendadas para seu problema

Foglight for SQL Server (Cartridge) 5.9.3.20 - User Guide

CLR Assemblies

Cluster Summary

Configuration

Database Index Density Vectors