Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

VERSIONI DI PROVA GRATUITA

Foglight for SQL Azure 5.5.8.6 - User Guide

Table of Contents

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 the Storage Growth and the Cost-related Results

The Database Storage panel allows reviewing database storage utilization during the specified time range and its effect on costs.


	IMPORTANT: The default time range of the Database Storage panel is Last 24 hours.

Using this panel allows carrying out the following tasks:

•

Reviewing the database user account and cost settings—using the Properties section. For details, see Reviewing the database properties on page 45.

•

Reviewing the database growth and its effect on estimated costs—using the Database Growth section. For details, see Reviewing the database growth and the resulting storage price on page 45.

•

Reviewing the top-fastest growing tables and indexes by size—using the Top Fastest Growing Tables & Indexes section. For details, see Reviewing the top-fastest growing tables and indexes by size on page 46.

•

Reviewing the growth of a specific database object—using the Growth of: section, which displays the growth of the database object (either a table or an index) selected in the Top Fastest Growing Tables & Indexes table. For details, see Reviewing the growth of a specific database object on page 47.

Reviewing the database properties

The Properties section provides a summary of the database properties, by displaying the following settings, which are shown in various sections of the SQL Azure home page:

•

Data center—the name of the data center to which the instance reports. This name can be either user-defined or selected from Microsoft’s list.

•

Windows Live ID—the sign-in credentials (email and password) used for entering all Windows Live services.


	IMPORTANT: If the data center and Windows Live ID have not yet been configured, both fields display a link that leads to the User Account global administration screen, used for defining these settings. This configuration is carried out at the instance level and applies to all databases within the instance. For more information, see Setting the User Account on page 71.

•

Database edition—the database’s edition type; either Web or Business.

•

Maximum Limit—the maximum storage limit allocated to the database.


	NOTE: While exceeding the maximum storage limit in the Web edition can be resolved by switching to Business edition, exceeding the maximum storage limit in Business edition requires coordination with Microsoft.

•

Price per GB—the storage price per GB.

The storage price per GB is configured via the Cost global administration screen. For more information, see Configuring Usage Costs on page 71.

Reviewing the database growth and the resulting storage price

The Database Growth section allows reviewing the changes of the database size within the specified time range, using the following views:

•

Total—displays the total change of the database size

•

Breakdown—displays the database growth by the following components:

•

Current limit—indicates the declared size the database can currently reach before resizing per the edition used.

•

In Row—the amount of space, in megabytes, reserved for in-row data types within all tables and indexes in the database

•

LOB—the amount of space, in megabytes, reserved for large object (LOB) data types within all tables and indexes in the database

•

Maximum limit—the maximum size the database can reach (varies between Web edition and Business edition)

•

Row overflow—the amount of space, in megabytes, within the table that is reserved for data types whose combined widths can exceed the maximum limit defined for a row, namely: varchar, nvarchar, varbinary, and sql_variant

Reviewing the ratio between the database's tables and indexes

The Tables-Indexes Ratio section allows reviewing the efficiency of index utilization within the database, by examining the ratio between tables and indexes by the following parameters:

•

Percent—percentage of space usage

•

Megabyte—actual space usage

•

Cost—the cost charged for space usage by either tables or indexes

Ratio that exceeds a predefined threshold can indicate inefficient index usage, which can result from indexes that require rebuild or that are no longer necessary.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione