Chat now with support

Live-Hilfe anfordern
Registrierung abschließen

Anmelden

Preisinformationen anfragen

Vertrieb kontaktieren

Kostenlose Testversionen

Foglight for SQL Azure 5.5.8.6 - User Guide

Inhaltsnavigation

Introducing Foglight for SQL Azure

Foglight for SQL Azure Summary View Reviewing the Databases Dashboard

Currently Selected Group

Selecting the Database to be Monitored

Filtering the Display by Severity Creating Custom Database Groups Previewing the Requested Database Components Shared by all Foglight for SQL Azure Screens

Viewing the Foglight for SQL Azure Summary

Identifying the Instance Monitoring Alarms Reviewing the Estimated Costs Tracking the Instance Data Flow Monitoring the Database Activity and Storage

Reviewing frequently requested statistics

Adding and Configuring Agents

Studying the Foglight for SQL Azure Architecture Running the Database Discovery Wizard

Carrying Out the Automatic Discovery Process

Reviewing SQL Azure Activity

Viewing In-depth Data about the Instance

Tracking Current Lock Conflicts

Handling blocking sessions Monitoring blocked processes for the sampled interval

Tracking Historical Lock Conflicts Viewing Detailed Sessions Data

Monitoring the active/inactive sessions ratio Monitoring the foreground/background sessions ratio Viewing the workload incurred by a single session's activity Viewing the Session Details page

Tracking Top SQL Statements Data

Top SQL Statements table SQL Activity section SQL Statement Details page

Monitoring Bandwidth Usage

Reviewing bandwidth usage and estimated costs Reviewing external data transfer Reviewing internal data transfer

Reviewing Database Usage

Viewing the Database's Storage-related Data

Reviewing the Database's Tables and Indexes

Reviewing tables' space usage Reviewing indexes for a selected table Indexes table Index Details Index Density table Index Histogram table

Reviewing the Storage Growth and the Cost-related Results

Reviewing the database properties Reviewing the database growth and the resulting storage price Reviewing the ratio between the database's tables and indexes Reviewing the top-fastest growing tables and indexes by size Reviewing the growth of a specific database object

Reviewing the Estimated Storage Cost

Reviewing the Estimated Storage Cost per Day Reviewing the Estimated Total Storage Cost Reviewing the Estimated Storage Cost Changes

Reviewing the Database Properties

Viewing the Database and Master Database Properties

Reviewing the Instance's Version-related Information Reviewing the Remote Users' Firewall Settings Reviewing the Monitored Database's Properties

Monitoring Estimated Costs

Viewing the Database's Pricing Plan and Estimated Costs

Reviewing the Pricing Plan and its Effect on Estimated Costs

Viewing the user account settings Viewing the storage and bandwidth usage prices Monitoring estimated costs

Reviewing the Storage Utilization the Cost-related Results

Reviewing the Estimated Storage Cost Changes Reviewing the Total Storage Cost Calculation

Reviewing Bandwidth Utilization and Cost-related Results

Reviewing the Estimated Changes of Bandwidth Usage Cost Reviewing the bandwidth usage cost calculation

Viewing User Metrics

Viewing User-Defined Collections

Using the Global Administration Options

Reviewing the Global Administration Settings Defining the Connection Settings for the Monitored Databases Defining Data Collection and Storage Options Configuring User-defined Collections

Editing user-defined collections

Configuring the On-demand Data Port Defining Alarms

Reviewing all Existing Alarms Viewing and Editing the Alarm Settings

Defining Thresholds

Configuring Alarm-triggered Email Notifications Configuring Foglight Mail Server

Configuring Usage Costs Setting the User Account

Reviewing Foglight for SQL Azure Alarms

Alarms Displayed in the Databases Table

Collection Status

Alarms Displayed in the Summary's Database Pane

Bandwidth Usage Baseline Deviation Connection Time Instance/Database Unresponsive Response Time

Alarms Displayed in the Blocking (History) Panel

Long Lock Running

Alarms Displayed in the Sessions Panel

Total Connections Baseline Deviation All Active Connections Baseline Deviation Blockers Connections Baseline Deviation

Alarms Displayed in the Top SQL Statements Panel

Executions Baseline Deviation Total CLR Time Baseline Deviation Total I/O Baseline Deviation

Alarms Displayed in the Storage Panel

Database Reaching Maximum Limit Capacity Database Requires Change in Edition Database Reaching Current Limit Capacity Database Wrong Edition Used Database Current Limit Resized

Alarms Displayed in the Database Properties Panel

Database Property Changed

Alarms Resolved via the Cost Configuration Administration Screen

Cost Was Not Set Cost Changed

Batch BCP (Bulk Copy Program) Blocking Books Online Bulk copy Bulkinsert Bulk load CAL Calibration Cardinality Cartridge Chart Client network utility CLR Compile Connect Connection Connectivity software Cursors Data access components Data storage engine Database Database object DataFlow DBCC DBID DBO Deadlock Density DMO Drilldown Execution contexts Extent Foglight Agent Manager Foglight Management Server Foreign key Full text search GAM GUID Hashing Heap Hit rate Hit ratio In-row data Index Indid Kill Licensing Lock Lock escalation Lock mode Logical I/O LRU LSN Master MDAC Metric Null OBID Object plans OLTP Optimizer Panel Parse Parser Per seat licensing Per server licensing Physical read Physical write Pinned Plan Prepared SQL plans Primary key Procedure cache Procedure plans Process Pulse Query plan Random I/O Read ahead Recompile Referential integrity Relational data engine Role Rollback Schema locks Sequential I/O Session Severity SGAM Sort, Hash, Index Area SPID (Session ID) Spike Spinner SQL Plans SQL Server Agent SQL Server books online Standard deviation Stolen pages Stored procedure Temporary tables and table variables Threshold Transaction Trigger Trigger plans Truncate Waitfor

Reviewing Foglight for SQL Azure Alarms

Alarms are the warnings that Foglight for SQL Azure raises when a metric falls outside its “normal” range of values, which is defined by setting thresholds and severities for the metric within the Metric editor. A new alarm is raised whenever the severity for a metric changes. When the severity returns to normal, the alarm is canceled.

This lists the various methods that the Foglight for SQL Azure home page uses for displaying alarms.


	NOTE: For a complete list of alarms invoked by Foglight for SQL Azure, including replication-related alarms, see Foglight for SQL Azure Alarms in the Foglight for SQL Azure Reference Guide.

Alarms Displayed in the Databases Table

Several alarms can be investigated via the Databases table, under Dashboards > Databases > Databases, as described in the following :

•

Collection Status on page 73

•

Connection Time—available also via the Summary > Database pane; see Connection Time on page 74

•

Instance/Database Unresponsive—available also via the Summary > Database pane; see Instance/Database Unresponsive on page 74

Collection Status

The Collection Status alarm is invoked when the instance or database agent fails to collect data. This alarm is displayed on the Alarms column of the Databases table, and allows further investigation via a link, depending on the agent’s type:

•

Global administration—for an instance agent

•

Summary screen—for a database agent

Alarms Displayed in the Summary's Database Pane

Several alarms can be investigated via the Summary’s Database pane and network packet flows, as described in the following :

•

Alarms Displayed in the Blocking (History) Panel on page 75

•

Connection Time on page 74

•

Instance/Database Unresponsive on page 74

•

Response Time on page 74

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen